The Daily Dose

The Prescription for SQL Server

Oct 24

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 1

By Ginger Daniel | Azure , Cloud , SQL Administration , SQL Development , SQL Server

One of many options for Reporting and Power BI is to use Azure Blob Storage to access source data.  Most of the documentation available online demonstrates moving data from SQL Server to an Azure Database, however my client needed data to land in Azure Blob Storage as a csv file, and needed incremental changes to […]

Continue reading
Aug 29

Backup and Restore Databases with CHECKSUM and VERIFYONLY

By Lori Brown | Backup and Restore , SQL Administration , SQL Maintenance , SQL Server

I found out that I have been missing something from our regular database backups that I had no idea that I should have been using all along.  I know about verifying your backup file and have incorporated into our standard maintenance routines one that will periodically test backups by restoring using VERIFYONLY.  However, I totally […]

Continue reading
Mar 07

Should I Replace My FOR XML PATH String Merges with String_agg?

By Jeffry Schwartz | Function , Performance Tuning , Query Tuning , SQL Development , SQL Server

If you are looking for major performance gains, the answer is no.  However, if you are using SQL Server 2017 and developing new code, you should consider using the new String_agg function that is available on SQL Server 2017 because code that uses this function is so much more readable and easier to write and […]

Continue reading
Mar 07

Should I Replace My FOR XML PATH String Merges with String_agg?

By Jeffry Schwartz | Function , Performance Tuning , Query Tuning , SQL Development , SQL Server

Overview If you are looking for major performance gains, the answer is no.  However, if you are using SQL Server 2017 and developing new code, you should consider using the new String_agg function that is available on SQL Server 2017 because code that uses this function is so much more readable and easier to write […]

Continue reading
1 2 3 41
>