Replay your workload through the Query Store Replay script!
One of the great features of the Query Store is that it stores query execution plans and runtime performance on-disk...
2016-12-19
1,305 reads
Blog Posts
Speaking at SQLSaturday Nashville!
Speaking at SQLSaturday Nashville!
I’m proud to announce that I will be speaking at SQL Saturday Nashville on January 14th 2017! This...
2016-12-19
330 reads
Speaking at SQLSaturday Nashville!
Speaking at SQLSaturday Nashville!
I’m proud to announce that I will be speaking at SQL Saturday Nashville on January 14th 2017! This will be my first speaking event this year...
2016-12-19
6 reads
The Trails We Leave
Over the weekend I got an email from have i been pwned, a website that tracks data breaches and notifies...
2016-12-19
349 reads
What is – DML, DDL, DCL and TCL in TSQL?
In transact SQL , different type of activity performed ,like we can create database , manipulate date , update, delete even control access...
2016-12-19
4,441 reads
What is “SET STATISTICS TIME”?
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
403 reads
What is “SET STATISTICS TIME”?
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
375 reads
What is “SET STATISTICS TIME”?
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
452 reads
Deploying a Windows Data Science Virtual Machine to Azure with PowerShell easily
This weekend (10 December 2016), I went to Slovenia for a SQL Saturday. As always, it was an amazing event...
2016-12-18
817 reads
SSRS 2016: Great and Getting Better
Although I’ve been a regular user of SQL Server Reporting Services since it was released in the mid-2000s, I’ve done...
2016-12-18
414 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers