December 2007 Blog Posts
I've written an article here on SQL Team Database Backups in SQL Server. It's a first of two articles on backups and backup strategy Backing up a database is one of the most important things you need to do when having a database driven application. It 's only all of your data in there, right? But often developers and management don't realize the importance of backups and overall proper backup strategy for the most important side of the business – data and it's consistency. Part 1: Introduction to SQL Server 2005 Database Backups
it's my opinion that today we unfortunately live in a world that requires some kind of harder problem solving skills from maybe 20% of the population. And I'm being very very generous. So putting that percentage with the question in the title would give an answer similar to: "Because not every one can do it." DOH, right? I'd say you're wrong since everyone had a problem to solve at least once in a lifetime. So what's the problem? Why is it perceived as hard? Let's take a little trip through your past. When you were just an infant, what was...
I've written an article here on SQL Team about locking in SQL Server.
It's an introductory article that shows lock modes, lock granularity and lock compatibility matrix
and it will be followed by a few more advanced ones on the topic of locking.
Part 1: Introduction to locking in SQL Server 2005
I've released a new version of the add-in.
Most of the reported bugs are fixed and I've added two new main functionalities:
- Search Results in Grid Mode and through Execution Plans
- Generate Insert statements for a single table, the whole database or current resultsets (yes all of them) in grids
Insert statement support scripting binary data up to 5 Mb from image and varbinary(max) columns
Minor changes include customizable shortcuts and the ability to move the menu between tools submenu and main menu bar.
You can find it on www.SsmsToolsPack.com or subscribe to the RSS feed to get notified of the new changes...