Google Cloud Summit came to London last week, and we took the opportunity to sit down with database execs Sailesh ...

The “Conversion failed when converting date and/or time from character string” error in SQL Server appears when SQL Server cannot interpret a text value as a ...

Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...

Thank you for taking the time to explore data-related insights with me. I appreciate your engagement. If you find this information helpful, I invite you to follow me or connect with me on LinkedIn.

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not ...