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 […]
Tag: sql server
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 […]
My thoughts on Recertifying your MCSE through Microsoft Virtual Academy
A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in my blog post How I prepared myself for the MCSE certification. As you might know, this certification is only valid for 3 years. My certification should have expired a couple of months ago, but […]
Bigger Fact Table for Wide World Importers
Microsoft released a new sample database a couple of months back: Wide World Importers. It’s quite great: not every (unnecessary feature) is included but only features you’d actually use, lots of sample scripts are provided and – most importantly – you can generate data until the current date. One small drawback: it’s quite tiny. Especially […]
Webinar – SQL Server BI Best Practices
I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016. The title is SQL Server BI Best Practices and its abstract goes like this: Join us for this webcast to learn about best practices for SSIS, SSRS and SSAS. Our presenter, Koen Verbeeck has several years of experience working with the SQL Server Business […]
Book Review – Expert Performance Indexing
A few weeks back, the folks at Apress Publishing sent me a copy of the book Expert Performance Indexing in SQL Server for me to review. Since I know both the authors and since I’m familiar with the spectacular work they do, I was happy to do so. Doesn’t mean I won’t do an honest […]
T-SQL Tuesday #74: Be the Change
It’s the second Tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know what it means, T-SQL Tuesday is a monthly blog party of the SQL Server community – started by Adam Machanic (blog|twitter) – where everyone is invited to write about a common topic. This month’s T-SQL […]