top of page


SQL Server 2016 Cumulative Update 1
On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to celebrate. Usually we are...

Madeira Team
Aug 4, 20162 min read


Math in SQL Server – Calculating the Value of e
This is also called the natural logarithm, which is approximately equal to to 2.718281828459… I like numbers: many numbers, huge numbers...

Madeira Team
Jul 26, 20163 min read


Who the Hell is Going to Listen to SQL Server on the Radio
About 3 years ago Matan Yungman contacted me and said he has an interesting proposition. We met and talked about all kinds of things,...

Madeira Team
Jul 21, 20163 min read


If You Need to Think, You’re Doing It Wrong
A month ago, my wife and I were in Barcelona for a short vacation. In one of the days, we entered a small place called Wok to Walk for...

Madeira Team
Jun 29, 20163 min read


My PASS Summit 2016 Session Submissions Feedback
I’m excited to say that I will be delivering a session in this year’s PASS Summit in Seattle later this year! The session is called...

Madeira Team
Jun 24, 201610 min read


We Must Wait for SP1 before Upgrading to SQL Server 2016
This post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server 2016 I’ve been...

Madeira Team
Jun 14, 20163 min read


24 Hours of PASS- Madeira’s professionals MUST SEE sessions
24 Hours of PASS coming up on May 25-26 We have challenged our team to choose one MUST SEE session, a session that there is no chance...

Madeira Team
May 18, 20162 min read


Why I Love SQLBits
Last week I attended SQLBits 2016 in Liverpool. I had such a great time, and I would like to share it with you. I arrived on Tuesday...

Madeira Team
May 8, 20162 min read


Columnstore Index Enhancements in SQL Server 2016
One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they continue...

Madeira Team
Apr 27, 20163 min read


Partition to Filegroup Mapping in SQL Server
Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition to a...

Madeira Team
Apr 25, 20161 min read
bottom of page
