English Posts

Paying back to the Aviation Community – CADORS Analytics

As most of my friends know (because I keep telling them) I am a private pilot. And as some of my pilots’ friends know, I’m a data analyst. When you mix those two things together you get what? Data! Here in Canada, we have an aviation system called CADORS – Civil Aviation Daily Occurrence Reporting […]

R Series: 1 – What, why and how – An Introduction to the R Language

Hey everyone, If you have not been enjoying long vacations or living under a rock, you do know that SQL Server now supports running R Scripts, the same goes for the Power BI tool. But what the hell is R? And why should I care? What? The R language is an open source framework for […]

SQL Server Error: 18056, Severity: 20, State: 29

Howdy everyone, One of the most frequent error messages I come across when dealing with SQL Server, particularly SQL Server 2008 R2, is Error 18056, Severity: 20, State: 29. Not only do I constantly see this error message in the SQL logs, but also in the Microsoft community forums. I often see inquiries likes, “I have SQL […]

SQL Server Cumulative Update Changes

Microsoft recently released the first Cumulative Update for SQL Server 2012 SP3 This CU addresses 8 issues in the product. But more importantly, it also marks a big shift in the Cumulative Update message sent by Microsoft. For a long time, there was a discussion between DBAs about when/if we should apply a cumulative update. […]

SQL Server 2012 SP2 Cumulative Update 5

Hey folks, Microsoft released the 5th Cummulative Update for SQL Server 2012 SP2. This update package contains fixes for 27 different issues, distributed as follows: One very important issue that was fixed in this CU release was KB3038943 –   Error 4360 when you restore the backup of secondary replica to another server in AlwaysOn Availability Groups. If you […]