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…

Here is a great movie which was made for Israel Users Group 100 anniversary. All singers are SQl Server DBAs :-)https://vimeo.com/14748423Enjoy!

This movie was made for Conduit 5 years event: http://www.youtube.com/watch?v=1M_GNUUvQfE.

If you ever tried to set up replication on the large environment with numerous servers, hundreds of databases then you, for sure, spend some time searching/writing scripts to set flag NOT FOR REPLICATION on thousands of identities,…

Did you know, that when you use READ UNCOMMITTED isolation level or WITH (NOLOCK) hint inside the query, it is still places Sch-S (schema stability) locks during compilation and execution and can be blocked by any concurrent trancastion…

Are you familiar with Trace Replay feature SQL Profiler? It's not really popular but actually can do a lot for you.Replay is the ability to save a trace and replay it later. This functionality lets you reproduce activity captured in a…

If you ever wondedered what king of locks your selct query ever issues and for how long, run it in QA environment with isolation level Repeatable Read, which holds all locks you select issues till the end of transaction. Default isolation…

Q: Why do you never ask SQL people to help you move your furniture?A: They sometimes drop the table--------------------------------------A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join…