Trekking Through Formatting Forest on the #SQLPrompt Treasure Map
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-04-11
1,589 reads
Blog Posts
Understanding database recovery models in SQL Server
A recovery model is a database configuration option that determines the type of backup that one could perform and provides...
2018-04-11
774 reads
3 Essential Tools For The SQL Server Developer
This post is a response to this month's T-SQL Tuesday #101 prompt by Jens Vestergaard. T-SQL Tuesday is a way for SQL Server bloggers to share ideas about different...
2018-04-10
5 reads
3 Essential Tools For The SQL Server Developer
This post is a response to this month’s T-SQL Tuesday #101 prompt by Jens Vestergaard. T-SQL Tuesday is a way...
2018-04-10
426 reads
3 Essential Tools For The SQL Server Developer
This post is a response to this month's T-SQL Tuesday #101 prompt by Jens Vestergaard. T-SQL Tuesday is a way for SQL Server bloggers to share ideas about different...
2018-04-10
8 reads
Blog trasfering to new hosting server
Hi Friends,This blog is now transferring to different hosting server. So you may got some issue in accessing it. Sorry for the inconvenience caused
2018-04-10
11 reads
Blog trasfering to new hosting server
Hi Friends,
This blog is now transferring to different hosting server. So you may got some issue in accessing it. Sorry...
2018-04-10
270 reads
Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101
Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool....
2018-04-10
2,759 reads
How to change the TFS Agent _work folder
This blog post is about how to change the default work folder _work that TFS agents use when building a...
2018-04-10
596 reads
Power BI Custom Visuals Class (Module 97 – Enlighten Data Story)
In this module you will learn how to use the Enlighten Data Story. The Enlighten Data Story allows you to...
2018-04-10 (first published: 2018-04-03)
2,352 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