DBA's Delight
Tto the beat of “Rapper’s Delight”
“Now what you hear is not a parse
I'm rapping to the code
'cause me, my tweeps,...
2009-05-19
1,525 reads
Transaction isolation level
Transaction isolation level:1. Uncommitted Read (NoLock)2. Committed Read (blocking)3. Repeatable Read (phantom)4. Snapshot (no blocking)5. Serializable (no blocking)Dirty Read:(DR)Non Repeatable Read:(NRR)Phantom:(P)Great...
2009-05-19
1,154 reads
Finding a New Laptop Bag
For the past couple years I've been using a Targus (I think the model 300 right now) and they've been...
2009-05-18
894 reads
TechEd 2009 Recap
Keynote speaker, Bill Veghte, Senior Vice President of Windows Business at Microsoft.
TechEd 2009 was started with a keynote presentation from...
2009-05-18
1,233 reads
Microsoft Offers User Groups Direct Support
If you are a leader of a Microsoft-related user’s group, and you haven’t done so already, you will want to...
2009-05-18
569 reads
Sign Up to Be Notified When SQL Server 2008 R2 CTP Release is Available
If you want to be the first on your block to see the CTP (Community Technology Preview) of SQL Server...
2009-05-18
492 reads
Larger & Cheap(er?) Monitors
I stopped by Compusa on the way home to pick up a package of blank DVD's and did the 10...
2009-05-18
785 reads
SQL Server Encryption - Hashing Limitations
As I'm digging more into SQL Server 2008 encryption I'm learning some interesting things about how SQL Server handles encryption....
2009-05-18
2,705 reads
Back in the Top 5
My rolling 30 day post count dropped crazily this weekend. I noticed, but with family committments, I didn't do anything...
2009-05-17
637 reads
The Pro-Active DBA during the Economic Tsunami
As none of us are immune to the current financial crisis, and your development projects have probably come to a...
2009-05-16
769 reads
Blogs
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers