Risking Health, Life and Family
Since announcing the topic last week for T-SQL Tuesday, I have thought about many different possibilities for my post. All of them would have been really good examples. The...
2014-02-11
Blog Posts
Scalar functions can be the hidden boogie man
Ran across a comment the other day that scalar functions prohibit parallelism for a query when included. I thought it...
2014-02-11
853 reads
Should I learn PowerPivot yet?
Rob’s got a good post called What is Power Pivot’s #1 Competitor? which has some great comments, as well as...
2014-02-11
690 reads
SQL Server – Using Tools to Analyze Query Performance
Here is the session I gave for the techies at Microsoft about in-built tools available in SQL Server to analyze...
2014-02-11
963 reads
The Genealogy of Baseball Teams
The Genealogy of Baseball Teams chronicles the origin and evolution of baseball teams from every major league from the inception...
2014-02-11
355 reads
2014-02-11
255 reads
T-SQL Tuesday #051: Always Hedge Your Bets
It's time for T-SQL Tuesday again and this month's host is my former co-worker, the @SQLRNNR himself, Jason Brimhall. Jason's...
2014-02-11
717 reads
T-SQL Tuesday #51 – Place Your Bets
It’s T-SQL Tuesday time again and Jason Brimhall is hosting this month’s event. He used to live in Las Vegas,...
2014-02-11
788 reads
T-SQL Tuesday#51 - Place Your Bets - In-Place Upgrade.
I’m not much of a
betting man, but if I had to bet that I would participate in this month’s T-SQL
Tuesday...
2014-02-11
2,008 reads
Using PowerQuery with Email
At our last MVP summit, I sat in on a session on PowerQuery. Our presenter, who is pretty passionate about...
2014-02-11
329 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers