ReadyRoll Development
This is the sixth part in the series: SQL Server and Continuous Integration. This post will illustrate the power of ReadyRoll when...
2017-01-03 (first published: 2016-12-23)
1,293 reads
What Agent Job is Running – Back to Basics
It is quite common to be required to investigate performance issues on the server. With this, it is occasionally necessary to be able to interpret an obfuscated job name....
2016-12-23
45 reads
What Agent Job is Running – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2017-01-02 (first published: 2016-12-23)
2,087 reads
Merry Christmas
Yesterday was the last working day before Christmas at GRE Towers. We’ve got today off. So this is just a...
2016-12-23
435 reads
SQL Saturday Returns to Rochester!
The Rochester, NY chapter of PASS is holding our 6th annual SQL Saturday on April 29th, 2017! As always, RIT is hosting our event on campus.
SQL Saturday is a free day of training centered...
2016-12-23
9 reads
Quick Command Shells–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-12-22
614 reads
Windows Server 2016 and SQL Server 2016 – A match made in heaven!
For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why I’m super excited about this! With Windows Server 2016,...
2016-12-22
9 reads
Windows Server 2016 and SQL Server 2016 – A match made in heaven!
For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why...
2016-12-22
1,261 reads
SSIS Custom Logging Levels
In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For...
2016-12-22
487 reads
Database Backups – Back to Basics
In this article, we will explore database backups. More specifically, how do you truly know if you have a successful backup? Here's a hint: it has to deal with...
2016-12-22
15 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