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

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