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,037 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
509 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
455 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
590 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
662 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
322 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
417 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
392 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers