My Conversation with Ted Kummert at the PASS 2010 Summit
For some mysterious reason, I was selected as one of the “official” bloggers/tweeters during the PASS Keynotes last week. This...
2010-11-15
602 reads
Glenn Berry
New Path to MCM in SQL Server 2008
Last week, during the first day of the PASS 2010 Summit, Microsoft’s Joe Sack announced the revamped testing program for...
2010-11-15
1,298 reads
SQL Server 2005 Diagnostic Information Queries (November 2010)
Here is the November 2010 version of my diagnostic information queries for SQL Server 2005. Many of these queries are...
2010-11-15
2,653 reads
XBox 360 250GB and Kinect Bundle
I took the plunge and bought one of the new 250GB XBox 360 and Kinect bundles for $399 at Best...
2010-11-14
799 reads
Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance
I will be presenting my session on hardware selection and sizing today at 10:15AM in Room 608 at the PASS...
2010-11-11
637 reads
Full-Text Search Enhancements in SQL Server Denali
Since Microsoft announced the existence of CTP1 of SQL Server Denali during Ted Kummert’s keynote address at PASS 2010 yesterday,...
2010-11-10
833 reads
Why is SQLSaturday Such a Big Secret?
One of the small mysteries of the universe that I have been pondering lately is the fact that so many...
2010-11-10
420 reads
Day 1 at SQLPASS Keynote Address
Microsoft announced the RTM of SQL Server 2008 R2 Parallel Data Warehouse, which will be available as an appliance in...
2010-11-09
454 reads
November 2010 Version of SQL Server 2008 Diagnostic Information Queries
Apparently, when I posted this a few days ago, the Windows Live Writer plug-in that I used mangled the T-SQL...
2010-11-09
1,292 reads
Official Blogger at 2010 PASS Summit
I will be one of the “official” bloggers during the 2010 PASS Summit, which means that I get to sit...
2010-11-09
467 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Be Wary of Data
Comments posted to this topic are about the item Be Wary of Data
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;