Microsoft SQL Server Tips & Tricks
Tips and Tricks for the SQL Server Enthusiast
In this post, we would like to explain one of the interesting issues that we encountered while...
Date: 01/22/2017
In this post, we would like to explain one of the interesting issues that we encountered while using...
Date: 01/22/2017
In this post we would like to explain one of the interesting issue that we encountered while...
Date: 10/12/2016
It is one of the pre-requisites for the KEY-SPEC value of the SSL self-signed certificate to be set...
Date: 10/04/2016
A few days back, I was working with one of our partners who had a requirement of creating a SSL...
Date: 09/26/2016
SQL Server Service fails to start after applying patch. Error: CREATE SCHEMA failed due to previous errors.
In this post we would like to explain one of the interesting issues that we encountered while...
Date: 07/14/2016
There have been several posts on setting up Service Broker where the database is part of the...
Date: 07/29/2015
Error configuring distribution- "Publishing and distribution are supported only in SQL Server version 7.0 or later"
I recently installed an instance of SQL Server 2016 on one of my server. Later when I tried to...
Date: 07/28/2015
In one of the recent scenarios we noticed that a user database was deleted and customer wanted to...
Date: 05/17/2015
Snapshot agent fails with Error: 241, Severity: 16, State: 1 (Conversion failed when converting date and/or time from character string)
ISSUE Let’s say you are monitoring Replication Agent status and noticed that the Snapshot Agent has...
Date: 02/09/2015
We have MSDN article [Tutorial: Listener Configuration for AlwaysOn Availability Groups...
Date: 12/22/2014
Capture successful logins: You may see many entries(high volume) when you create Audit for SUCCESSFUL_LOGIN_GROUP action group
When you are auditing successful logins attempts using SUCCESSFUL_LOGIN_GROUP action group...
Date: 12/07/2014
In this post I would like to explain one of the interesting issues that I encountered while...
Date: 11/27/2014
Merge Replication: Expired Subscription Clean Up Job / sp_expired_subscription_cleanup / sp_MScleanup_conflict fails with error Msg 1934, Level 16, State 1 AND Msg 20709, Level 16, State 1, Procedure sp_MScleanup_conflict…??
Issue: If you have a Merge Replication, you may encounter the below error message thrown by...
Date: 11/13/2014
SQL Server Data Tools (a.k.a. SSDT) used to part of product installation media in SQL Server 2012....
Date: 08/28/2014
Troubleshooting : Error: 8624, Severity: 16, State: 21. Internal Query Processor Error: The query processor could not produce a query plan.
Sometimes we see the below error in SQL Server 2008 R2 SP1 when executing a query in SQL Server...
Date: 07/15/2014
Can I decrypt TDE enabled database if I have access to the master database’s mdf and ldf files or the master database backup?
If someone gets access to the master database, i.e., if s/he can manage to copy the MDF, LDF...
Date: 05/16/2014
How to move databases configured for SQL Server AlwaysOn This article describes how to change the...
Date: 02/06/2014
Creating Availability group for an Encrypted database: In this blog we will walk you through...
Date: 11/22/2013
In this blog I would like to demonstrate a scenario where users want to move the changes between the...
Date: 11/21/2013
I was working on a 2005 to 2012 upgrade issue and came across an interesting issue which I thought...
Date: 07/24/2013
If you have multiple full, differential and transaction log backups, there are chances you may end...
Date: 05/22/2013
Issue ================ Recently we encountered an issue where customer performed a...
Date: 05/15/2013
C:\windows\Installer is not a temporary folder and files in it should not be deleted. If you do it...
Date: 04/30/2013
Before I talk about how to monitor the deadlocks let us have a small brief what is deadlock and how...
Date: 04/26/2013
Recently, whilst working with bulk insert queries I came across an unexpected result set which led...
Date: 03/13/2013
PSExec tool gives you an option to run a remote process or an application using System account, if...
Date: 12/18/2012
Strange requirement, right? Recently, I got a peculiar case wherein the demand made by the customer...
Date: 12/18/2012
Here we will discuss on Waits in the context of SQL Server: Highlights of this video blog :- 1. What...
Date: 06/18/2012
Filestream is a new feature in SQL server 2008, that allows storage and efficient access to BLOB...
Date: 06/18/2012
In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and...
Date: 06/11/2012
In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and...
Date: 06/11/2012
A new feature introduced in SQL Server 2012 setup is "Product Update". Product Update searches for...
Date: 06/11/2012
In this video blog we would walk you through a feature introduced from SQL server 2008 i.e. Sparse...
Date: 06/11/2012
Here we will Discuss on Providing High Availability for SQL Server Transactional Replictaion using...
Date: 06/07/2012
In this video blog, we would walk you through some tips and methods to troubleshoot Missing...
Date: 05/08/2012
Bulk insert command is not inserting correct characters from a flat file into the table. For...
Date: 04/05/2012
During our recent interactions with a few customers, we were asked following questions about TLS...
Date: 04/04/2012
Issue: Installation of SQL Server 2008 might fails with below error on 64-Bit Operating system. MSI...
Date: 04/04/2012
Queries on SQL Server Replication? Check out our blog to get'em answered , that will give you an...
Date: 03/22/2012
INF: SQL Server Compressed backup may work fine if disk space is less and may fail if disk space is more
In this article We are going to discuss about pre-allocation scenarios and their aftermaths for SQL...
Date: 03/20/2012
I ran into a very interesting issue with temp tables recently, when working on a case. The issue...
Date: 03/15/2012
INF: AlwaysOn – The secondary database doesn't come automatically when the primary instance of SQL Server goes down
In this blog we would discuss about behavior of AlwaysOn availability group where the secondary...
Date: 03/15/2012
Recently I have had a customer complaining that when he is adding more subscriptions to his...
Date: 03/14/2012
Highlights of this video blog :- 1. What are Partitioned tables & benefits2. Building Blocks of...
Date: 02/27/2012
Highlights of this video blog :- 1. What is SSL Encryption2. Why is it needed3. Configuring SSL...
Date: 02/22/2012
Highlights of this video blog :- 1. What is Data collector2. Architecture3. MDW(Management data...
Date: 02/22/2012
We recently worked on an issue where modifying a Table from the GUI was not allowed even though the...
Date: 02/09/2012
Check our video blog, and get answers to your queries related to "Policy Based Management" in SQL...
Date: 01/18/2012
For SQL Server 2008/2008 R2 installed on Win 7/Windows Server 2008, if we attempt to open .sql files...
Date: 01/11/2012