Developing Your DBA Skills Further Thanks to Experience with Multiple RDBMS
Any DBA who really understands databases and SQL standards can make out with other RDBMSs quite well, and if they...
2010-02-24
3,056 reads
Managing user data and response through 'drop boxes'
There are a few ways to get data from a client to your system; FTP or email. Internally we tend...
2010-02-24
624 reads
Plan for Failure
Notice I didn't title this "Plan to Fail." We should never plan to fail. That's sabotage. And that ain't right,...
2010-02-24
1,021 reads
Upcoming SQL Lunch Webinars
If you haven’t attended a SQLLunch, I suggest that you put this upcoming lunch on your schedule. Brad McGehee, SQL...
2010-02-24
1,038 reads
Featured Blog: Aloha DBA
If you’ve been around SQL for any length of time it’s hard not to have heard of Brad McGehee, the...
2010-02-24
568 reads
Disaster Recovery at SQLServerCentral
We had a spammer post a bunch of random, silly posts last week. I knew it was an issue when...
2010-02-24
769 reads
Adventures in Webinar Presentations
Over the past several years, I have given 2-3 live web presentations a year, and I have always found them...
2010-02-23
650 reads
Find Ultimate Parent at any Level From Any Level
Recently I got a forum question that I thought would be a good blog entry for others to share.
The question...
2010-02-23
875 reads
SQL Server 2008 R2 Gets a Real Date
Hot Off The Presses !
This isn’t like when you stood in line at the kissing booth in high school. SQL...
2010-02-23
506 reads
Setup a Database Snapshot
I have been tinkering lately with database snapshots and I thought the subject warranted a short post on the subject....
2010-02-23
752 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