Interviewed
I got sent an interview by Mohammad Darab, a fellow SQL Server professional in Northern Virginia. I thought the questions...
2017-12-08
1,271 reads
Blog Posts
Register for Red Gate’s SQL in the City
Aunt Kathi. Grant Fritchey. Steve Jones. They’re part of five hours of training on SQL Server performance and DevOps with...
2017-12-08
482 reads
SQL in the City 2017
Redgate is once again hosting a live, virtual event for SQL in the City. We’re going to give you a...
2017-12-08
317 reads
SSMS Updates in 17.4
SSMS 17.4 is out, and if you haven’t upgraded from SQL 204, 2012, 2008, etc., you should do so. You...
2017-12-08
1,158 reads
An Open Letter to the SQL Community: Regarding Speakers
(Part 1 of 2 -about and for Speakers.) The SQL Server community stands out as one of the most open, sharing, and giving technology communities. Around the world, there...
2017-12-07
10 reads
An Open Letter to the SQL Community: Regarding Speakers
(Part 1 of 2 -about and for Speakers.) The SQL Server community stands out as one of the most open,...
2017-12-07
464 reads
An Open Letter to the SQL Community: Regarding Speakers
(Part 1 of 2 -about and for Speakers.) The SQL Server community stands out as one of the most open, sharing, and giving technology communities. Around the world, there...
2017-12-07
15 reads
Closing all of the connections to a database
Doing a database restore may not be the most common task a database professional will ever do, but it’s a...
2017-12-07 (first published: 2017-11-27)
6,845 reads
Kalen Delaney’s Weekly Webinars
Anyone who has been working with SQL Server for any length of time should be aware of the name Kalen...
2017-12-07
349 reads
Watch Out for Automap in SQL Compare
I wrote a piece on SQL Compare and customizing the Automap feature. This was handy for me in a small...
2017-12-07 (first published: 2017-11-27)
1,236 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