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 | 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 Ginger Daniel | Helpful Scripts , Intermediate , SQL Administration , SQL Server
-by Ginger Keys It is not uncommon for database files to grow to the point you need more disk space. But what if it’s not possible or not in the budget to add more space? There are several creative options you have to move or shrink files, or delete unneeded items from the disk. One […]
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 | 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 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 reading