Author Archives: louwf

SQL versus NoSQL databases

I recently saw an Information Management To-Be Architecture Overview diagram at a client. It has clearly depicted the current landscape for the Relational Database side. Then came the surprise, a single belittled square box called “NoSQL”. What does that mean? … Continue reading

Posted in NoSQL | Tagged | Leave a comment

Best Practices for Building a Large Scale Data Warehouse

You walk into the office today and your client, or your boss, asks you to build a warehouse. All seems fine and dandy, right. You are the developer and this should be easy. “O, and by the way, our 5 OLTP systems … Continue reading

Posted in SQL Server 2014 | Tagged , , | Leave a comment

SQL 2014 SP1 released

Microsoft has released Service Pack 1 for SQL Server 2014 , 14 May 2015. Why do you need it? The most obvious reason is, it is free! Secondly, there are some key fixes and improvements included in this release. Below … Continue reading

Posted in SQL Server 2014 | Tagged | Leave a comment

SQL Indexing

Thanks to the web today there are really fantastic information available for every SQL Server professional (trust me 15 years back it wasn’t the case). One such key topic is Indexing. Instead of re-inventing the wheel I want to give a great … Continue reading

Posted in SQL Server 2014 | Tagged | Leave a comment

SSMS Solutions

Have you ever looked in amazement at your SQL guru who can whip up in a flash a fancy TSQL script to run? Today I will share with you a super handy feature in SQL Server Management Studio (SSMS) called … Continue reading

Posted in SQL Server 2014 | Tagged , | Leave a comment

SQL Server data warehouse performance settings

This is the checklist you need to ensure your SQL Server environment is optimally setup for Data Warehouse loads. I have compiled it based on experience and the FastTrack data warehouse reference architecture. Confirm that Windows Server 2012 Application Server … Continue reading

Posted in SQL Server 2012, SQL Server 2014 | Tagged , , , | Leave a comment

Recommended Maxdop for SQL Server

There are some server level settings in SQL Server that you want to, and must, change. Each installation and client environment is different. Hence you want to get the best performance from you SQL that you can based on your … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014 | Tagged , | Leave a comment