SQL Math: Whole Numbers, Real Numbers
It’s been a long time since grade school math, and for some the details have become kinda fuzzy. I’m no...
2011-03-28
1,875 reads
SQL Awesomesauce
An Analogy is like a Tree….
For years, I’ve been trying to express how everything ties into everything else. A big part of understanding any given...
2011-03-25
488 reads
Maaaaaagic Tables!!!
I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X...
2011-03-24
2,378 reads
Not Cool Enough for Firefox
I’m pretty consistently behind the curve on most things. It took three years for me to get into The Office...
2011-03-22
877 reads
Filmed: DBAs@Midnight Episode 2.30
Friday night (as per usual) we filmed a new episode of our 2 1/2 year old webshow, DBAs@Midnight in front...
2011-03-19
847 reads
Women in Technology SQL Lunch!
Attend SQL Lunch...the power of my sweater compels you...
This week on Friday, March 17 we’re having a free panel talk,...
2011-03-17
662 reads
24 Hours of PASS Spring 2011 Code Sins
Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring...
2011-03-15
670 reads
SQL University – Teach Your Children Well
“If you had a daughter, would you really encourage her to get into IT?” … “Yes, if she loved it.”
- My...
2011-03-10
970 reads
T-SQL Tuesday #016: Aggregates and Windowing Functions and Ranking! Yum!
Let’s get this out of the way right now: I am SO going to take advantage of this T-SQL Tuesday...
2011-03-08
893 reads
Women in Technology PPT Template
Well hey-howdy-hey (as we don’t say in Texas), it’s Women’s History Month! And by all accounts, it’s going to be a...
2011-03-04
1,011 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers