Feeds:
Posts
Comments

Archive for October, 2009

SQL SERVER – Introduction to Business Intelligence – Important Terms & Definitions

Posted in Business Intelligence, Data Warehousing, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 21, 2009 | 6 Comments »

What is Business Intelligence Business intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data from various data sources, thus providing enterprise users with reliable and timely information and analysis for improved decision making. To put it simply, BI is an umbrella term that refers [...]

Read Full Post »

SQLAuthority News – PASS 2009 Sessions on Query Optimization and Performance Tuning

Posted in Best Practices, Database, MVP, PASS, SQL, SQL Authority, SQL Optimization, SQL PASS, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on October 20, 2009 | 4 Comments »

PASS Summit 2009 is now only 10 days away and I am very excited for the same. I can not wait to attend the summit as this is the most awaited conference of SQL Server in world. Everybody will be there and there will be something for everybody. My core expertise is in Query Optimization [...]

Read Full Post »

SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extention Script

Posted in Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology, tagged on October 19, 2009 | 15 Comments »

This document is created by Brian Cidern, he has written this excellent extension to SQL Expert who SQL SERVER – Change Collation of Database Column – T-SQL Script. His scripts are not only extremely helpful to achieve the task of consolidating collations in quick script. His script not only works perfectly but excellent piece of [...]

Read Full Post »

SQLAuthority News – Whitepaper – Auditing in SQL Server 2008

Posted in SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology on October 18, 2009 | 1 Comment »

Auditing in SQL Server 2008 SQL Server Technical Article Writer: Il-Sung Lee, Art Rask Technical Reviewer: Jack Richins, Rick Byham, Sameer Tejani, Al Comeau, JC Cannon Published: February 2009 With SQL Server Audit, SQL Server 2008 introduces an important new feature that provides a true auditing solution for enterprise customers. While SQL Trace can be [...]

Read Full Post »

SQLAuthority News – Happy Diwali and New Year

Posted in About Me, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on October 17, 2009 | 4 Comments »

I wish all of you Happy Diwali and New Year. Dīwali is a significant festival an official holiday in India. While Divali is popularly known as the “festival of lights”, the most significant spiritual meaning is “the awareness of the inner light”. Database tip of the day : Test your backup strategy. Yesterday night I [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers