SQL PASS Summit 2009 - Day 2
Day two of the summit found me in the keynote, an interesting but much too long (2 hours) for comfort. ...
2009-11-03
665 reads
Blog Posts
Table and Index Partitioning Demo
I get a lot of requests for explanations about the different concepts and the easiest way to demo partitioning in...
2009-11-03
355 reads
Tabs Out of Control
I was working with a team of developers this week who were having the hardest time finding the keystroke to...
2009-11-03
325 reads
The Best Day of the Year - The SQLServerCentral Party at the PASS Summit
Each year I host an opening night party at the PASS Summit. I set up a deal years ago with...
2009-11-03
1,433 reads
The Enduring DBA
We are all facing the challenges of this new economy. There are very few people and industries in the world...
2009-11-03
298 reads
Ups and Downs of Cases in SSMS 2008
Recently I was working with client and they were discussing the pet peeves of some of the new intellisense features...
2009-11-03
400 reads
Week of Warehousing - Questions Answered
Greg emailed me a great question from my week of warehousing webinar the other day. We were discussing disk performance...
2009-11-03
268 reads
Week of Warehousing Review
How exciting was last week! Some of the top experts in the country all gathered together through support from SQLServerCentral.com,...
2009-11-03
204 reads
2009 PASS Community Summit Registration Starts Out Strong
Registration for the 2009 PASS Community Summit started out strong with many attendees registering early the Sunday evening before the...
2009-11-02
484 reads
Day –2 (Sun) at the PASS Summit 2009
Flew out of Orlando direct to Seattle, leaving at 8:30 and arriving about 1130 am Seattle time. Nice flight, no...
2009-11-02
359 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