A Good Cause #SeattleSummitMoments
This is another memory of the PASS Summit, this one inspired by Argenis Fernandez, who wanted to raise money for Doctors Without Borders. I wrote a bit about the...
2022-10-28
5 reads
Blog Posts
Composite Models in PowerBI -- The solution to poor search performance in SSAS
With the release of composite models in PowerBI, Ive been able to solve a long-standing issue with SQL Server Analysis Services: text search performance. In this article I am...
2022-10-28 (first published: 2022-10-17)
315 reads
Daily Coping 28 Oct 2022
Today’s coping tip is to realize you can’t do everything; what are your three top priorities now? It’s a few weeks before the Data Community Summit, volleyball starts, vacation...
2022-10-28
2 reads
I Hope Someone Brings Back Game Night
A few years ago at the Summit, Andy Warren and I set up a Game night. We convinced the organizers to give us a room for a few hours...
2022-10-28
3 reads
Memphis SQL Saturday 2022 & a Notebook
Back in person again! It is awesome to be able to get back into the SQL community and see fellow data professionals. A huge shout out to the Memphis...
2022-10-28 (first published: 2022-10-18)
152 reads
What’s next: New beginnings!
I’m both excited and frankly relieved to say that I’ve found a new position. Starting Wed Nov 2nd I’ll be ... Continue reading
2022-10-28
10 reads
Adding AD group perms to SQL Server
Why doesn’t SQL Server automatically check for the Group –> Object type when you are adding perms via SSMS? This hangs me up almost every time. I think “omg...
2022-10-27
7 reads
Daily Coping 27 Oct 2022
Today’s coping tip is to write down three specific things that have gone well recently. Easy, as a lot of things have gone well. I’m going with some travel...
2022-10-27
4 reads
Long time, no posts
I was working on two publisher contracts at the same time. I highly recommend never doing that. One is done, though, and it’s officially published as of September 2022....
2022-10-27
12 reads
Snowflake – Search Optimisation Service
Rarely do I say I love a feature across any technologies I have come across, in the snowflake world this is right up there. I tend to find this...
2022-10-27
77 reads
Blogs
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Forums
why cant i get rid of extra dataset
hi i never used shared datasets before in ssrs. i created a dataset called...
Distinct values using string_agg
Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType"...
Refactoring a DELETE query using NOT EXISTS — need expert feedback
Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup...
Question of the Day
Importing Flat Files
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers