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)
318 reads
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
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
5 reads
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)
154 reads
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
11 reads
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
11 reads
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
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
16 reads
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
81 reads
Kristyna and I were working through some updates to our site and realize that this was going to be our 250th blog post on Data on Wheels. I thought...
2022-10-26
10 reads
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Setting page visibility and the active page are often overlooked last steps when publishing...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers