SQL Server 2008 and 2008R2 Diagnostic Information Queries
Since SQL Server 2008 R2 has gone RTM, and will be available on MSDN Subscribers on May 3, I thought...
2010-04-27
1,928 reads
Blog Posts
SQL Server Replication Overview
For my next series of blog posts I intend to document and write about SQL Server replication. This is a...
2010-04-27
2,496 reads
SQLSaturday #41 – Atlanta Recap
I had the opportunity to go present at SQLSaturday #41-Atlanta this past weekend (April 24, 2010) and I had a...
2010-04-27
819 reads
SQLSaturday #49 Call for Speakers is Open & Call for Our PreCon Seminar
SQLSaturday #49 will be held in Orlando on October 16th, 2010, and our call for speakers is now open. We’re...
2010-04-27
590 reads
The PASS Summit Survey Results 2010
I hope there will be more surveys, so I’ll tag this as 2010. The results were released recently, and there...
2010-04-27
2,191 reads
The PowerShell and XML Corollary
Girl Property Surrounded by Geek Objects
I’ve just started watching The Big Bang Theory so I figured I’d borrow a naming...
2010-04-27
800 reads
2008 Upgrade Completed
Whew! So I've been super busy the past week and a half upgrading our production server from SQL 2000 to...
2010-04-26
702 reads
A DMV a Day – Day 26
Well, we are on the final week of the DMV a Day series for the month of April. I will...
2010-04-26
1,613 reads
Beware, events falling from the sky
Are SQL Saturdays falling from the sky? (from Jen McCown, @midnightDBA)
I think so. This past weekend had three events, #39...
2010-04-26
753 reads
Introduction to SSRS 2008 and SQL Saturday 38
In a few short weeks, another great event is coming to Jacksonville Florida at the UNF campus. There are many...
2010-04-26
357 reads
Blogs
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...
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...
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