How does Query Store capture cross database queries?
When I was writing my post Capture the most expensive queries across your SQL Server using Query Store a question crossed...
2017-11-16
644 reads
Blog Posts
Something Cool We Learned Today!
We have many customers, and we work on lots of projects. Each project is different in so many ways: the...
2017-11-16
424 reads
SQL Smackdown!!! Cursors VS Loops
Ladies and Gentlemen, welcome to the main event of the evening. The SQL Undercover Smackdown Heavy Weight Championship of the...
2017-11-16
2,508 reads
SSISDB for SQL Server Integration Services
Microsoft introduced some major changes in SQL Server Integration Services with SQL Server 2012.
Brand new “SSISDB” database launched as SSIS...
2017-11-16 (first published: 2017-11-06)
24,108 reads
Variables in Dynamic SQL
I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement....
2017-11-16
1,498 reads
Write Your first Pester Test Today
I was in Glasgow this Friday enjoying the fantastic hospitality of the Glasgow SQL User Group@SQLGlasgow and presenting sessions with Andre...
2017-11-16
451 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source control Are getting started on your path to the continuous delivery nirvana Have been...
2017-11-16
9 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source controlAre getting started on your path...
2017-11-16
358 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source control Are getting started on...
2017-11-16
40 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source control Are getting started on...
2017-11-16
38 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers