My Favorite Attorney – Chris D’Amico
Not often I do plugs here, but then again, it’s rare that I just get first class service, so read...
2010-10-07
386 reads
SQLSaturday Advice - Scheduling
One of the things that I’ve seen cause a few headaches at SQL Saturday events is the scheduling. First, before...
2010-10-07
500 reads
Speaking at the Houston Techfest
I am heading down to Houston, TX to speak at the Houston Techfest this weekend. Being a Houston native makes...
2010-10-07
403 reads
VMWare vSphere database maintenance
I recently did a VMWare/SAN assessment for a client. The expressed reason, or the reason relayed to me (not always...
2010-10-06
3,937 reads
SQLSaturday #49 (Orlando) Is Right Around The Corner - Have You Registered?
As I write this SQLSaturday #49 in Orlando is right around the corner - October 16, to be exact. My friends...
2010-10-06
465 reads
Stop Forgetting the DAC
From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or...
2010-10-06
964 reads
SQL Saturday 58 Schedule Released
We technically released it on Monday but I didn’t want to blog about it for a couple days since we...
2010-10-06
743 reads
One Meel-ee-yon Posts
We crossed the 1,000,000 post mark on SQLServerCentral today and that’s very cool to me. A few others as well...
2010-10-06
429 reads
Connection Strings: Database Mirroring Failover Partner Setup & Sample Backup/Restore Preparation Script
After having setup my first SQL 2008 R2 Enterprise (build level 10.50.1702) database mirror as High Safety with automatic failover,...
2010-10-06
6,252 reads
So I Got Promoted, Now What? Get To Know Your Peers
[This is part four in a series of posts about how to effectively transition to your new role after being...
2010-10-06
803 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers