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.
To Specialize or Not to Specialize: that is the $132,000 Question
In a guest editorial, Rodney Landrum reflects on his career path as a an information-hungry generalist.
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers