Wanted to share this from Straight Path Solutions. Good dive into standing up a new SQL Server instance using DBA Tools from start to finish,…

Sometimes you need to extract a large number of tables into some other format. I’ve written about BCP earlier as a quick option to move…

Brent Ozar is hosting today’s #TSQL2sday about the most recent issue you closed. Working with a consulting firm for a variety of clients, I tend…

This is a bit outside of the SQL Server realm, but might be of interest to some. I was asked to read 100 words recently,…

For those of us who’ve worked with SQL Server for some time, we’ve regularly used SQL Server Management Studio (SSMS). In recent years, we’ve seen…

I ran into a concern to quickly audit all current users and role members for a set of Azure SQL databases, spread across multiple resource…

I’ve worked with SSIS for some time now, but a recent question and post pointed out an expression I’d never used before. We often have a need to split strings and pick out some portion of that string. Sometimes we have a need to pull in everything in the “nth” occurrence of a string. The TOKEN expression can be used to get that particular value.

What is a Calendar or Date table? Maybe you’ve worked with data warehouses before, in which case the concept of a “Date Dimension” is going…

I recently had a need to add certificates to SQL Servers throughout an organization. There were quite a few servers to update and the certificates…

This seems oddly specific, but someone or something had cleared out many files from the Windows\Installer folder, probably to save space. (Sidenote, you can actually…