Hard Core Object Oriented Programming Guidelines
I read Andrew Binstock occassionally in SD Times and in the most recent issue he posted a list of guidelines...
2008-05-21
1,702 reads
SQLAndy
Pop Quiz - What's the Max Number of Resultsets Supported by Management Studio?
Ran across this strange occurence while doing some testing. To duplicate the results (the actual code was a little more...
2008-05-20
1,484 reads
Managing & Professional Development Classes
I've been working on a rough outline for two new classes that will each be one day long. One on...
2008-05-18
500 reads
FlyClear, Privacy, and Time
Recently I signed up for the FlyClear program (www.flyclear.com), a registered traveler program. Over the past year I've been travelling...
2008-05-15
722 reads
A Display Challenge
I've grown to like the presenter view in Powerpoint 2007; let's me navigate easily, and more important, lets me easily...
2008-05-13
461 reads
Visiting Boston This Week
I get busy and usually forget to post when I'm out and about, but for once I've remembered. I'll be...
2008-05-11
461 reads
Follow Up Notes on SQLSaturday #3
Our most recent SQLSaturday went well, but there is always room for improvement. Here are my notes from this event:
The...
2008-05-08
397 reads
ACM, 5 Year Anniversary, and Customer Service
Time moves by and I was surprised to get a coffee mug in the mail from ACM (Association for Computing Machinery)...
2008-05-07
490 reads
One More SQL Feature Wish
It would be handy to have a checkbox/SET option/something that would tell SQL not to cache plans run in a...
2008-05-06
422 reads
Will You Host the Next SQLSaturday?
How to have more SQLSaturdays?
Over the past year we've been working on the ambitious goal of building a national franchise...
2008-05-06
796 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