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

Symptoms When you open SQL Server profiler, and try to start a new  trace (or when try to open an existing trace ), you get the error " Unable to read trace definition file Microsoft SQL Server TraceDefinition 9.0.1187.xml. Click OK to retreive...

Scenario Consider a scenario where you have a Log shipping setup with a STANDY secondary database and things are working just fine. One fine day you notice that the secondary database is not in sync with the primary. The seasoned DBA that you are, you...

It's has been couple of years for me working on SQL Server and I keep coming across various SQL Server misconceptions (or say a DBA Myth). In this specific post I’ll demystify a common DBA myth around log-shipping: " In a log shipping setup, to have...

The RTM version of Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download, and includes SQL Server 2005 SP3 cumulative updates 1 to 11, customer requested fixes and the SQL Server 2005 SP4 database engine support for DAC operations...

As you might be aware that SQL Server Code-Named “Denali” has introduced a new feature called Always ON for enhancing the availability of user database in a enterprise environment. In simple terms, AlwaysON is a high-availability and disaster recovery...

For additional details check the link below: http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/09/29/end-of-support-for-sql-server-7-0.aspx?wa=wsignin1.0 Regards, SQLServerFAQ

The SQL Server Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server recommendations and best practices to determine if there are potential issues in the database...

Issue When we try to connect to a SQL instance from SQL server Management studio we get the following error : Error executing extended stored procedure: Invalid Parameter Error executing extended stored procedure: Invalid Parameter (Microsoft...