By Lori Brown | Backup and Restore , Helpful Scripts , SQL Administration , SQL Server
Recently I had a client who contacted me because all of the sudden the backup for a couple of databases started to fail. While those backups had been running successfully in the past they suddenly started failing with this message: With a little more digging he found more info. Here is more verbiage from the […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Server , SQL Toolkit
We recently were troubleshooting an issue where one client reported that the SQL instance was suddenly very slow. One of the things we do is check to see what queries are currently running in SQL by using the following query: — Finds info on queries that are running NOW SELECT GETDATE() AS CurrentTime, SUBSTRING(text, CASE […]
Continue readingBy Lori Brown | Advice , Beginner , SQL Administration , SQL Maintenance , SQL Server
I am recycling this blog post from 2015….”Why?”, you might ask…..Well, I am still running into instances with this exact issue. Soooo, here we go….again. Enjoy. I recently received a panicked call from a client who had a SQL instance go down because the server’s C drive was full. As the guy looked he found […]
Continue readingBy Lori Brown | ColumnStore , Miscellaneous , SQL Administration , SQL Server
I was recently looking at a way to easily identify if any objects in a database were In-Memory. Since many times I am tasked with taking on systems that I have never seen before, I have learned that it is important to have ways of checking to see if some of the more specialized features […]
Continue readingBy Lori Brown | Helpful Scripts , Missing Indexes , Performance Tuning , Query Tuning , SQL Administration , SQL Development , SQL Server
I was recently working with one of my clients on some low hanging fruit type of query tuning. We had checked the cache for plans with missing index warnings in them and were trying to see if we could tweak and existing index or add a new index to speed things up. If you ever […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Maintenance , SQL Server
I ran into a situation where we were working on a migration and had been directed to put all databases into FULL recovery model in anticipation of using log shipping to push databases to the new server. Once we are ready to go live on the new server the plan was to ship the last […]
Continue readingBy Lori Brown | Backup and Restore , Beginner , Helpful Scripts , SQL Administration , SQL Server
We recently started using a third party software to do our in-house SQL backups so that the backup files are stored in a redundant and safe place. To confirm that the software was indeed compressing backups as it stated it would, we wanted to see what each backup size actually was in SQL so that […]
Continue readingBy Lori Brown | Installation , SQL 2017 , SQL Administration , SQL Server
SQL Server 2017 is available as a CTP for testing (https://www.microsoft.com/en-us/sql-server/sql-server-2017) and is able to be installed on a system running Linux. Because I have done all of my professional work on Windows systems, the leap to a Linux system was a bit of a stretch. I learned that while Linux is the OS kernel, […]
Continue readingBy Lori Brown | CTP , SQL 2017 , SQL Server
–By Lori Brown @SQLSupahStah SQL Server 2017 is rolling our way like a big ole train. And, with the new features that are going to be available there may be quite a few shops that want to jump onboard. As of this writing SQL Server 2017 CTP 2.1 is available for download and testing. (https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2017-ctp/ […]
Continue reading