DATEADD and variables in SQL
To make the T-SQL function DATEADD more dynamic use variables. The example below , accepts an input parameter , in this case...
2011-12-06
2,333 reads
Blog Posts
DBA in Space: Behind the Scenes—Question 12
This is a continuation of my DBA in Space journal.
As this scene starts on Lunar Exhibition set, Miss Friday is...
2011-12-06
477 reads
December Event Reminder
We are now only two days away from the biggest event of the week!! More accurately though, it is the BIGGEST event for the Las Vegas chapter of...
2011-12-06
8 reads
December Event Reminder
We are now only two days away from the biggest event of the week!!
More accurately though, it is the BIGGEST...
2011-12-06
660 reads
Excel for the DBA, Part 1–The Basics
This will be a series of handy hints for people that know SQL and are frustrated by Excel. I am...
2011-12-06
2,127 reads
Extended Events - inaccurate_cardinality_estimate
Extended events have been a bit of a personal “Elephant in the room” for me. I know they are there...
2011-12-06
2,743 reads
How to Build a Resume (that doesn’t suck)
Resumes are like opinions, which are like something else: everybody’s got one. And if you don’t have one, then certain...
2011-12-06
3,165 reads
Meet the DBA in Space Judges
Judging any contest is difficult, as you want to be as fair as possible. So coming up with the final...
2011-12-06
656 reads
Power Tools for Windows
Scott Hanselman has a great list of the power tools he uses for Windows and development. It’s worth a read,...
2011-12-06
1,808 reads
Quiet Wednesday
For me the Wednesday before Thanksgiving was a quiet day at work. It was one of those ‘everyone is leaving...
2011-12-06
622 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
BCA KCP Summarecon Mall Serpong Telp:0821°7555°651
Telp&Wa 628217555651 Down Town Walk, Summarecon Mal Serpong Unit DGF, Jl. Boulevard Raya Gading...
Alamat BCA KCP ITC BSD Telp:0821°8200°203
Telp&Wa 628218200203 Ruko ITC BSD, Jl. Pahlawan Seribu Blok R No. 41 & 42,...
Alamat BCA KCU ALAM SUTERA Telp:0821°8200°233
Telp&Wa 628218200233 Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong, Kota...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers