Best Practices Archives - Page 7 of 24 - SQL Authority with Pinal Dave

SQL SERVER – 4 Tips for ETL Software IDE Developers

January 18, 2011

In a previous blog, I introduced the notion of Semantic Types. To an end-user, a seamlessly integrated semantic typing engine significantly increases the ease of use of an ETL IDE (integrated development environment, or developer studio). This led me to think about other ease-of-use issues I have encountered while building ETL…

SQLAuthority News – Best Practices for Data Warehousing with SQL Server 2008 R2

January 15, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Data Warehousing, SQL Documentation, SQL Download

An integral part of any BI system is the data warehouse—a central repository of data that is regularly refreshed from the source systems. The new data is transferred at regular intervals by extract, transform, and load (ETL) processes. This whitepaper talks about what are best practices for Data Warehousing. This…

SQL SERVER – Securing TRUNCATE Permissions in SQL Server

December 20, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Scripts, SQL Server Security

Download the Script of this article from here. On December 11, 2010, Vinod Kumar, a Databases & BI technology evangelist from Microsoft Corporation, graced Ahmedabad by spending some time with the Community during the Community Tech Days (CTD) event. As he was running through a few demos, Vinod asked the…

SQL SERVER – What the Business Says Is Not What the Business Wants

December 14, 2010

Pinal Dave

SQL Tips and Tricks

Best Practices, Shrinking Database

Let us discuss about What the Business Says Is Not What the Business Wants. Steve raised a very interesting question.

SQL SERVER – Activity Monitor and Performance Issue

December 12, 2010

Pinal Dave

SQL

Best Practices, SQL Server, SQL Utility

We had a wonderful SQLAuthority News – Community Tech Days – December 11, 2010 event yesterday. During this event SQL Expert Jacob shared a very interesting story related to activity monitor.

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore

November 7, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Best Practices, SharePoint, SQLAuthority Author Visit

Every SharePoint site runs on SQL Server and most of the SharePoint sites face issues with performance due to suboptimal configuration of underlying SQL Server. Recently, I presented a session on SharePoint and SQL Server Performance at Singapore on Oct 26-27, 2010. It was South East Asia SharePoint Conference, and…

SQL SERVER – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage

October 27, 2010

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Best Practices, Database, SQL Scripts, SQL TempDB

Recently, there have been a lot of interesting concepts in various challenges. My friend Jacob Sebastian is running the SQLQuiz for the entire month, and it has been very popular and going just great. So here I thought I would put something very similar to the quiz bee. The award…