How to: Create an Azure VM with SQL Server using a default template
One of the really cool things about the cloud is how quickly you can spin up a new machine to...
2017-12-14
527 reads
Blog Posts
Picking The Right Team
Years ago, back before I became a consultant, a job search led me to an interview with a technical company....
2017-12-14
418 reads
The Mystery Of The Failing Azure Cmdlet
Hello!
I’ve been helping out a team with setting up a deployment pipeline that uses Azure Data lake Store, and so...
2017-12-14
412 reads
What The Tool? Multiple choice quiz to help you choose a tool for SQL Server
There are a few different choices for tools to use when it comes to SQL Server, while the “experienced” amongst us have used query analyzer, enterprise manager and probably...
2017-12-14
6 reads
What The Tool? Multiple choice quiz to help you choose a tool for SQL Server
There are a few different choices for tools to use when it comes to SQL Server, while the "experienced" amongst...
2017-12-14
345 reads
What The Tool? Multiple choice quiz to help you choose a tool for SQL Server
There are a few different choices for tools to use when it comes to SQL Server, while the “experienced” amongst...
2017-12-14
38 reads
What The Tool? Multiple choice quiz to help you choose a tool for SQL Server
There are a few different choices for tools to use when it comes to SQL Server, while the “experienced” amongst...
2017-12-14
40 reads
Checking SQL Configuration with Pester & Dbatools
I know, I know, there’s loads of different ways to test the configuration of SQL Server but I’ve started playing...
2017-12-13 (first published: 2017-11-29)
1,847 reads
Configure SQL Server 2017 on Linux with mssql-conf, the Linux way
The configuration of any system plays a vital role in its working efficiently. However, configuring a system needs not necessarily...
2017-12-13
787 reads
My Azure ARM template development workflow
Writing infrastructure as code is pretty nice and I enjoy the declarative approach of defining what you want and letting the tooling take care of the how. I guess...
2017-12-13
11 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