Where did this database come from??
Happy Tuesday, blog reader. Have you ever come across a database you had not seen before or was in a different naming convention than you are used to seeing?...
2022-10-31 (first published: 2022-10-18)
605 reads
Blog Posts
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
17 reads
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)
324 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
5 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
16 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)
167 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
21 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
23 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
19 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
33 reads
Blogs
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers