(Darko Sancanin and Nicholas Dritsas) There are currently over 50 million files (over 10 Terabytes of data) that the customer is migrating into a custom project management application (for international customers) that can be accessed via the application and can be searched upon. SQL Server 2008 fu

(Ashish Kumar Mehta) The SQL Server Agent Error Log is a great place to find information about what is happening in your SQL Server Agent. Each SQL Server Agent Error log will record informational, warnings and different error messages which have occurred since SQL Server Agent was last restarted or

(Deanna Dicken) SQL Server impersonation, or context switching, is a means to allow the executing user to assume the permissions of a given user or login until the context is set back, set to yet another user, or the session is ended. Deanna Dicken shows you two mechanisms for accomplishing this tas

(Chris Skorlinski) This is a continuation of “Repl Talk” series on troubleshooting Transactional Replication. This posting walks through the LogReader as it moves transactions from the published database transaction log to the Distribution database. The walkthrough can be done on a single Microsoft

(Simon Sabin) I’ve just posted about filtering with joins is difficult to optimize (http://sqlblogcasts.com/blogs/simons/archive/2010/02/16/Filtering-by-joining-is-difficult-to-optimise.aspx). This post is along the same lines and is about the opposite, when joins don’t filter as expected but rather

(Ashish Kumar Mehta) SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using Analysis Services Processing Task & Analysis Services Execute DDL

(Tim Ford) This is an opportunity for me to geek out on my favorite topic in Microsoft SQL Server: mining SQL Server metadata. If you’ve read my tips over the past two years you may have seen that I am a metadata junkie. This was developed from a need to automate as many tasks as possible over the

(Muthusamy Anantha Kumar) Learn how to create a database level audit at a granular level and retrieve the audit records in this 9-step tutorial.

(Chris Skorlinski) I’m posting a collection of SQL Server 2008 Merge Replication Best Practices. The material below includes text from SQL Books Online, other white papers, KB articles, web postings, and little from experience I gained working with SQL Replication for almost 15 years. The “best pr

(Mike Chapple) SQL Server’s Declarative Management Framework (DMF) allows you to proactively regulate the configuration and operation of your SQL Server databases. You may declare security and best practice policies and then apply them to your database server.