Skip to content
sqlkitty

sqlkitty

sql for everyone

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

Month: December 2015

sp_MSforeachtable and sp_MSforeachdb

  • Posted onDecember 29, 2015
  • sql server administration

two undocumented Stored Procedures that allow you to process through all tables in a database, or all databases in a SQL Server instance http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

Continue Reading

convert mirroring to ag

  • Posted onDecember 29, 2015
  • sql server administration

This would be run for each db in turn. 1. Pause log backup job 2. On primary – alter database [dbname] set partner off 3. On primary – ALTER AVAILABILITY GROUP [agname] ADD DATABASE [dbname] 4. On secondary – ALTER DATABASE [dbname] SET HADR AVAILABILITY…

Continue Reading

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