Getting Things Done With SSMS
As a SQL Server pro, I spend most of my productive time in the SQL Server Management Studio (SSMS). I...
2018-04-04 (first published: 2018-03-27)
2,959 reads
Blog Posts
I Am Speaking At Music City Tech
I am excited to announce that I have been selected to speak at Music City Tech held at Vanderbilt University...
2018-04-04
277 reads
Power BI Monthly Digest – April 2018
Welcome to a new series that Manuel Quintana [Blog | Twitter] and I are starting where we will cover some of...
2018-04-04
437 reads
Speaking at SQLSaturday #710 in Edmonton on May 5th, 2018
I will be presenting twice at SQLSaturday #710 in Edmonton, on 5 May 2018. You can join me for two...
2018-04-04
282 reads
SSMS’s Dark Theme
There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the...
2018-04-04
469 reads
Toolbox - Do You Have Current Backups?
On our managed servers we run a job each day to check that either a FULL or DIFF has run...
2018-04-04
679 reads
Why didnt my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with Octopus to deploy doesn't have any debugging information enabled...
2018-04-04
14 reads
Why didnt my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with...
2018-04-04
135 reads
Why didnt my Azure ARM deploy work?
I have been using Octopus to deploy ARM templates for a while now and the default task that comes with...
2018-04-04
124 reads
Azure SQL Database – Failed to Delete Database Nightmare
After demo building and testing features out within Azure SQL Database I like to delete the databases to save costs....
2018-04-03
372 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