In my last blog I explained what a columnstore index is, in this blog, we will dive into creating a clustered columnstore index and look at the performance differences...
2019-07-31 (first published: 2019-07-10)
562 reads
For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...
2019-07-29 (first published: 2019-07-10)
202 reads
Welcome to our continuing series that Erin Ostrowsky [Blog | Twitter] and I spend focusing on interviewing for a Power BI position. This series will
2019-07-30 (first published: 2019-07-09)
723 reads
It doesn’t look like this would affect SQL Server 2008 or SQL Server 2008 R2 since the earliest reported platform is SQL Server 2014, but in Microsoft’s release of...
2019-07-17 (first published: 2019-07-09)
1,757 reads
This month is an interesting invitation from Tracy Boggiano. It’s on Linux, which I like. I hadn’t thought about this in terms of T-SQL Tuesday, but I think it...
2019-07-29 (first published: 2019-07-09)
191 reads
Every so often I set out to create new resources in my Azure subscription using the command line tools (PowerShell or CLI) just to keep up to date on...
2019-07-25 (first published: 2019-07-09)
491 reads
Watch this week’s episode on YouTube! Today I want to share with you an interesting observation I made about SELECT expression execution order. I was working on writing a...
2019-07-23 (first published: 2019-07-09)
815 reads