Veterans' Day
I'll post Part III of Becoming a DBA tomorrow (meaning there will be two posts). Veterans' Day is typically celebrated...
2007-11-12
619 reads
Blog Posts
Resources: SQL Server 2005 Security
Work responsibilities took up my time on Thursday and Friday, so I never got around to posting. Here's the resources...
2007-11-11
623 reads
save disk when doing backup
As a DBA, most of us will also take care of test environment. However test servers usually cannot afford to...
2007-11-11
388 reads
bcp Utility
There was a time that I avoided bcp utility like the plague. A few years ago, we needed to set...
2007-11-09
637 reads
Celko on SQL Seminar Orlando - It's Time!
We (End to End Training) will be hosting our Celko on SQL seminar tomorrow (Nov 9th). It's not too late...
2007-11-07
690 reads
Does User Voting for Best Products Work?
I happened to get an email asking me to vote for a product that was being featured in one of...
2007-11-07
660 reads
Tools: Apex SQL Log, Apex SQL Log API, Sample Corrupted Databases
Apex SQL has announced a new version of Apex SQL Log as well as an API for it.
Release Notes...
2007-11-07
790 reads
SQL Server: Showing permissions for a given database user
Building upon my post from last Tuesday, if you know all the roles for a given user, you'll probably want...
2007-11-06
615 reads
Becoming a DBA, Part II
This is a follow-up to part I from last week. You've considered what you want to do, you've looked at...
2007-11-05
919 reads
Replicate Stored Procedure Execution Published on SSC
Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the...
2007-11-05
419 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers