SQLRally Pre-Con Selection Process – Draft for Comment
Hopefully you’ve heard by now that PASS is launching a new event format called SQLRally in May 2011 in Orlando....
2010-08-31
1,892 reads
Blog Posts
Unique and non-unique non-clustered indexes on a unique clustered index
In the last weblog
post I have talked about the difference of unique and non-unique clustered indexes.
As you have seen SQL...
2010-08-31
9,795 reads
Convert Several Columns in SSIS With Fewer Clicks and Confusion
I've had this one in my toolbox for a while now, decided to publish it on CodePlex a while back,...
2010-08-30
702 reads
Defensive Db Programming Chapter 06
We are here again after another week and ready for another episode in this series. Today we get to talk...
2010-08-30
1,766 reads
Hardware Performance Research
I am trying to gather some information about some of the newer Intel and AMD processors as part of my...
2010-08-30
1,890 reads
How Old Are Your Database Statistics?
Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having...
2010-08-30
10,965 reads
Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars)
Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars)
#33-SSRS 2008 R2 - Indicators, Sparklines and Databars
Speaker: Patrick LeBlanc
Add To...
2010-08-30
1,696 reads
NetFlix and Null
There are some progressive companies out there, and I think they are doing some very interesting things with how they...
2010-08-30
1,566 reads
PASS Update #42
Our most recent board meeting was in Nashville on Aug 19, 20. We had originally discussed meeting in Seattle/Redmond/Vancouver, but...
2010-08-30
963 reads
SQL or MDX query trace in SSRS - trick of imagination or a real thing?
I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...
2010-08-30
3,312 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