Browse by Tags

Tagged Content List

Blog Post: How do I map a differential/transaction log backup to its full backup without using MSDB?

SQL Server Support Content

If you have multiple full, differential and transaction log backups, there are chances you may end up facing the error below during the restore process. “ This differential backup cannot be restored because the database has not been restored to the correct ...read more

on22 May 2013
Blog Post: Change Data Capture gets disabled when you break mirroring and bring the database online

SQL Server Support Content

Issue ================ Recently we encountered an issue where customer performed a planned failover for a mirrored database and after the failover the new principal went into suspect mode because of some reason (which is outside the scope ...read more

on15 May 2013
Blog Post: Do NOT delete files from the Windows Installer folder

SQL Server Support Content

C:\windows\Installer is not a temporary folder and files in it should not be deleted. If you do it on machines on which you have SQL Server installed you may have to rebuild the operating system and reinstall SQL Server. The Windows Installer Cache ...read more

on30 Apr 2013
Blog Post: How to monitor deadlock using extended events in SQL Server 2008 and later

SQL Server Support Content

Before I talk about how to monitor the deadlocks let us have a small brief what is deadlock and how we were handling them in the previous versions of SQL Server. Deadlock : A deadlock occurs when there is a cyclic dependency between two or more threads ...read more

on26 Apr 2013
Blog Post: Ventured into BULK INSERTS

SQL Server Support Content

Recently, whilst working with bulk insert queries I came across an unexpected result set which led to some more research. Therefore, following facts/tips/tricks/workarounds might help you: If you execute the following code for example: NOTE ...read more

on13 Mar 2013
Blog Post: How to Login to SQL Server with NT AUTHORITY\SYSTEM using PSExec Tool

SQL Server Support Content

PSExec tool gives you an option to run a remote process or an application using System account, if SYSTEM account has permission on that application. Although there are many more features that are For example, if SQL Server has NT AUTHORITY\SYSTEM ...read more

on18 Dec 2012
Blog Post: How to limit connections to SQL Server until all databases are ONLINE!

SQL Server Support Content

Strange requirement, right? Recently, I got a peculiar case wherein the demand made by the customer was to make sure no application should be able to connect to SQL Server unless and until all the databases are ONLINE. The business requirement of this ...read more

on18 Dec 2012

SQL Server KBs and Blogs

Browse by Tags

Blog Post: How do I map a differential/transaction log backup to its full backup without using MSDB?

Blog Post: Change Data Capture gets disabled when you break mirroring and bring the database online

Blog Post: Do NOT delete files from the Windows Installer folder

Blog Post: How to monitor deadlock using extended events in SQL Server 2008 and later

Blog Post: Ventured into BULK INSERTS

Blog Post: How to Login to SQL Server with NT AUTHORITY\SYSTEM using PSExec Tool

Blog Post: How to limit connections to SQL Server until all databases are ONLINE!

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support by product

Other support links

Not an IT pro?