Writing Before Reading
We often learn to write code before we really learn to read it, which seems like a problem to Steve.
Install SQL Server from Configuration File with Installation Center
Learn how to build a SQL Server Configuration file from the Installation Center and then use this configuration file for subsequent installations.
SQL Server 2019 in Containers
SQL Server 2019 in containers are a fast way to get started with SQL Server 2019, and can be used throughout your data estate from development to production.
Investing in Speed
Much of what we do to improve ourselves is an investment in our work. The same thing could be said about businesses. Today a little advice about making an investment.
The Products-Often-Purchased-Together Problem Solved in R
Learn how to analysis products that might be sold together using R and SQL Server.
Run SQL Server Agent Job from SSIS
While we can schedule SQL Server Agent jobs and SSRS report subscriptions, the actual time that we want to run them is dependent on when certain processing in our SSIS packages is completed. We also have certain business rules surrounding launching these jobs that we need to enforce which the built-in scheduling capabilities cannot accommodate. For example, we execute a SQL Server Reporting Services (SSRS) report subscription every Monday at 8:00AM but we want to skip it if the current week coincides with our month end processing which will also execute a report subscription for the same report. Can you provide a solution that we can use to accomplish this?
Six reasons to version control your database
For most application developers, it’s unthinkable to work without version control. So why is the database any different? This blog lays out 6 clear benefits to applying version control best practice to your database alongside your application.
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Choosing Reliable Service Providers for Tank Cleaning in RAK Maritime Port
When ships need to cleaning, it is important to choose the right service provider...
Columnstore index question
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Transactional Replication
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers