DBA Morning Check List
This article helps the DBA find and fix issues quickly by creating a DBA Morning Checklist.
2010-08-27 (first published: 2008-04-14)
55,812 reads
Bill Richards
Database Server Upgrades – The Plan, The Template, and The Task List
This article enables DBAs to efficiently upgrade servers by assembling an upgrade team, using an upgrade template, and communicating effectively.
2009-05-08
8,336 reads
Linked Server Optimization
This article demonstrates the negative affect that linked servers can cause in queries and offers alternatives to speed up performance.
2008-03-07
14,615 reads
Blogs
Azure Data Studeo- Nov 2019 Release
By Vinay Thakur
SQL Server Management studio is now can be installed separately not part of SQL...
Azure Synapse Analytics new features
By James-Serra
Almost lost in all the announcements from Ignite was a bunch of amazing new...
Docker, Git and DBATools
For those who don’t know, last week was the PASS Summit. It’s an amazing...
Forums
SQL'De Yedek alirken %90 da hata veriyor ve mdf dosyasi erisilemez diyor
Hi Friends, I'm using SQL 2014, Everything works fine I gave the following error...
Basic Avaialbility setup but replicas went to resolving mode
Hi, I configured the Basic Alwayson setup in two of the test SQL standard...
I am looking to optimize this T-SQL Statement (it generates very High Reads..)
In the below SQL statement (also attached as DOC file) it has been...
Ask SSC