(Evan Basalik) I was assisting with a SQL Server performance issue the other day. The issue was transactional replication was unable to keep up while trying to replicate data from a transactional database to a reporting database. This was causing the customer to miss their data latency SLAs. The

(Dinesh Asanka) A default trace in SQL Server is a standard server side trace which is installed by default in SQL Server 2005 onwards.

(Deanna Dicken) XML is, it seems, everywhere. SQL Server has ever-improving functionality that helps us peek into, shred, store, manipulate and otherwise utilize XML. This article covers XML variables, XML columns, typed vs. untyped XML, and the xml data type methods.

(Joe Pitz) After publishing Linq to SQL Performance Considerations, many readers replied and asked me to extend the benchmarking examples to include Linq to SQL compiled queries.

(Ashish Kumar Mehta) Database Administrators are often asked questions like “are all the SQL Servers within an organization configured according to the industry standards?”. In this tip, you will see how a Database Administrator can quickly use Microsoft SQL Server 2005 Best Practices Analyzer to an

(Jason Thomas) In one of my projects, I was asked to implement a drillthrough report, which had a depth of around 6 pages. After the development, I was sitting with the user who was testing the reports and I noticed that the user was frequently shifting between the sixth and the third report to chan

As part of SharePoint 2010, we have created a set of features to help you collect, report, and analyze the usage and effectiveness of your SharePoint 2010 deployment. These set of features are a part of the Web Analytics capabilities of SharePoint 2010. The overview of the Web Analytics features in

(Chris Skorlinski) Below are cause and recommendation for the SQL Replication LogReader error “The specified LSN (…) for repldone log scan occurs before the current start of replication in the log (…).’.

(Buck Woody) When you’re working with Transact-SQL (T-SQL) code, you’re going to make mistakes. I know this might surprise some folks, but it’s just going to happen. It’s inevitable. There’s no way around that.

(Pinalkumar Dave) In recent SQL Training I was asked, how can one figure out what was the last SQL Statement executed in sessions.