Skip to content
sqlkitty

sqlkitty

sql for everyone

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

Using Docker on Windows with Persistent SQL Server Settings and Databases

  • Posted onMay 15, 2023May 15, 2023
  • containerization

This is an easy way to retain the data and settings you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases after creating your Docker container. I found that you can mount the volumes that SQL Server…

Continue Reading

Automating Database Maintenance on Azure SQL

  • Posted onMay 8, 2023May 8, 2023
  • Azure

Database maintenance is crucial for the health and performance of any database system, including those in Azure. Without regular maintenance, databases can become slow, unstable, and prone to crashes and other errors. Maintenance tasks such as index optimization and statistics updates ensure query processing happens…

Continue Reading

Data Platform WIT and DEI Mental Health and Wellness Day: Managing Chronic Pain

  • Posted onMay 5, 2023May 10, 2023
  • zen

Thank you to Data Platform WIT and DEI for hosting Mental Health and Wellness Day! I was honored to be included. To see the full lineup, please visit https://www.meetup.com/data-platform-dei/events/293091941/ DISCLAIMER: THIS WEBSITE DOES NOT PROVIDE MEDICAL ADVICEThe information, including but not limited to, text, graphics,…

Continue Reading

New Job -> Week 7 and Beyond

  • Posted onMay 1, 2023May 1, 2023
  • dba

This is part of a series of new job blog posts. You can find them all here. As a DBA, the first six weeks on the job can be challenging and exciting. During this period, you are expected to learn about the company’s processes. You…

Continue Reading

New Job -> Week 6 -> Ozar sp_BlitzIndex

  • Posted onApril 24, 2023April 24, 2023
  • dba

This is part of a series of new job blog posts. You can find them all here. Week 6 goal: Analyze all Azure SQL Database indexes. Last week, I started pushing out the sp_Blitz scripts that work on Azure. In the world of SQL Server…

Continue Reading

New Job -> Week 5 -> Create Index Maintenance Scripts

  • Posted onApril 17, 2023April 18, 2023
  • dba

This is part of a series of new job blog posts. You can find them all here. Week 5 goal: set up Ola index maintenance for all Azure SQL Databases. This week is about learning Flyway. I’m using Flyway because my company requires this for…

Continue Reading

New Job -> Week 4 -> Set Up Auditing

  • Posted onApril 6, 2023April 6, 2023
  • dba

This is part of a series of new job blog posts. You can find them all here. The main goal for week 4: set up auditing for all Azure SQL Databases. This week is again about learning more Terraform. I’m using Terraform because my company…

Continue Reading

New Job -> Week 3 -> Creating Alerts

  • Posted onMarch 30, 2023April 6, 2023
  • dba

This is part of a series of new job blog posts. You can find them all here. UPDATED: I needed to change out resources that will be deprecated, such as azurerm_mssql_database, azurerm_mssql_firewall_rule, and azurerm_mssql_server. Code snippets in this post and GitHub are updated accordingly. The…

Continue Reading

New Job -> Week 2 -> Creating a Checklist

  • Posted onMarch 24, 2023March 24, 2023
  • dba

This is part of a series of new job blog posts. You can find them all here. Last week was the first week of the rest of my life. But really it was the first week of my new job and I installed a lot…

Continue Reading

New Job -> Week 1 -> What Tools Do You Need?

  • Posted onMarch 17, 2023May 16, 2023
  • dba

This is part of a series of new job blog posts. You can find them all here. I changed to a new job and started it this week. Before I started, I thought of all the things I thought I would want to do when…

Continue Reading

Posts navigation

Page 1 Page 2 … Page 20 Next Page

My Events

< May 2023 >
Mon Tue Wed Thu Fri Sat Sun
1 2 3 4 5 6WIT Wellness Day all day
7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24EightKB all day
25 26 27 28
29 30 31        

Subscribe to SQL Kitty

loader

Email Address*

Name

Recent posts

  • Using Docker on Windows with Persistent SQL Server Settings and Databases
  • Automating Database Maintenance on Azure SQL
  • Data Platform WIT and DEI Mental Health and Wellness Day: Managing Chronic Pain
  • New Job -> Week 7 and Beyond
  • New Job -> Week 6 -> Ozar sp_BlitzIndex

Categories

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

Archives

  • May 2023 (4)
  • April 2023 (3)
  • 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 (4)
  • 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

  • Using Docker on Windows with Persistent SQL Server Settings and Databases
  • Automating Database Maintenance on Azure SQL
  • Data Platform WIT and DEI Mental Health and Wellness Day: Managing Chronic Pain
  • New Job -> Week 7 and Beyond
  • New Job -> Week 6 -> Ozar sp_BlitzIndex
© Copyright 2023 – sqlkitty
Chip Life Theme by TutorialChip ⋅ Powered by WordPress