Cluster failover fails
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
You may get an error on log reader agent failed with following error: Cannot execute as the database principal because...
2013-10-16
838 reads
SQL Server 2014 CTP2 Available to Download
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
19 reads
PASS Summit Report #4
One of the items that came up for discussion at the Chapter meeting today was the privacy policy for SQLSaturday....
2013-10-15
304 reads
PASS Summit Report #3
Started today with breakfast with the family after packing up all their clothes and stuffed animals for the trip home....
2013-10-15
424 reads
PASS Summit Report #2
Weather a bit cloudy today, a little rain and a little cool – not Seattle, but not Orlando either! Breakfast at...
2013-10-15
454 reads
SQL Server Diagnostic Information Queries for October 2013
I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this...
2013-10-15
1,325 reads
DMV-15 : Pending I/O requests……..sys.dm_io_pending_io_requests
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,393 reads
Attending the SQL PASS Summit?
Are you attending the SQL PASS Summit conference in Charlotte, NC this week? If so, let’s meet up! If not,...
2013-10-15
908 reads
SQL Server Performance Root Cause Analysis in 10 Minutes
This year I was honored to be selected by Dell Software to present a ten minute session in their booth...
2013-10-15
1,111 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers