Compress Everything
Data grows constantly and the size of some of our databases seems to have no end in sight. Steve Jones notes that we might just want to compress everything, just to keep up.
Run an Oracle package from SQL Server Integration Services
If you want to run an Oracle Package and then execute a web service, copy files or folders, a sequence of tasks, you may need to use SQL Server Integration Services (SSIS).
SQL in the City - Austin 2012
A free day of training in Austin, TX with Grant Fritchey, Steve Jones and a few others. Join us to learn about SQL Server and how you can more efficiently work in your job every day.
SQL Server 2012: Migrating BLOBs to FILETABLEs
Learn about this new feature in SQL Server 2012 and how to move your binary data.
Never update systems tables directly - a study in Agent job scheduling
It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.
The Longevity of the Relational Database
Waves of NoSQL hysteria come and go but the relational database remains, and Phil Factor admires its sheer ubiquity, and ability to provide data integrity and accessibility for a vast tapestry of data categories.
Three Rules for Database Development
Today Steve Jones talks about a series of rules he found for database development.
TSQL Challenge 82 - Find elements that uniquely make up a group
The challenge is to find the Tax Code based on Price. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.
Distributed Computing - Hybrid Systems Considerations
When the Cloud was new, it was often presented as an 'all or nothing' solution. Nowadays, the canny Systems Architect will exploit the best advantages of 'cloud' distributed computing in the right place, and use in-house services where most appropriate. So what are the issues that govern these architectural decisions?
SQL in the City - New York 2012
Come join Grant Fritchey, Steve Jones and others for a free day of training in New York City on Sept 28, 2012.
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers