If you are considering going to Seattle from 27-30 October and attending this year’s edition of PASS Summit, now is the time to register as the price will go up in very few days. Until July 12th you can save 400$ on the registration fee. You can save 150$ more by using the discount code […]

Originally posted on spaghettidba:
Choosing the right data type for your columns is first of all a design decision that has tremendous impact on the correctness of the database schema. It is not just about performance or space usage: the data type is the first constraint on your data and it decides what can be…

Today, when clicking around SSMS, I discovered this little helpful trick, that you probably already knew but here it comes anyway. If you want to see the number of rows in a table you can always use Select count(*) from TableName but it has quite a nasty performance. Another way to do it with much […]

The line above is the first information that meets the eye when browsing to imshealth.com , my new employer ! As a matter of fact, friday, the company I work at – Rehfeld partners a/s – annouced that it was bought by a huge multinational healthcare company with filials and ramifications in many countries : IMS […]

After 2 weeks of moving sessions around and finding the best mix and match of DEV, BI, DBA, Azure and SharePoint content it is my pleasure to publish the schedule for SQL Saturday 413 which will be held in Copenhagen on September 19th at the IT university of Copenhagen. September 17th and September 18th are 2 […]

Originally posted on Rui Romano Blog:
Last week we published on GitHub a powershell module for the new PowerBI developer REST API’s named “PowerBIPS”, download it here: https://github.com/DevScope/powerbi-powershell-modules/ In this post I will demonstrate the ease of use of this module and show you step-by-step how to build a powershell script that upload server stats…

Next week I will virtually be speaking at a 2 days SharePoint virtual conference : SPBIZ. I will speak about a subject that I particularly like : Doing Business Intelligence with SharePoint. About configuring Excel services, Reporting Services and Power Pivot Service to provide SharePoint BI tools in a secure and performant way. This is a […]

Follow

Get every new post delivered to your Inbox.

Join 791 other followers