A Glimpse of the Future
I’m not sure what happened here. I walked up to my desktop, wiggled the mouse, and nothing happened. In the...
2010-05-04
535 reads
Blog Posts
CLR Stability
Recently I was at a UK user group meeting and Simon Sabin of SQL Skills presented a short “SQL Nugget”...
2010-05-04
646 reads
How Can I Tell if SQL Agent is Running via SQL?
Introduction
Today’s post is a continuation in my on-going effort to document all of the scripts I use to manage my...
2010-05-04
413 reads
May Question: What is your favorite DBA joke?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-05-04
823 reads
Nominations for the 2010 Exceptional DBA Award are Now Open
SQLServerCentral.com, along with Red Gate Software, are glad to announce that nominations for the 2010 Exceptional DBA Awards are now...
2010-05-04
1,553 reads
PASS Update #31 (Election Prep)
Sometime soon we’ll start the process of the 2010 PASS election, with three seats on the Board of Directors being...
2010-05-04
402 reads
Spring 2010 Hardware Recommendations
Since I am very interested in various PC-based hardware, and I make an effort to stay current on new developments,...
2010-05-04
859 reads
SQL Server Replication - Replication Agents
My first post in my replication series gave a brief overview of replication, before I dive into setting up and...
2010-05-04
7,277 reads
Don’t Forget to Register for the Free 24 Hours of PASS
The free 24 Hours of PASS event will held May 19 & 20, and includes 24 different one hour presentations on...
2010-05-03
412 reads
Follow Up: LinkedIn Poll
A couple weeks ago I wrote about testing the LinkedIn polling capability, putting up this poll:
The response rate wasn’t great,...
2010-05-03
320 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