Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error that is vague, we sometimes find ourselves wanting to...
2017-11-17
34 reads
Blog Posts
Incorrect Syntax – What?
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error...
2017-11-17
333 reads
Learning to Give Presentations Well (Part 1)
I’ve given technical presentations for years. I’ve also taught in churches and youth groups years before that. For me, speaking...
2017-11-17 (first published: 2017-11-06)
1,517 reads
New Session: Data Types Do Matter
I started speaking on a semi-regular basis this year after many years of trepidation. You can read about my first...
2017-11-17
309 reads
One More Trip and Down for the Count
The last month has been a rough one for me, with lots of travel. I was on trips for 4...
2017-11-17
1,009 reads
SOS - Save Our Souls or SQL Operations Manager
On Wednesday Microsoft Announced the release in preview of SQL Operations Studio (SOS)... What is that I hear you cry!...
2017-11-17
628 reads
Training Day in London: Building Better SSIS Packages
I am delighted to announce that I’ll be delivering my full-day course, Building Better SSIS Packages, at the SQLBits conference...
2017-11-17
366 reads
A View On Views
In my experience, there are few database objects more poorly understood, misunderstood, misused, and outright abused, than the humble view....
2017-11-16 (first published: 2017-11-05)
1,990 reads
Azure SQL Database Alerting
It’s good to be proactive and one way is to setup alerts and it is no different when using Azure...
2017-11-16
510 reads
Can I pause or resume an index rebuild operation?
One of the cool new features in SQL Server 2017 (and currently also in public preview in Azure SQL Database)...
2017-11-16
1,000 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