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

By default, merge replication processes data changes on a row-by-row basis. In many circumstances this is appropriate, but for some applications, it is essential that related rows be processed as a unit. The logical records feature of merge replication...

Many of you SQL folks out there have extended stored procedures installed and being used in your SQL Server. Most often this is installed by some 3 rd party applications like backup applications or linked server providers. There are times when some custom...

This is one of those challenging situations when customers call us at times. I can understand the gravity of the situation – your boss is behind your back, your business is down, your application is down, your website cannot accept orders or your phone...

Consider a scenario wherein you are doing some operation which is generating an error with Level\Severity 16 and is causing the entire transaction to fail with the following message: Msg 3998, Level 16, State 1, Line 1 Uncommittable transaction is detected...

On 4th May 2011 (Day 3), Amit Banerjee presented webcast on “ Understanding Performance Bottlenecks using Performance Dashboard ”. In this session Amit demonstrated how to troubleshoot a SQL Server performance issue using out-of-the-box features without...

On 3rd May 2011 (Day 2), Sudarshan presented webcast on “Optimizing and Tuning Full Text Search for SQL Server”. This session covered all the key aspect of Full Text Search which is responsible for the scalable and secure but optimized full text search...

On 2nd May 2011 (Day 1), I presented webcast on “Managing and Optimizing Resources for SQL Server”. This was a basic session to show capabilities of resource governor feature in SQL 2008. We have been asked about the slides, video and demo by participants...

In this presentation you will learn about what's service broker and it's basic troubleshooting steps: Presented By: Vijay Rodrigues, Support enginner, Microsoft GTSC

In this presentation, you will learn about how to configure and monitor logshipping. Presented by: Anmol Bhasin To download this video, please click on link

But really SQLDIAG I do, and I am not lying!! I have helped multiple users of SQLDIAG (not SQL Nexus) trace down the root cause of this issue. SQLDIAG is a tool that is used to collect data which can be imported into a SQL Server database with the help...

We encountered an interesting issue some time back. We already had XML data inserted into a SQL Server 2008 R2 database however we were getting below error when retrieving (also called shredding) values from the XML data. Msg 8621, Level 17,...

In this presentation you will learn about working of Declarative Management Framework with demo. Presented By: Bryan Von Axelson

In this video we are going to present a brief demo of how CDC works and it's functionality. Presented By: Bryan Von Axelson

In this video, you will learn about how to extended events are configured and how they work: Presented By: Bryan Von Axelson

In this video you will learn about how to configure SQL 2008 Cluster using hyper-v on windows 2008. To watch the video in high quality please check the link :- http://channel9.msdn.com/posts/SQL-2008-Clustering-using-Hyper-V Presented By : -...

Symptoms When you try to take a SQL Server database backup to a UNC path ( \\server\folder\ ), you get this error,   Msg 3201, Level 16, State 1, Line 1   Cannot open backup device '\\server\folder\db.bak'. Operating system error 1(Incorrect...

I have answered multiple queries last year regarding the tools SQL Nexus and RML Utilities via MSDN forums, Twitter and Codeplex last year. I thought now might be a good idea to collate the top issues that I answered and make a blog post on the same....