There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going to repeat all that information here. Noteworthy resources (by “the Italians” of course): Filter Arguments in CALCULATE How CALCULATE works in DAX From SQL to DAX: Filtering Data In this blog post I’d rather discuss […]
Category: SQL Server
The Wait Is Over – SSIS 2017 Is Here!
UPDATE: recent builds of SSDT for VS 2017 can break TFS integration. Read more about it in the blog post SQL Server Data Tools 2017 and TFS Integration. UPDATE 2018-06-20: I was finally able to install the stand-alone version of SSDT for VS 2017 with working TFS integration. Read more about it here. Finally, months […]
Fix for Blurry SSMS in Windows 10
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 […]
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 […]
SSIS – Error while deploying package The locale identifier (LCID) is not supported by SQL Server
A quick blog post about an issue I encountered today. I tried deploying a simple SSIS project to my local SSIS catalog. No biggie. However, at the last step of the deployment I was greeted with the following .NET error: A .NET Framework error occurred during execution user-defined routine or aggregate “deploy-project-internal”: System.Data.SqlClient.SqlException: The locale […]
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 […]
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 […]