Feeds:
Posts
Comments

Archive for October, 2009

SQLAuthority News – New PASS President Rushabh Mehta

Posted in MVP, PASS, Pinal Dave, SQL, SQL Authority, SQL PASS, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority News, SQLServer, T SQL, Technology on October 31, 2009 | 13 Comments »

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (Virtual Chapters) to webcasts and the annual PASS Community Summit – the largest gathering of SQL Server professionals in the world – PASS is [...]

Read Full Post »

SQLAuthority News – India Market and Third Party SQL Server Tools

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on October 30, 2009 | 18 Comments »

Last week, I had wonderful time attending meeting of small ISV (Independent Software Vendors). Several topics were discussed, but the one topic that caught my attention was the adoption of the third party SQL Server tools. There were around 100+ top level managers who take decision regarding what resources are needed for projects. I had [...]

Read Full Post »

SQLAuthority News – Birds-of-a-Feather (BOF) Lunch – SQL PASS Summit, Seattle, 2009

Posted in MVP, PASS, Pinal Dave, SQL, SQL Authority, SQL PASS, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on October 29, 2009 | 1 Comment »

I received few emails regarding where can people meet me at SQL PASS event in Seattle. I am currently in Bellevue attending Itzik Ben-Gan’s class. I am immensely enjoying the class, and I shall post details about the class once it is over. If you are attending SQL PASS and interested to meet me, I [...]

Read Full Post »

SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008

Posted in SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, SQLServer, T SQL, Technology on October 28, 2009 | 2 Comments »

Change data capture (CDC) is a new feature in SQL Server 2008 designed to capture insert, update, merge, and delete activities applied to SQL Server tables and to avail those changes in an easy-to-understand format. Conventionally, detecting changes in a source database to transfer these changes to a data warehouse required any of the following: [...]

Read Full Post »

SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 27, 2009 | 8 Comments »

Many times I have seen that the index is disabled when there is large update operation on the table. Bulk insert of very large file updates in any table using SSIS is usually preceded by disabling the index and followed by enabling the index. I have seen many developers running the following query to disable [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers