By Lori Brown | Expert , SQL 2016 , SQL Administration , SQL Server , Trace Flags
I came across something today that I did not know existed in AG’s, Automatic Seeding. This allows SQL to automatically create the secondary replicas for all databases in an AG. Pretty cool!! So if you set things up correctly when you set up your AG’s, you don’t have to worry about backing up databases and […]
Continue readingBy 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 Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server
— By Ginger Keys During the migration of a client’s SQL environment to a new hosting provider it was questioned whether all of the databases needed to be migrated. Nobody seemed to know whether several of the databases were used or what they were for. One person suggested we just not move them, and see […]
Continue readingBy Ginger Daniel | Beginner , Miscellaneous , Security , SQL Administration , SQL Server
–By Ginger Keys After migrating a client’s SQL instances to VMs from physical servers, I noticed the following week that the SQL Server Log files had tons of failed login attempts from what looked like an application. These attempts were happening several times per second, and had totally bloated the SQL Server logs. This is […]
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 | 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 | 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 | Intermediate , Security , SQL Administration , SQL Server , Upgrade
–By Lori Brown @SQLSupahStah I am working with a client who is migrating from SQL 2012 to SQL 2016. It just so happens that while they have just a few databases to move, they also have a ton of SQL logins that needed to be migrated. This is not an issue since I know to […]
Continue reading