I’ll be talking about the following topics:
What should developers know about database design so they don't have performance and logical problems? What's new in SQL Server 2008 that helps solve some business problems that sometime required "hacking" before.
Read more →
I’ve written two articles on SQLTeam.com about a great new feature in SQL Server 2008 called Extended Events. They are the new low level, high performance eventing system in SQL Server.
Read more →
Recently i was looking for a SQL Server 2008 based template that would look cool. Since I haven’t found anything I’ve made my own. It’s a dark background template that you can use freely.
Read more →
A while back we had an interesting problem at work. We were calculating MD5 hashes for some values in both .Net and SQL Server and although the input values were all the same our MD5 hashes were different.
Read more →
Indexes are one of the most important database features. Without them your database will crawl under a table in fear of simple queries on large tables or complex queries on small tables.
Read more →
This new version brings one completely new feature and a few improved old ones. The new feature is Window Connection Coloring. It includes a colored strip indicator that can be docked to any side of the window.
Read more →
Comparing result sets There are times, although not often that you have to compare 2 result sets. This usually happens when you're analyzing data for whatever reason or unit testing a database.
Read more →
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 →
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 →
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 →
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 →
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 →
I've written an article here on SQL Team about Integrating Profiler and PerfMon Log Files.
Troubleshooting SQL Server requires the use of both PerfMon (Performance/System Monitor) and SQL Trace files created by SQL Profiler or directly by SQL Server trace.
Read more →