Using DTEXECUI to generate a DTEXEC command line statement the easy way
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool...
2013-08-05 (first published: 2013-07-31)
2,687 reads
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool...
2013-08-05 (first published: 2013-07-31)
2,687 reads
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle...
2013-07-31 (first published: 2013-07-22)
3,600 reads
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of...
2013-07-29
1,385 reads
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused...
2013-07-24
657 reads
I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting.
First here...
2013-07-22 (first published: 2013-07-15)
2,549 reads
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead...
2013-07-17
828 reads
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is...
2013-07-15 (first published: 2013-07-08)
2,192 reads
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions...
2013-07-01
2,718 reads
How will you back out if your change doesn’t work?! Always take a backup! There should always be a back...
2013-06-26
2,421 reads
What is a metadata function? According to BOL a metadata function is one that returns data about the database or...
2013-06-24
821 reads
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
Ontario, CA is home to a variety of restaurants, but when people talk about...
Ontario, CA is home to a variety of restaurants, but when people talk about...
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers