PASS 2011 Pre-Conference Seminars and Spotlight Sessions Released
I have wanted to go to PASS Summit for the last several years, but have yet to get an opportunity...
2011-06-02
674 reads
Blog Posts
Un-SQL Friday #004: Speaker Lessons Learned
I began writing a story about, shall we say, a less than positive speaking experience…and then I realized: This is...
2011-06-02
1,089 reads
Windows 8 demo
A Windows 8 demo was just released. Looks really cool. Check it out at Previewing ‘Windows 8’ as well as Microsoft’s...
2011-06-02
670 reads
Do You Ever Physically Defragment Your SQL Server MDF & LDF Files?
Every since the first file was written to a floppy disk drive using DOS, physical file fragmentation has been a...
2011-06-01
1,992 reads
DQ & MDM Book Available to Download
If you’re looking for a resource on the Data Quality and Master Data Management features in SQL Server 2008 R2,...
2011-06-01
1,224 reads
June Question: How Do You Monitor Your SQL Servers?
As DBAs, one of our biggest responsibilities is to monitor our SQL Servers to ensure they are performing as expected....
2011-06-01
1,250 reads
PASS Announces Pre-conference and Spotlight Sessions for PASS 2011 Summit
Today, PASS announced the Pre-conference and Spotlight Sessions for the PASS Summit 2011 in Seattle, which will run from October...
2011-06-01
1,105 reads
PerformancePoint wish list – change a datasource
One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid. There is...
2011-06-01
814 reads
Re-Focusing the Blog a Bit
In recent weeks I've strayed pretty much all over the map with respect to topics. I have another blog, the...
2011-06-01
736 reads
SQL Exercise During Candidate Interview Process
A discussion of how BPS uses a SQL exercise for candidates and why it is helpful.
At the Boston Public Schools,...
2011-06-01
2,711 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