The Basic Truths about Data
In reviewing database development best practices recently I'm reminded of an attitude I've found prevalent in many development shops, that...
2009-08-03
400 reads
SQL Saturday #17 – Baton Rouge
At 5:00 AM on August 1, 2009 I was awaken by a ringing cell phone. It was Mark, the official...
2009-08-03
491 reads
SQL Server Standard
PASS is relaunching the SQL Server Standard with a wholly new approach and format. I’ll put more out about it...
2009-08-03
714 reads
DBAs Continue to Make More than Other IT Professionals
According to a study by PayScale, and published in the July/August 2009 issue of Inc. Magazine, Database Administrators make more...
2009-08-03
558 reads
Active August
One of the bloggers here at SQLServerCentral (and a good friend) posted a note about Active August
last week. In the...
2009-08-03
393 reads
24 Hours of PASS
I’m fairly certain Jack Bauer isn’t involved with this new initiative from PASS. Just as I’m also certain I won’t...
2009-08-03
741 reads
Free Training! 24 hours of PASS
PASS is sponsoring a 24 hours of PASS event on September 2nd. Consecutive live (Live Q&A also) 1 hour sessions...
2009-08-03
320 reads
Looking back at SQLSaturday #17 – Baton Rouge
I woke up early on Saturday for a run. Staying at the Cook Hotel on the LSU campus, I had...
2009-08-03
585 reads
What's new in Sql Server 2005
Its very difficult to write what all new in Sql server 2005, almost everything is new... the complete engine has...
2009-08-03
731 reads
LinkedIn References
One of the interesting features of LinkedIn is the ability to post a reference about a connection. If you think...
2009-08-02
876 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