(Steve Endow) There is a lot of background to this, but the short story is that a consultant needed to update the SOPHDRFL field in the SOP10100 table. But it turns out that the SOPHDRFL field is binary–not your average field type.

(Pinal Dave) A lot of my blog readers contact me via comments and I try my best to reply to all of them. Sometimes issue is so interesting that I ask them to contact via email. This blog is result of such an interaction.

(John Miner) The Power BI desktop designer is a great tool and in this tip we will look at advanced mathematical formulas using the M language.

(Daniel Mellor) My shop uses a lot of monitoring. In fact, just about every monitoring feature built into SQL Server we have tried, are using, or have plans to use in the near future. Some of the monitoring overlaps in purpose, and some of it steps on each others’ toes.

(Kenneth Fisher) The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at the instance level, but prior to that it was just CONNECT. It does basically the same thing in both cases.

(James Serra) This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database.

(Michael J. Swart) Remember that functions – including those found in default constraints – are not executed simultaneously. This can sneak up on you whenever you have multiple function calls in a single statement or multiple default constraints in a single table.

(Chris Webb) In part 1 of this series I looked at the basics of monitoring SSAS Multidimensional query resultset serialisation in Profiler. In this post, I’ll be taking a look at what happens for queries that return large amounts of data

(Scott Murray) Can I really make great data visualization reports with Power BI Desktop? What visualizations are available? How can I access my data? How difficult is it to make changes to my reports to make them more user friendly?

(Kenneth Fisher) I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor for unexpected problems (because if they are expected you fixed them right?).