How to write data from user-defined function

Writing data from within user-defined function is not permitted. You cannot use any INSERT/UPDATE/DELETE/MERGE statement because they’re “side-effecting” for SQL...

Answer to the Quiz

Hi Everybody,
Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course...

New Dell Precision M4600 Mobile Workstation

After a very long wait, I finally received my new company laptop this past week, which is a very fast...

Answer to the Quiz

Hi Everybody,
Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course...

Storage Checklist FAQ

In a new data centre build, storage system or new equipment, the DBA should have an input into the architecture...

Session Files for Replication Magic Presentation to WSSUG

Session Files for Replication Magic Presentation to WSSUG
Replication Magic

I presented my session on Replication Magic: Initializing from Backup to the...

Microsoft SQL Server Parallel Data Warehouse (PDW) Explained

Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server...

On the Road Again – SQL Saturday #90

I’m leaving this morning for Oklahoma City for SQL Saturday #90. This is my first time traveling to Oklahoma City...

Re-blog – August 19-August 25

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts...

Side by Side installation of SQL Server 2008 and SQL Server 2008 R2

Recently I had to install SQL SERVER 2008 R2 BIDS on top of a machine which already had SQL SERVER...