you may get an error while trying to failover to another node cluster. to resolve this issue create an alias...

2013-10-16

894 reads

LogReader agent failed

by Vinay Thakur

Vinay Thakur

You may get an error on log reader agent failed with following error: Cannot execute as the database principal because...

2013-10-16

839 reads

SQL Server 2014 CTP2 Available to Download

by Richie Lee

Richie Lee's SQL Stuff

At the PASS Summit keynote today Quentin Clark announced that SQL Server CTP2 (which is public and the last public review) and is available right now to download here....

2013-10-16

20 reads

PASS Summit Report #4

by Andy Warren

SQLAndy

One of the items that came up for discussion at the Chapter meeting today was the privacy policy for SQLSaturday....

2013-10-15

306 reads

PASS Summit Report #3

by Andy Warren

SQLAndy

Started today with breakfast with the family after packing up all their clothes and stuffed animals for the trip home....

2013-10-15

427 reads

PASS Summit Report #2

by Andy Warren

SQLAndy

Weather a bit cloudy today, a little rain and a little cool – not Seattle, but not Orlando either! Breakfast at...

2013-10-15

455 reads

SQL Server Diagnostic Information Queries for October 2013

by Glenn Berry

Glenn Berry

I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this...

2013-10-15

1,326 reads

DMV-15 : Pending I/O requests……..sys.dm_io_pending_io_requests

by Rohit Garg

MSSQLFUN

sys.dm_io_pending_io_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188762.aspx
Returns a row for each pending I/O request in SQL...

2013-10-15

1,394 reads