T-SQL Enhancement: EXECUTE WITH RESULT SETS
All developers know, that it is very important to encapsulate code in classes and methods to be able to reuse...
2011-07-05
798 reads
Blog Posts
2011 SQL Server MVP Award
Thanks Microsoft for awarding me the MVP for SQL Server for the third year in a row. It’s a great...
2011-07-04
600 reads
How to re-create database quickly
I was running some database unit tests and needed to drop completely everyhing in my database. There are really many...
2011-07-04
678 reads
Listing Stored Procedures From Every Database
Recently I answered a question on AskSSC that I thought I would create a quick blog about. Someone had asked...
2011-07-04
735 reads
Select from a table with no rows returned.
G’day,
I recently ran into a nice feature that I had never encountered before.
Sometimes, when developing or administrating an unfamiliar table...
2011-07-04
5,001 reads
Wild West Day
One of the things I’m missing today is Wild West Day at Red Gate. It’s not just because I don’t...
2011-07-04
1,596 reads
Creating Icons Files
While working on a PowerPack for PowerGUI I needed to create a bunch of icon files from bitmaps files so...
2011-07-03
676 reads
Non-Convergence of Replicated Data
Brad McGehee over at SQL Aloha posted his July Question: What Do You Think are the Most Common DBA Pain...
2011-07-02
865 reads
Bloopers
An early peak at the bloopers going out on Monday. Feel free to enjoy today. I’ve included the editorial and...
2011-07-01
1,366 reads
Book Review: Hour of the Horde
Hour of the Horde by Gordon R. Dickson ($1-5 @ Amazon) is an interesting story. The basic plot is that one...
2011-07-01
425 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers