What is a dirty backup? When I’m developing code for resolving data problems, I can’t always restore the dev database from a production backup. Other people have code in Dev,...
Here’s a thought for today’s SQL Saturdays post. At the start of the week, I worked a project to update a monster SSIS feed with new information. This required a...
ACID is a fundamental concept behind all database design and administration. Without it, there would be a lot more bad data in this world than we already have. Can you...
It is a Josie & the Pussycats movie soundtrack morning. As the beats pound through my head, I am resolving failed SQL Server jobs, ftp file problems (they didn’t decrypt...
SQL Server maintenance can be a pain. There are so many moving parts that checking every single possible maintenance point takes forever. Being the lazy DBA that I am, I...
I recently received some offline emails asking me about the best way to train in SQL Server. I see these requests on the forums every year about this time. “How...
One of the more difficult aspects of dealing with SSIS packages is the need to find files dynamically. Meaning we don’t always know the exact name of the file or...
Ever run into this error when building an SSIS package? I did, just last week. Here’s the full text of the error: SSIS package "MyPackage.dtsx" starting. Error: 0xC002F210 at Cancel...
It turns out the Obama campaign wasn’t the only group to put together a data mining project for the presidential campaign. The Romney campaign has a project they titled Project...
Have you heard the one where a man wins an election with a database? If you’d paid any attention to Election Day in the United States, then the answer is...
Brandie Tarvin is an author and tie-in writer and a copy editor. In addition to her original fiction, she has written SQL Server articles, Shadowrun: The Role Playing Game sourcebook material and fiction as well as a piece for Hasbro’s Transformers. She currently lives in Florida with her family and is owned by two cats.
