Think Using .. In Code Is A Time Saver? Think Again!
Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out...
2016-09-23
492 reads
WaterOx SQL
Organizing a SQL Saturday – Part 3 – The Venue
You’ve got your team; now you need to find a somewhere to host your event. If you are lucky, you...
2016-09-22
413 reads
sp_WOxCompliant Update
I just released an update to the sp_WOxCompliant script to fix a couple of issues. You can download it here! What...
2016-09-22
483 reads
Organizing a SQL Saturday – Part 2 – The Team
A lot of these types of events are pulled together by the local user group. If there is none, it...
2016-08-31
730 reads
Organizing a SQL Saturday – Part 1 – Why Do It?
To kick off this series, I thought it would be worthwhile to discuss why it is I step up to...
2016-08-26
439 reads
T-SQL Tuesday #080 – The Gift of the Basics
This month’s T-SQL Tuesday (#080) is being hosted by Chris Yates (B|T) (Happy B-day Chris!). He decided that this month’s...
2016-07-12
526 reads
Hearing Responsibility
A while ago I was watching Shark Tank on TV and at one point Robert Herjavich (T|B) made the great...
2016-06-29
694 reads
PASS Summit 2016 – My Session Evaluations
No Sessions For You! The announcements of the speakers and sessions selected for the PASS Summit 2016 were recently announced,...
2016-06-24
422 reads
A New Look & A New Direction
You have brains in your head. You have feet in your shoes. You can steer yourself in any direction you...
2016-04-28
803 reads
Quick PS script to get SQL Server Configuration Aliases - Syndication – WaterOx Consulting
Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or...
2016-03-09
798 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