Skip to content
sqlkitty

sqlkitty

sql for everyone

Menu
  • Home
  • About
  • Auditing
  • Boulder SQL
  • Presenting/Talks
  • Publications
  • Volunteering
  • Contact

Month: January 2011

pause break button to pause computer startup

  • Posted onJanuary 18, 2011
  • network administration

push pause/break button repeatedly while booting to see the options for the BIOS

Continue Reading

linked sql server

  • Posted onJanuary 18, 2011
  • sql server administration

in order to take more than 1 hop – you must have kerberos setup to check if it is – run this: select auth_scheme from sys.dm_exec_connections where session_id=@@spid if it is running ntlm – you can only take 1 hop for example – if you…

Continue Reading

multiserver results options

  • Posted onJanuary 11, 2011
  • sql server administration

To change the multiserver results options In Management Studio, on the Tools menu, click Options. Expand Query Results, expand SQL Server, and then click Multiserver Results. On the Multiserver Results page, specify the option settings that you want, and then click OK.

Continue Reading

create a server group

  • Posted onJanuary 11, 2011
  • sql server administration

In Registered Servers, click the server type on the Registered Servers toolbar. If Registered Servers is not visible, click Registered Servers on the View menu. Right-click a server or a server group, point to New, and then click Server Group. In the New Server Group…

Continue Reading

changing sa password

  • Posted onJanuary 11, 2011
  • sql server administration

Login into SQL Server using Windows Authentication. In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties. Change SA password, and confirm it. Click OK. Make sure to restart the SQL Server and all its services and…

Continue Reading

always always always use BEGIN TRANSACTION before updating database with query

  • Posted onJanuary 11, 2011
  • sql sever syntax

so that you can rollback if you don’t get the expected results using rollback transaction if you don’t use BEGIN TRANSACTION, then you will have to revert the database to a backup to restore the data if you get the expected results from the transaction,…

Continue Reading

copy table from database to another

  • Posted onJanuary 10, 2011
  • sql server administration

SELECT * INTO AdventureWorks.dbo.CustomersTemp FROM Northwind.dbo.Customers Just remember that using this query will only transfer the schema and data. It does not transfer the indexes, foreign keys, statistics etc.

Continue Reading

checking sql server performance

  • Posted onJanuary 6, 2011
  • sql server administration

select * from sys.dm_os_performance_counters

Continue Reading

determining the ss server name

  • Posted onJanuary 5, 2011
  • sql server administration

SELECT @@SERVERNAME

Continue Reading

To run performance monitor on a remote system

  • Posted onJanuary 4, 2011
  • network administration

You need to run the Performance Monitor service under a domain account that has privileges to the system you want to monitor.  You cannot use NT AUTHORITYNetworkService. To start the Performance Logs and Alerts service under a different account: Right-click My Computer, and then click…

Continue Reading

Posts navigation

Page 1 Page 2 Next Page

Subscribe to SQL Kitty

loader

Email Address*

Name

Recent posts

  • New Job -> Week 3 -> Creating Alerts
  • New Job -> Week 2 -> Creating a Checklist
  • New Job -> Week 1 -> What Tools Do You Need?
  • Creativity in Technology
  • Documentation vs Automation

Categories

  • Azure (2)
  • containerization (12)
  • dba (5)
  • editorial (1)
  • excel and others (3)
  • IT Certifications (1)
    • network+ (1)
  • linux (2)
  • network administration (15)
  • newjob (3)
  • other (3)
  • postgresql (5)
  • security (1)
  • SQL Server (11)
  • sql server administration (114)
    • jobs (2)
  • sql sever syntax (77)
  • web dev (6)
  • zen (1)

Archives

  • March 2023 (5)
  • January 2023 (1)
  • October 2022 (2)
  • April 2022 (1)
  • December 2021 (1)
  • May 2021 (1)
  • April 2021 (2)
  • February 2021 (7)
  • January 2021 (5)
  • December 2020 (2)
  • November 2020 (1)
  • January 2020 (2)
  • December 2019 (3)
  • August 2019 (2)
  • February 2019 (1)
  • June 2018 (1)
  • January 2018 (1)
  • September 2017 (1)
  • May 2016 (4)
  • January 2016 (2)
  • December 2015 (2)
  • August 2015 (2)
  • July 2015 (4)
  • June 2015 (3)
  • May 2015 (9)
  • April 2015 (4)
  • November 2014 (7)
  • October 2014 (19)
  • September 2014 (3)
  • July 2014 (2)
  • July 2013 (1)
  • December 2012 (1)
  • October 2012 (1)
  • December 2011 (6)
  • October 2011 (6)
  • September 2011 (5)
  • July 2011 (1)
  • June 2011 (1)
  • May 2011 (2)
  • April 2011 (1)
  • February 2011 (15)
  • January 2011 (19)
  • December 2010 (14)
  • November 2010 (16)
  • October 2010 (3)

RSS SQL Kitty RSS

  • New Job -> Week 3 -> Creating Alerts
  • New Job -> Week 2 -> Creating a Checklist
  • New Job -> Week 1 -> What Tools Do You Need?
  • Creativity in Technology
  • Documentation vs Automation
© Copyright 2023 – sqlkitty
Chip Life Theme by TutorialChip ⋅ Powered by WordPress