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...

Recently we worked on a support case where creation of a Subscription was failing with the following error:- TITLE: New Subscription Wizard ------------------------------ SQL Server could not create a subscription for Subscriber 'Servername\InstanceName...

Hello Everyone, In this presentation, you will learn about what are DDL triggers and how they could help you in day to day DBA activities. Presented by: Niraj Mehta

Recently, there was a question that why the SQL Server DMVs were reflecting incorrect information with respect to the size of the indexes, files and filegroups. The following data supported the question: SELECT TOP 50 OBJECT_NAME(p.object_id) AS table_name...

Introduction : In this blog we will see how to add a stopword in a stoplist and also look at one of the common scenario which DBA face when they upgrade from SQL 2000\2005 to 2008 keeping compatibility level 80. So to introduce the topic lets know few...

Problem Description: Indexes gets fragmented soon after rebuilding index Detailed description You have a table with  index created on it.  Logical Fragmentation for the index comes to 99 %. You did re-indexing of the index with Rebuild option...

Let’s say you have an environment which implements DNS forwarding. In such a setup, the client uses a different name (or FQDN) while connecting to SQL Server than the actual SQL Server name (or FQDN). The connection request is forwarded to actual SQL...

Recently, I worked on a case with one of my clients wherein SQL Server was encountering several deadlocks when they were running Stress Tests from application. They had tried several techniques to resolve this issue including forcing an index on the query...

SCENARIO: 1)You have an MDF file from a database which has grown up to a size that has almost exhausted the disk space. 2)You now want to keep the MDF from growing further. 3)You also want to transfer the data from the MDF file to the NDF file...

There currently isn’t a way in T-SQL to convert UTC Time to Local time; however this seems to be a common issue people are facing. Here is how we could resolve this by writing a simple C# code and deploying it to SQL. This can easily be achieved...

In this presentation you learn about: 1. How to install performance dashboard 2. How to use performance dashboard 3. Demos of performance dashboard usage in bad performance scenarios For better quality please check the link:- http://channel9...

In this presentation, you will learn about the complete description of the SQL audits , their benefits along with brief demos. For watching the video in better quality please check the link: - http://channel9.msdn.com/posts/What-are-SQL-server-audits...

In this presentation, you will learn about what are the plan guides and how they could help the DBAs to manage the performance of the queries when change in the application is not feasible To see the video in better quality please click on the link...

In this presentation, you will learn about how you could manage SQL resources using resource governer. To view the video in better quality please click on the link: - http://channel9.msdn.com/posts/Managin-SQL-resources-using-resource-governer ...

In this video we will see whats the backup compression in SQL server 2008 and how it can help to optimize the speed/size of the backup To see the video in better quality, please check the link :- http://channel9.msdn.com/posts/Backup-Compression-in...

Symptoms: You might see a couple of components from the “ shared features” failing with the error messages as mentioned below when you are trying to install SQL 2008 R2.   Troubleshooting this Issue ======================= As an end result you will...

In this presentation you will learn : 1. Very basics of transaction logs internal structure i.e. VLFs. 2. Best practices for the log files. 3. Impacts of too many VLFs To see the video in better quality or download please click on the link...

In this presentation , you will learn about what are implicit conversions. What can be their implications in the SQL query executions. To see the video in better quality or download please click on the link: - http://channel9.msdn.com/posts/Implicit...

Recently we came across a situation where one of the customer was trying to restore a Database backup using SSMS and while going to Options tab UI failed with the error:   "Length cannot be less than zero. Parameter name: length"  ...