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 ;)
I'm moving !!!!!
Replication frustration: Adding article does not create the table on subscriber
R
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…
DBCC LOGINFO on SQL 2005 causes “non-yielding processes on scheduler” errors and server timeouts
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…
Easy load testing using Management Studio
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…
PASS 2011 summit excitement
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…
DDL Triggers and SET options
D
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…
"Select Star" - Israel DBAs singing for SQL Server UsersGroup meeting 100
"
Here is a great movie which was made for Israel Users Group 100 anniversary. All singers are SQl Server DBAs :-)https://vimeo.com/14748423Enjoy!
I play in Conduit promo movie :-)
I
This movie was made for Conduit 5 years event: http://www.youtube.com/watch?v=1M_GNUUvQfE.
Replication fun: setting NFR on all objects
R
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,…
WITH (NOLOCK) still places locks !
W
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…