Time Saver – Presentation Preparation
Presenting is a huge fear for many and it is no different for me. I have been presenting at SQL...
2010-10-10
591 reads
Project Phoenix
Project PhoenixSometime people need a hand up – an opportunity to rise from the ashes. Over the last couple of years...
2010-10-09
897 reads
What are Physical Sockets, Physical Cores, and Logical Cores and Why Does it matter?
I witnessed a confused conversation on Twitter today where someone was talking about how he uses the terms sockets and...
2010-10-09
12,727 reads
Issues With Calculating Current Age Using DateDiff (Rounding?)
Recently I inherited a set of SSIS packages that did a pretty simple calculation for age.It used the following expression,...
2010-10-09
1,387 reads
SSRS - Join Function
Often when designing a Reporting Services with parameters you
may be required to display those parameter values on your report.This is...
2010-10-08
4,199 reads
SQL Server Memory Related Queries
What is using all of my memory in SQL Server? If you ever believe that you are seeing signs of...
2010-10-08
2,752 reads
New Hotness: sys.objects and sys.schemas
Last month we talked about the old and busted syscomments- and the new hotness that is sys.sql_modules – for pulling code out of...
2010-10-08
693 reads
Free SQL Server Training for the Week of October 11, 2010
Monday
SQL Lunch - SSIS Design Patterns 1c: Variables, Events, and Automated Custom Logging Patterns - Andy Leonard
Tuesday
Idera - Accelerating Answers with Analysis Services...
2010-10-08
628 reads
Planning to Fail
Great title for a post, isn’t it? Seems foolish, lazy, or worse to plan for failure, right? Yet, in the...
2010-10-08
315 reads
Career Warfare - Book Review
I picked up Career Warfare on the recommendation of a friend that had seen the Modern Resume presentation. I grabbed...
2010-10-08
674 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