By Lori Brown | Helpful Scripts , SQL Administration , SQL Server , SQL Toolkit
–By Lori Brown I am going to start up a thread with some queries that I consider to be important to DBA’s. As a consultant, many times we have to start managing SQL instances without any knowledge of why it has been configured in various ways. We usually try to work with our clients to […]
Continue readingBy Lori Brown | Intermediate , Performance Tuning , SQL Administration , SQL Development , SQL Server
— by Lori Brown @SQLSupahStah For the most part, I stick to my daily DBA duties of making sure that SQL Server maintenance is running and that the proverbial lights are on in all my SQL boxes. However, sometimes it is fun to do some tuning and it’s even better when you have a success. I […]
Continue readingBy Lori Brown | Beginner , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah Back it up!! …. BEEP! BEEP! BEEP! … Oh wait! Not that kind of backup… Since I spent a lot of time trying to creatively move a database from one server to another last night, I thought that a review of ways to backup and restore would be a […]
Continue readingBy Lori Brown | ColumnStore , Expert , Partitions , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah I recently ran across a data warehouse that did have the largest table partitioned. We were migrating up to SQL 2016 and we wanted to make sure that the partitions were still working and in place. Since I felt I needed to refresh my table partitioning skills, I decided to […]
Continue readingBy Lori Brown | Advice , Beginner , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah I recently ran into someone who swears that shrinking database files on a production server is a good thing and proudly said they did it on all systems they work on. OMG!! Let me post a quote directly from MSDN regarding weather or not shrinking database files causes fragmentation (https://msdn.microsoft.com/en-us/library/ms189493.aspx) […]
Continue readingBy Lori Brown | Expert , SQL 2016 , SQL Development , SQL Server , SSIS Catalog
–By Lori Brown @SQLSupahStah I have a client who has a lot of SSIS packages in the SSIS catalog that we are migrating to a new server. Of course there is lots of testing going on. So the question came up about how to more easily see package runtimes and comparing to the overall average […]
Continue readingBy Lori Brown | Helpful Scripts , Intermediate , SQL Administration , SQL Server
–By Lori Brown @SQLSupahStah I needed to update some of our long running job monitoring code to improve it from the version that we have right now. I like this version because it uses msdb.dbo.syssessions (https://msdn.microsoft.com/en-us/library/ms175016.aspx) to validate that a job is actually running. I also wanted to know the percent difference between the current […]
Continue readingBy Lori Brown | Intermediate , Performance Tuning , SQL Development , SQL Server , Trace Flags
–By Lori Brown @SQLSupahStah After installing Service Pack 1 for SQL 2016, I ran across USE HINT and thought I would put out what I could find to document it. Here’s where you find info from Microsoft: https://msdn.microsoft.com/en-us/library/ms181714.aspx and here is a link for all of the bugs that are fixed in SP1: https://support.microsoft.com/en-us/kb/3182545 USE […]
Continue readingBy Lori Brown | Helpful Scripts , Intermediate , Security , SQL Administration , SQL Server
–By Lori Brown @SQLSupahStah At one of my clients who has an AlwaysOn failover cluster, I noticed as I was checking up on things on the secondary replica that there were several fewer Windows and SQL logins on the secondary than on the primary. I really did not want to tediously compare the logins on […]
Continue reading