Need Recommendations on Being a Better Listener

This past weekend I’ve been reading The Zen of Listening by Rebecca Shafir, part of my ongoing efforts to be...

CDC changes column-by-column instead of row-by-row, can you improve it???

CDC changes column-by-column instead of row-by-row, can you improve it???.

Using a system function as a computed column within a table-value function….

Wouldn’t it be nice if SQL Server allowed this functionality? for instance if did the below:-

I get the above error....

Execute SSIS Packages with a Macro in BIDS

When running SSIS packages in BIDS it is common to click on the green arrow at the top of BIDS...

sp_SrvPermissions

Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it...

CDC changes column-by-column instead of row-by-row, can you improve it???

I’m writing a table value function that returns a cdc recordset that, instead of returning changed data row-by-row, I need...

Fixing Page Life Expectancy (PLE)

What is Page Life Expectancy (PLE), what makes it drop, and how can I manage memory better? Abusing disks slows...

Why the MS Power Query (PQ) for Excel is an invaluable Business Intelligence tool

Dear reader, I would like to share with you some of the capabilities that the Power Query for Excel brings...

Introducing Python in Hadoop World

This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data and Hadoop environment. To discover more about Python please...

Reblog: August 9 to August 15

This reblog post should have come out last Friday, but I was on vacation and I didn’t want any new...