Automating T-SQL Code Analysis
With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and...
2017-12-11 (first published: 2017-11-28)
2,251 reads
Blog Posts
Database Fundamentals #15: Modifying Data With T-SQL
The preferred method for modifying your data within a database is T-SQL. While the last Fundamentals post showed how to...
2017-12-11 (first published: 2017-11-27)
1,796 reads
Microsoft to Decommission Connect on 12/31/2017
Microsoft will be decommissioning the Connect platform on 12/31/2017 due to privacy concerns and will be replacing it with a...
2017-12-11
443 reads
New Course: Implementing a Hybrid Cloud Solution in Azure
My latest Pluralsight course – SQL Server: Implementing a Hybrid Cloud Solution in Azure – is well over two hours and long and is based...
2017-12-11
593 reads
Performance Dashboard Reports in SQL Server
SQL Server Management Studio comes up with multiple standard reports that show basic performance information. These reports are available without...
2017-12-11
4,979 reads
Reset SA password on SQL Server on Linux
This article is about how to proceed when you forgot the password of your SQL Server “sa” account, Password was entered...
2017-12-11
40,090 reads
ARMED - Where is the source?
ARMED, where is the source?
For quite a few years I’ve been putting everything I wrote on github and made most of it open source with a permissive license like...
2017-12-09
4 reads
ARMED - Where is the source?
ARMED, where is the source?
For quite a few years I’ve been putting everything I wrote on github and made most...
2017-12-09
303 reads
ARMED - Where is the source?
ARMED, where is the source?
For quite a few years I’ve been putting everything I wrote on github and made most...
2017-12-09
12 reads
ARMED - Where is the source?
ARMED, where is the source?
For quite a few years I’ve been putting everything I wrote on github and made most...
2017-12-09
41 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