By 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 readingBy Lori Brown | SQL Administration , SQL Server
— By Lori Brown @SQLSupahStah SQL 2016 SP1 has been released. I might be a little late to this announcement but thought I would at least give the download link and some highlights on things that are fixed in it. Download it from here: https://www.microsoft.com/en-us/download/details.aspx?id=54276 Some of the highlights are: New CREATE OR ALTER that […]
Continue readingBy Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah One of my clients has a rather large database with multiple filegroups and multiple database files in them. I happened to notice that a specific drive that is occupied by 2 specific files that are supposed to hold indexes is getting utilized at a much higher rate than any of […]
Continue readingBy Lori Brown | Lunch And Learn , SQL Server
Please join SQLRX’s Lori Brown and the SQLRX team at the Microsoft Campus in Irving, Texas this coming Wednesday November 16, 2016 for an informative take on reasons to upgrade to SQL Server 2016. Register Now! There are a lot of really good reasons to upgrade to SQL 2016. Even if you’re still on SQL 2008 […]
Continue reading