The Value of Shortcuts
Decades ago when I was working as a retail clerk, I had a boss named Billy. Billy was a pragmatic...
2017-12-16
414 reads
Blog Posts
New version of sp_WhoIsActive (v11.20) is available – Deployed on 123 instances in less than 1 minute
Last night, I received Adam Machanic's (b | t) newsletter "Announcing sp_whoisactive v11.20: Live Query Plans". For those who don't know...
2017-12-15 (first published: 2017-12-05)
2,492 reads
Testing a Birthday Month Query
I ran across a post from a tester, wondering how to write a query for birthday months. This makes sense,...
2017-12-15 (first published: 2017-12-04)
1,926 reads
To Learn, Teach
Back before I started doing technical presentations or writing blog posts, I frequently found myself in awe at those who...
2017-12-15
603 reads
xSQLServer is dead long live SqlServerDsc
I have had a problem with DSC in Azure Automation for a few months now, there was a change made to the xSqlServer DSC resource which meant that the...
2017-12-15
11 reads
xSQLServer is dead long live SqlServerDsc
I have had a problem with DSC in Azure Automation for a few months now, there was a change made...
2017-12-15
346 reads
xSQLServer is dead long live SqlServerDsc
I have had a problem with DSC in Azure Automation for a few months now, there was a change made...
2017-12-15
58 reads
xSQLServer is dead long live SqlServerDsc
I have had a problem with DSC in Azure Automation for a few months now, there was a change made...
2017-12-15
95 reads
AutoMap in SQL Compare
SQL Compare is a core product from Redgate and I’ve got a series on some of the interesting things I’ve...
2017-12-14
1,238 reads
Azure SQL Database – Using sp_BlitzIndex
I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...
2017-12-14 (first published: 2017-12-05)
1,699 reads
Blogs
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...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
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