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, ...

CREATE TABLE InvoiceHeader ( InvoiceId INT IDENTITY PRIMARY KEY, InvoiceNumber VARCHAR(50) NOT NULL, CustomerCode VARCHAR(50), InvoiceDate DATE, TotalAmount DECIMAL(12,2), LastUpdatedAt DATETIME2 ...

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 ...

After a brief gap since releasing SQL Server Public Preview 6, and having survived through the February 2019 Snowcalypse in Seattle, I’m happy to share that everyone in the SQL Tools team has made it ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...