Tally Table - Character Date Validation
Tally (or numbers) tables are one of my favorite query writing tools. Such a simple premise that can be applied...
2009-12-14
3,036 reads
Blog Posts
Tips on SQL Server Fixed Roles
Both of my tips are up on MSSQLTips.com on fixed roles. You can find them here:
Understanding SQL Server Fixed Database...
2009-12-14
821 reads
What is Your Biggest Weakness?
I was tagged by Ken Simmons (@kensimmons) in the blog chain started by David Stein (@made2mentor). Here’s Ken’s post and...
2009-12-14
508 reads
Energy Update - Wind Power Picking Up
It must be picking up again, despite the lack of a sharp rise in energy prices, I am seeing more...
2009-12-13
453 reads
oPASS Meeting Notes for December 2009
We started off our end of year meeting with our standard networking meet and greet. It’s going smoother, people are...
2009-12-13
561 reads
Where Should I Go From Here?
I’m closing in on vacation – finally – and one of the things I’ll have in the back of my head while...
2009-12-13
588 reads
Email: Getting My Attention, The Wrong Way
I was scrolling through my professional email as my wife drove me in to work (my car is being looked...
2009-12-11
660 reads
Load Windows 7 with a Thumb Drive
With the explosion of Netbooks, it has become important to find new ways to load operating systems. I recently picked...
2009-12-11
320 reads
Locking Scripts
Thanks to everyone who attended my TechNet Thrive! and Nashville SQL Server User Group presentations this week! I hope it...
2009-12-11
415 reads
Orlando Tiki Hut Roadshow Silverlight Edition
Assuming no major problems at work, I’m heading to the South side of town the afternoon of Dec 14, 2009...
2009-12-11
390 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
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...
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
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