By Lori Brown | Beginner , Miscellaneous , SQL Administration , SQL Development , SQL Server
— By Lori Brown @SQLSupahStah I was looking for a way to get info on the columns in indexes so that I could use the data to help enhance my index defrag routine. I found that my defrag logic did not figure out if an index has included columns that are LOBs and was failing […]
Continue readingBy Lori Brown | Intermediate , SQL Administration , SQL Development , SQL Server
— By Lori Brown @SQLSupahStah A temporal table is a table that holds old versions of rows from a base table. In other words it is a history table. By having temporal tables SQL Server can automatically manage moving old row versions to the temporal table every time a row in the base table is […]
Continue readingBy Lori Brown | Beginner , Performance Tuning , SQL Administration , SQL Development , SQL Server
–By Lori Brown @SQLSupahStah SQL Server 2016 has introduced a couple of new functions that can be very useful and save storage space to boot. COMPRESS and DECOMPRESS offers the benefit of compressing column data thereby saving storage space. COMPRESS uses the GZIP compression algorithm and actually compresses data before it is stored in a […]
Continue readingBy Lori Brown | Helpful Scripts , Intermediate , Miscellaneous , SQL Administration , SQL Server , Windows
–By Lori Brown @SQLSupahStah Part of being a proactive DBA is to get information on what is going on at the server level as well as at the SQL level. We know that the Windows Event logs are around but I find that not many DBA’s check them regularly. You can make this easier by […]
Continue readingBy Lori Brown | Beginner , SQL Administration , SQL Server
Lots of people are using the SSIS catalog database, SSISDB, for SSIS packages. Actually, using the SSIS catalog is best practice but there are still some shops that use File System Packages. These shops should really consider migrating to the SSIS catalog. Some benefits are: Versioning: Version history is kept allowing developers to see list […]
Continue readingBy Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah While trying to add a database to an existing AlwaysOn Availability Group (AG), I was having difficulty making a connection from the primary replica to the secondary replica. The availability group was functioning but as I tried to add a database to it, my connection to the secondary replica was […]
Continue readingBy Lori Brown | Intermediate , Miscellaneous , SQL Development , SQL Server
— By Lori Brown @SQLSupahStah While Try-Catch has been around since SQL 2005, you would be surprised at how infrequently applications and SQL programmers use this to handle errors. Since I also write my own maintenance and monitoring code and jobs that has to be deployed to my clients, I started making an effort to […]
Continue readingBy Lori Brown | Expert , Performance Tuning , SQL Administration , SQL Server
Sometimes it is good to have some queries in your toolkit that give you information on how things are running that includes the actual execution plan. While looking at Glenn Berry’s diagnostic query scripts (http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-september-2015/), which are very good btw, I found queries that will list stored procedure statistics but none had the execution plan […]
Continue readingBy Lori Brown | Beginner , SQL Administration , SQL Server
— By Lori Brown @SQLSupahStah Any login that is a member of the sysadmin role can reset the SA password. But, what if you have a hostile takeover by an application or for some strange reason don’t have any other logins as members of the sysadmin role? Don’t laugh! I have actually run into both […]
Continue reading