The Fallacy of Internal Access Only
In the wake of Shell Shock, I’ve seen some vendor advisories indicate that while their product is vulnerable, it’s only...
2014-10-07 (first published: 2014-09-30)
7,117 reads
Blog Posts
Adding and Displaying Comments to Power Pivot Results in an Excel Pivot Table
Requirement: Allow users to enter comments after they review results from a Power Pivot model and then show the comment...
2014-10-06
947 reads
Carolina Technology Conference: Presentation Materials
For those able to attend my session at this year’s Carolina Technology Conference, thank you! As promised, here are the...
2014-10-06
795 reads
Does Full Backup contain data inserted during backup ?
Question : When you take full backup, do it capture data till the time backup start time or till the time backup end. Answer : Full backup capture database...
2014-10-06
9 reads
Does Full Backup contain data inserted during backup ?
Question : When you take full backup, do it capture data till the time backup start time or till the time...
2014-10-06
756 reads
Identifying large queries using Extended Events
Following on from my last blog post I now want to run through how to identify large queries using Extended...
2014-10-06 (first published: 2014-10-01)
12,173 reads
Making Better Presentations–Practice
This is part of a series of tips for speakers on how to make your presentations better.
There’s one thing that...
2014-10-06
845 reads
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...
2014-10-06
703 reads
SQL Server Days 2014 – Slide deck
SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers!...
2014-10-06
510 reads
Thoughts on the Student to IT Pro Seminar
Miscellaneous notes as I think on this.
I’ve been reading through feedback from the students. Reading the raw feedback is interesting...
2014-10-06
759 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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