In this video blog, we would walk you through some tips and methods to troubleshoot Missing MSI's/MSP's error during SQL Server Patching or installation. Highlights of this video blog :- 1. What are MSI's/MSP's 2. Location of Setup logs and log...

Bulk insert command is not inserting correct characters from a flat file into the table. For instance, the character “Ñ” is displayed as “+æ“ after getting imported in the table. In other words the characters from...

During our recent interactions with a few customers, we were asked following questions about TLS certificates with SQL server: 1. Can TLS certificate be used with SQL Server 2008 for server-side encryption? 2. If Yes, How? To start with, let’s...

Issue: Installation of SQL Server 2008 might fails with below error on 64-Bit Operating system. MSI Error: 1719 The Windows Installer Service could not be accessed. This can occur if you are running Windows in safe mode, or if Windows Installer...

Queries on SQL Server Replication? Check out our blog to get'em answered , that will give you an overview of the “Replication in SQL server”. Highlights of the blog:- What is replication? Why we should use Replication? What is replication...

In this article We are going to discuss about pre-allocation scenarios and their aftermaths for SQL Server 2008 compressed backup. We will try to simulate that compressed backup may succeed if disk space is less and may fail if disk space is more depending...

I ran into a very interesting issue with temp tables recently, when working on a case. The issue description goes something like this. We have an application preparing some SQL statements, and sending them to the SQL Database engine for execution. However...

In this blog we would discuss about behavior of AlwaysON where the secondary database doesn't come automatically when the primary instance goes down. The secondary database goes into Resolving state. On the failover cluster manager the resource appears...

Recently I have had a customer complaining that when he is adding more subscriptions to his publication, distribution agent job for the newly added subscriptions would not start.  And when he tried to start the distribution agent job manually, it...

Highlights of this video blog :- 1. What are Partitioned tables & benefits 2. Building Blocks of Partitioning 3. Partitioned Table Operations 4. Demo 5. Best Practices To watch the video in better quality please check the link: - http://channel9...

Highlights of this video blog :- 1. What is SSL Encryption 2. Why is it needed 3. Configuring SSL Encryption for SQL Server 4. Demo To watch the video in better quality, please check the link: - http://channel9.msdn.com/posts/SSL-Encryption-for...

Highlights of this video blog :- 1. What is Data collector 2. Architecture 3. MDW(Management data warehouse) setup 4. System Data Collection Presented By: - Manish Upadhyay,SE,Microsoft GTSC Reviewed By: - Karthick Krishnamurthy,TL,Microsoft GTSC

We recently worked on an issue where modifying a Table from the GUI was not allowed even though the account had read – write permissions.  So, we are sharing our findings below: Let’s say you have a SQL account ‘ Account_1’ with following Database...

Check our video blog, and get answers to your queries related to "Policy Based Management" in SQL server. This feature is helpful to ensure compliance at SQL server end. This blog will cover: What is Policy Based Management? What is facets? How we can...

For SQL Server 2008/2008 R2 installed on Win 7/Windows Server 2008, if we attempt to open .sql files with SSMS closed, the file does not open up in Management studio. The SSMS windows will just open (as below) but the file will not be displayed. If the...

ANALYSIS :- In this case when we captured PSSDiag and noticed huge recompiles due to AutoStat updates, here’s a snippet of what we noticed in SQL Server 2005 Vs SQL Server 2008 on the same machine. SQL 2008 ========= EventID Occurrences Description...

Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing your application and SQL server performance. Procedure Cache , main goal is to cache the query plans and allow its reuse and thus minimize the compile...

Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing your application and SQL server performance. Procedure Cache , main goal is to cache the query plans and allow its reuse and thus minimize the compile...

Gain an expertise in solving the "Kerberos Delegation" issues using one of the useful troubleshooting tool for Kerberos i.e. DelegConfig. Refer to our video blog, that will provide you a step by step guidelines as to how to use this tool in resolving...

Check out our video blog to gain in depth knowledge about importance of "Execution Log" in reporting services. In this blog you will get to know more about the following :- What is execution log? Where to check for execution log? Information...

Leverage our video blog to empower your knowledge on TDE. Highlights of this video blog :- 1. Introduction to TDE 2. How to implement TDE. 3. Advantages of TDE 4. Changing DEK 5. Removing Encrypted database 6. Migrating the encrypted database ...

Leverage our video blog to empower your knowledge on "SQL Memory".This video will help you to gain in depth expertise to following topics :- 1. More about Process Address Space 2. SQL Server 32 bit Memory Architecture 3. AWE 4. Managing SQL Server...

Okay, so I woke up one morning and decided that this was a good day to patch my SQL Server 2008 R2 instance (named LPT2) to Service Pack 1. So I just downloaded the service pack from the Microsoft Website, ran it, went through the screens and clicked...

In this video presentation you will learn in depth about Multiserver administration For better quality/download please check the link: - http://channel9.msdn.com/posts/Multi-server-Administration Presented by: Phani Raj,SE,Microsoft GTSC ...

Consider this scenario, I rebooted several times, disabling my favourite antivirus and still unable to get a clue from all the logs possible. I start looking at my favourite blogs and here I am. Check out if your symptoms match the following. “ I am installing...