I recently got a new laptop with Windows 10. I noticed SQL Server Management Studio (SSMS 17.1) was looking a bit blurry on my laptop screen. On another screen, it looked fine though. The cause for this is easy to find in the display settings. My primary screen is scaled to 125%, while the other […]
Tag: sql server
Two Small Tips for Working with Azure
Very quick blog post about two tips for working with Azure (hence the title of course). I recently started up a project where the data warehouse needed to be fully in the cloud. This was an Azure SQL Database, not Azure Data Warehouse. The size of the DWH was just not big enough (although Microsoft […]
Webinar – Supercharge Your SQL Server Data Warehouse with Columnstore Indexes
I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar will be an introduction to columnstore indexes, which have gained quite some importance since you can now use them in Standard Edition of SQL Server 2016 SP1 or higher. Title: Supercharge Your SQL Server Data Warehouse […]
Power BI Announcements Summary
It was a crazy week for Power BI. There were quite a lot of announcements, so I’ll try to wrap them up in one single blog post and share my thoughts as well. POWER BI DESKTOP Again an amazing release (May 2017). Noticeable features are: Measures on top of live SSAS Tabular connections! I’ve been […]
T-SQL Tuesday 89 – Roundup
I asked the SQL Server community to write about their experience/opinion about the changing world we live in and how it impacts their daily job. The response was overwhelming: we had 30 participants in this months blog party! Here’s an overview of everyone who participated. Take your time to read their stories, as they are […]
T-SQL Tuesday #89 – The times they are a-changing
This month’s T-SQL Tuesday is hosted by yours truly! The topic this month: how do you keep up with the fast changing world of data management? Does this impact your job? Or do you feel there’s no impact at all for your position? Do you fear the cloud? And so on 🙂 Everything changes fast […]
T-SQL Tuesday #89 Invitation – The times they are a-changing
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called T-SQL Tuesday, it’s not limited to SQL Server database engine only). It is the brainchild of Adam Machanic (blog | twitter) and I’m honored to host this month’s edition. Each month a blog hosts the party and […]
T-SQL Tuesday #88 – The daily (database-related) WTF
It’s the time of the month again: the T-SQL Tuesday! This month’s edition is hosted by Kennie Nybo Pontoppidan (blog|twitter) and the topic is “daily database related WTF”. In other words, we get to tell one of our horror stories we encountered in our career as data professionals. Let me tell you the story of a small […]
T-SQL Tuesday 86: SQL Server Bugs & Enhancement Requests
Let’s kick off the new year with a T-SQL Tuesday! This month’s edition is hosted by Brent Ozar: Announcing T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests Brent wants us to blog about our favorite Connect items because Microsoft is currently listening to its customers and actually closing items. So it is the time […]
Clustered Columnstore Index really hates Updates
First a little background. I’m working on a large fact table that behaves itself as a slowly changing type 2 dimension. Weird right? But I have a good reason for this: it’s a snapshot table and if I would create the snapshots like you’re supposed to (by exploding the fact table) I would end up […]