DBA Dreams
Louis Davidson on the small dreams that DBAs can nurture, each day, to elevate the drudgery of a seemingly banal task into a celebration of purpose.
Downtime
Most of us are working to prevent downtime in our systems. However Netflix thinks a little forced downtime is good for the software developers and infrastructure people.
The SQL TABLE Type: Beyond Table-Valued Parameters
Follow along as this starter article on the SQL TABLE Type walks you through the various ways it can be used in T-SQL.
Avoid using NOLOCK on SQL Server UPDATE and DELETE statements
Occasionally I come across UPDATE and DELETE statements where the target SQL Server table is referenced with the NOLOCK hint. Does this hint help or hurt performance in this case?
SQL Saturday #269 - Exeter, UK
SQL Saturday is coming to Exeter on March 22, 2014. Join Red Gate's David Atkinson and the rest of the speakers at this free day of SQL Server training and networking, organized by SQL South West.
Geeky Entertainment
As a break from work, this week Steve Jones wants to know what you wish for. Are there comic book, science fiction, or technological thrillers you'd like to see made into movies?
See Grant Fritchey and Steve Jones at SQL Intersection
Come see Grant Fritchey and Steve Jones (from Red Gate Software) and many more SQL Server experts while you enjoy spring in Orlando, FL at SQL Intersection.
Calculating Gaps Between Overlapping Time Intervals in SQL
There are a number of real-life reporting tasks in SQL that require a 'gaps and islands' analysis. There are a number of techniques around that work, but finding ones that scale well makes for a tougher, but interesting, challenge.
Fixing CREATE TABLE
Steve Jones has a problem with the inconsistency of the CREATE TABLE statement in SQL Server and has an idea on what to do.
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