The free SQL to Excel Export tool

Earlier this month I released a new, free tool to export SQL Server query data to Excel files without needing Excel....

Sizing your Azure SQL Database

Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your...

Women in Tech Talk Tech

March is Women’s History Month, to celebrate the PASS Women in Technology Virtual Group (@PASS_WIT) held a webcast featuring prominent...

SheLeadsTech Community

ISACA, which is primarily an Audit and Compliance professional organization, has recently started an initiative with the following purpose:
ISACA’s SheLeadsTech...

Mixed feelings over the new truncation error

As of SQL 2019 CTP2.0 or SQL 2017 CU12 Microsoft has given us a long-awaited addition to the truncation error....

The Curiously Large CASE Statement

A powerful little expression in SQL Server is the CASE statement. The CASE statement has the ability to "transform" data per business rules to help better understand the data...

The Curiously Large CASE Statement

 
A powerful little expression in SQL Server is the CASE statement. The CASE statement has the ability to “transform” data...

Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.

Problem: SQL server database refresh / restore...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.

Problem: SQL server database refresh / restore...

[[ This is a content summary only. Visit my website for full links, other content,...

Writing a presentation 4: Practice and improvement

My presentation so far is really rough. I need to improve a lot before SQL Saturday Chicago! For now, the...