This is something I haven't noticed before but I think it's mighty cool!
When you choose to Include the Actual Execution Plan in SSMS 2008 it suggest any missing indexes it thinks that are needed.
Read more →
I've written a second article here on SQL Team on how to schedule jobs in SQL Server 2005 Express. Intro In my previous article we saw how to make simple job scheduling in SQL Server 2005 Express work.
Read more →
The victim of my carnage being a connection to the SQL Server 2005.
How many times have you issued a query that you had no idea how long it would run, just to loose your patience after 10 minutes and rolled it back, forgetting that it'll probably take 10+ minutes to rollback anyway?
Read more →
XML encoding is necessary if you have to save XML text in an XML document. If you don't escape special chars the XML to insert will become a part of the original XML DOM and not a value of a node.
Read more →
SQL Server Profiler is a well known tool for tracing different activity that happens between your server and the clients connected to it.
But very few people know that you can have custom events and trace them in the SQL Server Profiler.
Read more →
With this new version you can use it for SQL Server Management Studio 2008 and SQL Server Management Studio 2008 Express.
I've added a new feature to Search through the Database data.
Read more →
Let us start with a simple question:
What is the goal of software development, be it database or .Net (or any other language)?
The first answer would be: Customer satisfaction!
Read more →
I've written an article here on SQL Team on how to schedule jobs in SQL Server 2005 Express Intro
As we all know SQL Server 2005 Express is a very powerful free edition of SQL Server 2005.
Read more →
In my opinion these 2 batches should behave the same but they don't. the first fails and the second runs ok.
I've searched through Books Online for any clue but i haven't really found anything useful.
Read more →
For all enthusiasts out there this is how software development cycle works no matter what the project is:
Programmer produces code he believes is bug-free. Product is tested.
Read more →
I can't stress this enough:
Never ever call me on my work phone as a form of the first contact!
Unless I know you and have given you permission to call me, don't.
Read more →
In my previous post about immediate deadlock notifications in SQL Server 2005 I've shown a way to use a try catch block to get the deadlock error.
The con of this method, although it uses best practice for error handling in SQL Server 2005, is that you have to change existing code and it doesn't work for non stored procedure code.
Read more →
Here's a demo of a nice little bug in SQL Server 2005 when using LIKE comparisons for searching. What is so "nice" about it is that it only manifests itself if your search ends in number 9 followed by a wildcard when selecting only columns covered by a nonclustered index.
Read more →
On Monday I've finally installed the VS 2008 on my system. I put the installation DVD in, choose custom install, pressed run and went to lunch. After I returned, my computer was one VS 2008 richer.
Read more →
Deadlocks... huh??
Deadlocks can be a pain to debug since they're so rare and unpredictable. The problem lies in repeating them in your dev environment. That's why it's crucial to have as much information about them from the production environment as possible.
Read more →
After a long while I've finally managed to create a release version. I've also added some cool new features.
It is completely free and has no expiration date like the prior beta versions.
Read more →
Just as the title says :)
You can read the article here.
Thanx to Kevin Kline for publishing it!
Legacy Comments
Bill Graziano
2008-05-05
re: SSMS Tools PACK is featured in May issue of SQL Server Magazine Hey, congratuluations!
Read more →
Sometimes we wish to know what locks are being held by the transaction. Also it would be great to know what SPID owns the transaction, on which objects the locks are being held, what SQL statement caused the locks, etc.
Read more →
It does when it feels like it, but not in the way you immediately think of.
A few days ago Jeff posted about short-circuiting wondering how it works and since I've played with this a long while ago I thought I'd share my results.
Read more →
We all heard about the Chuck Norris Facts, right?
Well if you're a fan of security you have to be familiar with Bruce Schneier and his excellent blog.
What I didn't know is that he also has a collection of facts!
Read more →