Quick and Dirty Code Compare
MS Word 2007 (and probably earlier versions) have the ability to do a basic document compare, useful if you're at...
2008-06-30
1,335 reads
SQLAndy
Why Format TSQL?
Recently I had the chance to help a student debug a problem on a production server. It appeared to be...
2008-06-29
1,462 reads
Volunteering
Recently I was visiting with an old acquaintance and one of the topics that came up was volunteers. At some...
2008-06-26
2,217 reads
SQLSaturday Call for Speakers - Cleveland & Olympia
Call for speakers is open for SQLSaturday #5 in Olympia, WA on Oct 10 (note that the MS BI conference...
2008-06-25
1,466 reads
Employee or 1099?
My friend Wes Dumey does a lot of work in the business intelligence sector as a contract employee and has...
2008-06-24
1,621 reads
Microsoft BI Conference Oct 6-8, 2008
Had missed the announcement, came up in conversation yesterday with a friend, the BI conference will be Oct 6-8 in...
2008-06-23
1,640 reads
Notes on My Visit to Birmingham SQL Group
Spent last Tues/Wed in Birmingham, speaking at the user group Tuesday night and then presenting a seminar on Wed. Attendance...
2008-06-22
1,405 reads
Transparent, Translucent, or Opaque? Whats Your Strategy?
It's a couple weeks old, but there was a mild blog roar over some comments from Microsoft about wanting to...
2008-06-19
1,553 reads
SQLSaturday #4 Lessons Learned
Earlier in the week I posted a quick & positive note about the event, today I'll add some notes about things...
2008-06-18
1,390 reads
Link: Killing Terminal Service Connections
Needed to kill a connection so I get could logged on recently to a server and didn't have the server...
2008-06-17
1,395 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