By Lori Brown | Intermediate , SQL Administration , SQL Server , Trace Flags
— by Lori Brown @SQLSupahStah Once again, I find things about SQL Server that I had no idea were even available when I actually have time to do some in-depth reading and research. Most of the time, my regular duties keep me so busy that I don’t have time to play with new SQL functionality […]
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 Ginger Daniel | Intermediate , Perfmon , Performance Tuning , SQL Server , SQLRX
–by Ginger Keys Have you ever watched performance metrics in Performance Monitor (Perfmon) and wondered which SQL Server activities were causing those spikes? SQLRx offers a Microsoft Partner-of-the-Year award-winning service that will correlate all performance metrics on your server with very little overhead, and will pinpoint with precision, right down to a line of code […]
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 Ginger Daniel | Intermediate , Miscellaneous , SQL Administration , SQL Server
— by Ginger Keys Recently a client of mine moved their production SQL Server Cluster to a new physical environment. When the time came to ‘go-live’ with the new environment, the client wanted the new SQL cluster name and IP address (SQLCLUSTERTEMP) to be renamed to the original, legacy name and IP address (SQLCLUSTER). […]
Continue readingBy Ginger Daniel | Intermediate , SQL Administration , SQL Development , SQL Server
–by Ginger Keys Dynamic Data Masking is a SQL Server 2016 feature that can be deployed as part of your overall security strategy. Data masking is not intended as a primary security solution, but provides a way to obfuscate or hide characters in data such as social security numbers, credit card numbers, email addresses, and […]
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 SQLRx Admin | Intermediate , Performance Tuning , SQL Server , Tip of the Month
SQL Server Performance Tuning: New function in SQL 2016: sys.dm_exec_function_stats Returns performance statistics for cached functions. Returns information about scalar functions, including in-memory functions and CLR scalar functions but not about table valued functions. The view returns one row for each cached function plan, and the lifetime of the row is as long as the […]
Continue readingBy SQLRx Admin | Intermediate , SQL Server , Tip of the Month
January 2016 Tip of the Month: Using sys.dm_server_memory_dumps to find SQL memory dumps. When SQL experiences a serious issue it will often dump the contents of its memory to disk. This is known as a memory dump and it does generate files that are usually located in the Logs folder. I often find that many […]
Continue reading