Never, Ever Use Clustered Indexes
Today we have a guest editorial from Grant Fritchey that might surprise you. Today Grant talks about clustered indexes in your tables.
Is Empowerment Good?
Today Steve Jones notes that we use computers to enable others to handle their own work without help. But is that always a good idea.
Managing Database Data Usage With Custom Space Alerts
A quick how-to on configuring SQL Server Agent alerts to manage file space usage.
Maintaining SQL Server default trace historical events for analysis and reporting
I often see questions online where someone wants to find out who started a trace, when tempdb last had an autogrow event, or when the last full backup for master occurred. Since these and other events are captured by the default trace, but the default trace only keeps five 20MB rollover files by default. This means that the event you are after may no longer be there, depending on how long ago it was and how busy your server happens to be. Unfortunately, people often need to find this information well after the fact.
Create Your Own Intense Interview
Today Steve Jones talks about interviews and the way in which he approaches them to make sure that the job is the best fit for both the company and the candidate.
SSIS FTP Task – Receive Files from FTP Site
This article will show you how to configure the FTP task in SSIS to recieve files from remote server using the FTP protocol.
Database Continuous Integration 101
We talk a lot about continuous integration here on the Atlassian Dev Tools blog, and many readers are bonafide CI gurus. Now that you are integrating your application code, test code, config files and deploy scripts, are you ready to take it to the next level? An increasing number of engineering shops are starting to bring the continuous integration discipline into their database development.
The PoSh DBA: Grown-Up PowerShell Functions
Laerte Junior goes step-by-step through the process of tidying up and making more reusable an untidy collection of PowerShell routines, showing how pipelines and advanced functions can make PowerShell more effective in helping to automate many of the working DBA's chores.
Connect QuickBooks to SQL Server through SSIS
This example uses an SSIS workflow to populate a database with QuickBooks data.
Happy Memorial Day 2012
It's Memorial Day in the US and Steve out is paying tribute to our soldiers and cutting grass on the tractor. He's left you a blooper reel to enjoy.
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers