SQL Server 2008 Database Mirroring in Action
I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...
2009-11-13
1,323 reads
Blog Posts
Super Seven Cleanup Steps Before Deploying Your Cube
Everyone likes to get a project done, but many times in our rush to deploy we bypass some of the...
2009-11-13
1,795 reads
Why We Recommend Against xp_cmdshell
Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...
2009-11-13
21,115 reads
Book Review: The Machine, The Story of the 1975 Cincinnati Reds
I grew up watching baseball on TV and playing it too, and for reasons I don’t recall my Dad’s favorite...
2009-11-12
545 reads
Flight or Invisibility: Which do you Choose?
A colleague of mine pointed out a great podcast called This American Life - specifically an episode with John Hodgman (the...
2009-11-12
1,061 reads
How did I become a DBA
This past Tuesday night I had the honor of speaking to a small group of college students who are all...
2009-11-12
790 reads
Looking Back – PASS Summit 2009 Day 4
Thursday started off with a meeting of the SQL Saturday minds over breakfast at Top Pot Donuts a few blocks...
2009-11-12
881 reads
New HP Envy 15 Laptop
After quite a bit of research, I pulled the trigger on a new HP Envy 15 system last Saturday. This...
2009-11-12
1,960 reads
PASS Summit 2009 – Keynotes
I’m not going to look back at the keynotes since I blogged about them. If you are interested, you can...
2009-11-12
770 reads
SSRS - Setting Default Parameter Values for Analysis Services Datasets
When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult...
2009-11-12
727 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