Blog | Madeira Data Solutions

Jun 11, 20134 min

Nested Loops, Parallelism and Confusion

I’m 30 today. In addition, it’s been 10 years since I started working with SQL Server. In my twenties, I fell in love with T-SQL and SQL...

May 29, 20131 min

Hangouts Session with Boris Hristov

I was invited to take part in a new initiative conceived by Boris Hristov (Blog|Twitter). Boris wants to start using the Google Hangouts...

Apr 30, 20134 min

Five Ways to Improve Your Productivity with SSMS

For most DBAs, Management Studio is the primary work tool. That’s why properly using it can save a-lot of time and effort. Here’s a few...

Apr 23, 20136 min

Islands In The Stream

Or Using SQL Server 2012 Offset Functions to Detect Gaps In Your Data Today we are going to examine date island problems and the ways in...

Apr 17, 20131 min

Cool Tool – SQL Space Map

I came across a cool open source tool called “SQL Space Map“. The tool, written by Ryan McCauley, presents a visual representation of...

Mar 20, 20134 min

The Axis Of Evil

Views, table variables and local variables are great in terms of programming principles. But In terms of performance, they can be a honey...

Mar 12, 20132 min

Do You Know sys.dm_exec_text_query_plan?

One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan. This Dynamic Management Function allows us to...

Mar 5, 20133 min

On Trends And Proportions

Assuming you’ve been on earth lately, you probably heard the terms “Big Data”, “Hadoop”, “NoSQL” and so on. Companies want to check what...

Feb 26, 20131 min

SQL Server Videos

About two weeks ago, I wrote about SQL Server Podcasts and why I love that medium so much. Today, I want to talk about the various video...

Feb 18, 20132 min

Things You Can Find In The Plan Cache

Two weeks ago I delivered a presentation called “Things You Can Find In The Plan Cache” to the israeli SQL Server user group. Among the...

CONTACT US