Time to get Agile
For those of you whose BI projects never resemble your prom night (never getting past first base), it’s probably time...
2010-09-06
229 reads
Awards for SQL Heroism
Motivational time again!
Have you ever worked on a project where someone was seeking their moment in the sun for an...
2010-09-06
227 reads
SQL Motivation for your Monday
Motivational time again!
Sometimes things cannot be explained. Like this guy in the picture. I think he’s gunning for his own...
2010-09-06
340 reads
SQLMotivation for your Monday
Motivational time again!
Today I want to talk about being lazy with your data. More likely than not, it’s not your...
2010-09-06
171 reads
Managing Contacts
This is one of those posts that has little to do with SQL Server and more to do with helping...
2010-09-06
564 reads
Whitepaper Wednesday - Introducing Microsoft StreamInsight
Hey folks,
It's whitepaper Wednesday again and this week we're talking about "Introducing Microsoft StreamInsight" by: Torsten Grabs, Roman Schindlauer, Ramkumar...
2010-09-06
856 reads
An impossible case
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing...
2010-09-06
552 reads
Idera SQL Tools – An evaluation (Part 2)
This is the 2nd in the series of evaluations I have carried out on Idera’s SQL Server Toolbox. The first...
2010-09-06
1,327 reads
SQL Saturday #48 - Columbia, SC Schedule Posted
The sessions have been selected and we have posted the schedule for SQL Saturday #48 - Columbia, SC. A huge thank...
2010-09-06
625 reads
Parallelism in SSIS - Multiple Lookups
This question just came up in the forums, and it highlights how difficult it can be to try to optimize...
2010-09-06
2,161 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