Calendar Tables in T-SQL
In an earlier blog, we covered a type of auxiliary table (the Tally Table) that can provide a lot of...
2014-03-30
32,867 reads
Blog Posts
SQL Server 2014 RTM
The new version of SQL Server will be here on Tuesday.
(Someone at Microsoft has a sense of humour in releasing...
2014-03-30
1,514 reads
Houston SQL Saturday #308 – Presenting
Saturday May 10th – Houston SQL Saturday #308
I will be presenting at the upcoming SQL Saturday in Houston on May10th. For...
2014-03-29
1,219 reads
South Alabama Day of .NET Presentations Downloads
I have been running into longtime SQL Saturday friend Ryan Duclos at SQL Saturday events in Baton Rouge and Pensacola...
2014-03-29
1,196 reads
T4 Support in SSDT
Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me. On tuesday night,...
2014-03-29
1,157 reads
All in Fun
My first commercial!
Steve on a HorseThis comes from our DBA Team promotion, which is ongoing this year.
Filed under: Blog Tagged:...
2014-03-28
1,441 reads
Backup Checksums and Trace Flag 3023
One of the items I always flag when performing a health check on a server is whether backups are being...
2014-03-28 (first published: 2014-03-25)
3,610 reads
Building the SQLSaturday Orlando Marketing Plan–Part 1
I’ve volunteered to lead the marketing effort for SQLSaturday Orlando this year. Broadly speaking that means drive attendance to the...
2014-03-28
502 reads
Can’t See The Forest For the Logins–Question of the Day
My latest question is live today – Can’t See The Forest For the Logins is worth 2 points if you’re playing...
2014-03-28
440 reads
Encryption in Las Vegas – SQL Saturday #295
I enjoy Las Vegas, usually trying to see a show of some sort when I’m there. I’ll have the chance...
2014-03-28 (first published: 2014-03-25)
1,543 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers