The topic for this month’s T-SQL Tuesday #167 hosted by Matthew McGiffen (Blog / Twitter) is about encryption and data protection in SQL Server.
Read More »
The topic for this month’s T-SQL Tuesday #167 hosted by Matthew McGiffen (Blog / Twitter) is about encryption and data protection in SQL Server.
Read More »Often when generating dynamic sql we must add some separator values in the string(s) we build. A function delivered way back in 2017 called STRING_AGG is a simple way to do this. Let’s look at some examples.
Read More »When was my server last rebooted? Who shutdown my machine? Read on to see how easy it is to find out using the Windows Server Event Logs.
Read More »A while ago I wrote a post about the SQL Server error log. Today I will show how to load the SQL error log into a table for analysis via T-SQL.
Read on to see a couple of ways to traverse all the error logs and load into a table for analysis.
Read More »I just uploaded some sample presentations I did. You can find them on the Resources page. Both talks were given at SQL Saturday Sacramento.
Read More »This July marked the end of life for Microsoft SQL Server 2008 and 2008R2. Let’s raise a glass to toast / pour some liquor out / reminisce about the past…
Read More »Read on about my presentations…
There are multiple methods for exporting data from SQL Server. We will explore a few and focus on the “Generate Scripts” feature in SSMS.
Read More »There are times when you may find yourself needing to drop many tables in your database but not all. Some criteria defines what must go. It could be archived tables, tables before or after a certain date time stamp, dummy data tables, etc.
Let’s look at 2 simple methods for dropping lots of tables in your database.
Read More »