Blog | Madeira Data Solutions

T-SQL Programming for Developers Course

Are you a software developer? Did you ever get to develop a software that works with a Microsoft SQL Server database? Perhaps you started...

Mar 13, 20172 min read

The Challenge One of our clients in the gaming industry wanted to set up a high availability solution in their data center in the UK....

Feb 1, 20179 min read

Let’s talk about the DATEDIFF vs. DATEADD functions in SQL Server. Each one performs a different task. The former calculates the...

Jan 26, 20174 min read

One of the most common mistakes people make when writing T-SQL is using a function in the where clause, and perhaps the most common of...

Jan 23, 20172 min read

Last Thursday, I delivered my seminar, Performance-Oriented SQL Server Development at the Expert Days conference in Israel. It was a...

Dec 31, 20161 min read

On November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was “SQL Server DBA...

Dec 12, 20169 min read

Yes, it’s that time of the year again. It’s time for the annual PASS Summit. Just like every year, I had the pleasure of attending Summit...

Oct 31, 20165 min read

Machine Learning is a very powerful technology used in the field of predictive analytics. As far as I see it, Machine Learning is magic....

Oct 20, 20163 min read

On October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days in Belgium, and this time it’s...

Sep 29, 20161 min read

Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There were around 200 attendees in my...

Sep 8, 20161 min read