T-SQL Tuesday #001 – Dates and Times
T-SQL Tuesday was started by Adam Machanic (@AdamMachanic) on his blog to encourage SQL Bloggers to share their tips and...
2009-12-08
464 reads
Blog Posts
T-SQL Tuesday #1: Date/Time Tricks
I’m going to try out Adam Machanic’s idea for a blog party. The topic this month are Date/Time tricks.
Instead of...
2009-12-08
667 reads
64 bit virtual PC Substitute
Hey there gang. I, like many of you, am very excited about the new betas for the 2010 product stack...
2009-12-07
344 reads
64 Bit Virtual PC Substitute - OpenSource to the Rescue
Hey there gang. I, like many of you, am very excited about the new betas for the 2010 product stack...
2009-12-07
464 reads
A CIO's Voice....
As you know if you follow this blog, Pearl Knows is the creator of the monitoring software SQLCentric, and offers...
2009-12-07
597 reads
Code Camp - Tampa, FL.
I recently attended Code Camp in Tampa and I want to thank everyone who made a SQL guy feel so...
2009-12-07
318 reads
Code Camp – Tampa, FL.
I recently attended Code Camp in Tampa and I want to thank everyone who made a SQL guy feel so...
2009-12-07
330 reads
Dismissing Warnings in SSAS 2008
When working with Analysis Services, you will often run into the same warnings over and over as you are developing....
2009-12-07
488 reads
Fundamentals of Storage Systems – RAID, An Introduction
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-07
8,946 reads
Getting the Most Out of SQL Server Profiler Using Templates
In case you haven’t discovered this for yourself, SQL Server Profiler is one of the most powerful tools that come...
2009-12-07
1,409 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