All Articles - SQL Authority with Pinal Dave

SQL Authority News – Advanced T-SQL with Itzik Ben-Gan – Solid Quality Mentors

November 1, 2009

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

MVP, SQL Training, SQLAuthority Author Visit

As mentioned earlier in a blog post SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True, I got the wonderful opportunity to attend the course of Itzik Ben-Gan. Itzik is one of the true masters of SQL Server, and his fame had set my expectations quite high.…

SQLAuthority News – New PASS President Rushabh Mehta

October 31, 2009

Pinal Dave

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

MVP, SQL PASS, SQL Server, SQL User Group

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…

SQLAuthority News – India Market and Third Party SQL Server Tools

October 30, 2009

Pinal Dave

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

SQLAuthority Author Visit

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…

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

October 29, 2009

Pinal Dave

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

MVP, SQL PASS, SQL User Group, SQLAuthority Author Visit

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…

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

October 28, 2009

Pinal Dave

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

SQL White Papers

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…

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

October 27, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

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…

SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True

October 26, 2009

Pinal Dave

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

SQLAuthority Author Visit

As from my blog posts, all of you are probably aware that I am very much excited for attending SQL PASS at Seattle from Nov 1, 2009. As the days to the summit were nearing, I could already feel the rush of adrenalin in my veins. May be because of…

SQLAuthority News – Best Practices for Integration Services Configurations

October 25, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, SQL White Papers, SSIS

Best Practices for Integration Services Configurations by Jamie Thomson This article explains what SQL Server Integration Services configurations are used for, why you should use Integration Services configurations, and what options you have for leveraging configurations. It will also make some simple recommendations that are based on my experiences of…

SQL SERVER – Link to SQL Server Book Online – BOL

October 24, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Do you keep following Book Online Links handy? I do and I use them a lot. SQL Server 2008 R2 SQL Server 2008 SQL Server 2005 SQL Server 2000 I do and I use them a lot. Reference: Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – PASS Sessions – I will be there!

October 23, 2009

Pinal Dave

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

Business Intelligence, MVP, SQL PASS, SQLAuthority Author Visit

As PASS is now one week away and I am all excited for the same. I am going to attend following two sessions for sure. I encourage all of you to also visit the same sessions. We can all talk about SQL , SQL Integration as well Beyond Relations. First…