Split personality text editing in SSMS with Sublime Text 3

Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power...

Split personality text editing in SSMS with Sublime Text 3

Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power...

SQL Server – Methods to find running totals of a column

HI friends, in some working scenario or during interviews we got the task to find the running totals of a...

SQL Server’s statistics

Again another interesting article from RED GATE …
SQL Server’s statistics provide the query optimizer with the information it needs to...

Watch the Power Pivot 101 Webinar Recording

Thank you to everyone that attended my webinar titled Power Pivot 101: An Introduction! Also, thank you to Thomas Leblanc...

Webinar – SSIS Best Practices and Tuning Tips

I’ll be giving an SSIS webinar for MSSQLTips.com on Tuesday 15th September 2015.

The title is SQL Server Integration Services Best...

Webinar: Change Tracking for Data Warehouse Loads

For data warehouse professionals, change detection is critical. Accurately detecting new, changed, and deleted records means the difference between doing...

What SQL Server components are installed on this machine?

Figuring out what components of SQL Server are installed on a particular machine has always been a task that has...

Houston TechFest Presentation Downloads

Thanks for joining me at Houston TechFest 2015 at the NRG Center in Houston, TX! Big congrats to Michael and...

Step by Step SSIS learning What Data Conversion use in SSIS ? TIP#116

Dear Friends,
In the series of step by step learning of SSIS this is part #6 in which we are going...