Author: Bradley Schacht

5

A Caution About Checkpoints

Checkpoints in SSIS are a great tool and they definitely have their place.  The downside to them is that they are not so good when you start talking about parallel processes or containers.  What follows is a little bit of...

Welcome! 1

Welcome!

Let me start by welcoming you to BradleySchacht.com This is me looking into distance, dramatic I know: Here is a little bit of information about myself: I grew up and currently live in Jacksonville, FL I’m more than just a...

4

Missing Perfmon Counters

Perfmon is a great tool to get a closer look at what is going on in your environment as queries and packages run.  There are a ton of counters ranging from OS to third party.  In our case we are...

Division: SQL Server Style 0

Division: SQL Server Style

When doing calculations in SQL Server queries it is important to know that anything without a decimal is going to be treated as an integer and therefore will cause the result to be an integer as well.  For instance, lets...

0

Query to Find Database and Log File Information

I have recently been dealing with a situation with a client where the transaction log has become an issue.  Naturally during the research portion of trying to figure out what is wrong I wanted to find things like the size...

1

Batch Files, Command Lines

The problem once you get over the learning curve of SSIS is not the tool; it’s all the things that work with SSIS and that can be used by/with SSIS.  For instance, there are a ton of things that you...

Database Recovery Models 0

Database Recovery Models

Database recovery is a very important thing, especially to DBA’s, and the occasional developer who screws something up.  Please note, I am a developer and I would NEVER mess ANYTHING up in a database.  I treat all databases equally and with respect.  Anyway, we are getting off...

Query SQL Server Job Tables 1

Query SQL Server Job Tables

If you have ever wanted to query the SQL Server job tables then you know they are a little cryptic. The following query will assist you in getting some useful information out of those tables. I recently wanted to be...

Multiple CTEs in One Query 0

Multiple CTEs in One Query

CTEs are a great thing to use in your query.  They are an excellent way to consolidate code and make it readable as well as create a “view” inside of your code.  One great thing I have used them for...

Pre-Compiled Script Task Error in SSIS 2005 0

Pre-Compiled Script Task Error in SSIS 2005

There is an issue with script tasks in SSIS 2005 that could come up occasionally.  It is generally an issue that shows up in a 64-bit environment where the script can’t be pre-compiled.  The error that will show up states that “The...