SQL Saturday is coming, for reals this time. This morning I received an email with the finalized speakers’ schedule and promptly went into a panic when I realized I was...
Welcome back to SQL Saturday’s. Today I wanted to discuss a T-SQL trick I frequently use to search for the existence of records. SQL Server has a fun function calls...
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...
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.
