Altering an Existing Table to Support Temporal Data
In this article Greg Larsen explores using the temporal table feature of SQL Server 2016 to create a history table for an existing SQL Server table.
A Beautiful Google Mind
Larry Page is a very interesting person, one that is looking to change the world.
Migrating SSIS Projects and Parameters, Part 1
In this first part to looking at deploying SSIS packages to new environments, Andy Leonard looks at a few options for migrating your work to a new instance.
Taking Azure SQL Data Warehouse for a Test-Drive
Azure SQL Data Warehouse uses SQL to query the data, but there are some differences to SQL Server's dialect of TSQL, and queries don't necessarily work in the same way. DBAs are also required to use SSDT to access Azure SQL Data Warehouse. It is worth taking the time to try the preview of the product, and take it for a 'spin around the block', following Robert Sheldon's walk-through.
Triple Check Your Restores
After the crash of an US Air Force database was reported, Steve Jones has some advice.
Be the first to try Redgate SQL Compare 12
We are excited to announce the beta release of SQL Compare & SQL Data Compare 12. We want to use this beta period to get as much feedback from you, the SQL community, as possible. Try it out, or for more information on what’s new, read on.
Improved Support for Parallel Statistics Rebuilds
Jonathan Kehayias takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the same table.
SQL Server 2016 is Just Faster
SQL Server 2016 runs faster, sometimes without you changing anything.
Blogs
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers