Analyze Actual Execution Plan
One of the many new sets of functionality introduced in SQL Server Management Studio 17 is the new option “Analyze...
2018-08-22 (first published: 2018-08-06)
2,627 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Actual Execution Plan Costs
Why don’t “actual execution plans” have “actual execution plan costs”? This is a question and a myth I have to...
2018-08-20
305 reads
Identifying HIPAA, PCI & SOX Data for Masking
Working for a company based in the UK (still currently a part of the EU) I had a lot of...
2018-08-15 (first published: 2018-07-30)
2,673 reads
I'm Not a Lawyer, But...
Over the last 18 months or so, I’ve spent a lot of time reading about the General Data Protection Regulation or GDPR. If you don’t know about it, you live under a rock, are a very old school dba, here’s a reference to the law itself. If you’re working as a data professional, I’d strongly […]
2018-08-06
85 reads
Youtube Channel Update: 3 August 2018
I’ve posted a number of new videos to the Youtube channel that might be of interest if you’re a data...
2018-08-03
387 reads
Databases and DevOps, Tools are the Easy Part
Moving your database development, deployment and management into a DevOps methodology does involve choosing and implementing tools and tooling. Tools...
2018-07-25 (first published: 2018-07-16)
2,066 reads
Database Fundamentals #18: The SELECT Statement
In my previous Database Fundamentals post, I showed you how to use the Query Designer to build a query. That...
2018-07-23
817 reads
What Is The Preferred Join Operator in SQL Server?
I schedule many of my blog posts at least 2-3 weeks out, so I have time to adjust them, change,...
2018-07-16 (first published: 2018-07-09)
3,805 reads
Why Aren’t You Using SSMS 17?
Last fall, Microsoft split the coding and release of SQL Server Management Studio away from any dependency on the server...
2018-07-12 (first published: 2018-07-05)
4,766 reads
Dealing with Disparate Goals
Grant talks about the lessons of history when the goals of different groups don't align.
2018-07-09
80 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers