- Click on me. Choose me. - asked one forgotten feature when some bored DBA was purposelessly wondering through the Management Studio menu at the end of her long and busy working day. - Why would I use you? I have heard of no…

… Four tortoises were playing in the backyard when they decided they needed hibiscus flower snacks. They pooled their money and sent the smallest tortoise out to fetch the snacks. Two days passed and there was no sign of the tortoise. "You…

A very useful error handling TRY/CATCH construct is widely used to catch all execution errors  that do not close the database connection. The biggest downside is that in the case of multiple errors…

I am truly exited to move this blog to SQLblog.com ! http://sqlblog.com/blogs/maria_zakourdaev/default.aspx You are more than welcomed to drop by. Stay tuned Over and out ;)

Working with the SQL Server replication is not a great pleasure. Working with the SQL Server replication replication is not a great pleasure, when all is working as you expect. Working with the SQL Server replication replication is not a…

If you are using DBCC LOGINFO in the production environment and you are lucky enough to still have an instance of SQL Server 2005 which, suddenly out of the blue, started throwing “non-yielding processes on scheduler” errors into the error…

There is an easy way to open several connections to your SQL Server in order to perform load testing. You can use Management studio "Multiple Server Query Execution" feature. This feature is usually used to run the same query against…

The PASS summit is an amazing event, it is fantastic to see more than 4000 SQL Server DBAs and BI developers from all over the world at the one place. Everyone here is talking SQL, joking SQL and breezing SQL. The most terrific thing about…

I have just had an unforgettable experience with DDL triggers and, as far as I see on Google search, I'm not alone. DDL triggers, as you know, fire stored procedure in a response to server or database DDL events, like metadata or…