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 »
Category: SQL Server
Working with the SQL Server STRING_AGG Function
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 »
How to Monitor Windows Event Log for Reboots
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 »
How to Load SQL Server Error Log into Table for Analysis
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 »
SQL Server Presentations
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 »
SQL Server 2008 – Come Join Us
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 »
I’m Speaking – SQL Saturday Sacramento 2019!
On Saturday August 17th I will be speaking at SQL Saturday Sacramento presenting on 2 fun topics:
- Database Corruption! Preventing Disaster to your Database
- Environmental SQL Server Troubleshooting
Read on about my presentations…
How to Generate Scripts In SQL Server
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 »
SQL Server Drop Tables in Bulk – 2 Methods
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 »
I’m Speaking – SQL Saturday Phoenix 2019!
On Saturday May 4th I’ll be speaking at SQL Saturday Phoenix. I am excited to be presenting a lively and practical session about Environmental SQL Server Troubleshooting.