SQL Server Browser Service
One of the most common questions I get from folks during out quickstart engagements is around a new service in...
2010-08-19
469 reads
Blog Posts
Stapler Method
This is long overdue and goes out to my buddies from the SSAS Class I taught late last year. Two...
2010-08-19
386 reads
Thoughts On The 2010 PASS BoD Elections Candidate List
Yesterday PASS published the list of candidates on the ballot for the 2010 Board of Directors election. Much to my...
2010-08-19
608 reads
Undocumented Stored Procedures
Just a quick list of undocumented SPs, many of which are deprecated.
Note, use caution using some of these ! But others...
2010-08-19
2,146 reads
Unique/Non-Unique Clustered Indexes
In the last blog post I have talked about unique/non-unique clustered indexes on a heap
table. A table without a clustered...
2010-08-19
8,197 reads
Upcoming SQL Lessons
Some great SQL Lunch sessions are coming up. Some from Pragmatic folks and some from other great speakers and community...
2010-08-19
368 reads
Upcoming SQL Lunches
Some great SQL Lunch sessions are coming up. Some from Pragmatic folks and some from other great speakers and community...
2010-08-19
387 reads
Week in Review – August 7, 2010
This post is the first in a new weekly series meant to give my readers some insight into my week....
2010-08-19
642 reads
White Paper Wednesday – Bulk Report Generation with SSIS and SSRS 2008 R2
Hey folks,
It’s white paper Wednesday and this week we’re looking at Bulk Report Generation using SSIS and SSRS 2008 R2...
2010-08-19
480 reads
White Paper Wednesday – High Availability with SQL Server 2008
Hey folks,
It’s white paper Wednesday and this week we’re looking at High Availability with SQL Server 2008 by Paul Randal(Blog)|(Twitter)....
2010-08-19
345 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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