Hiding one or more columns
This isn’t something you have to do frequently, but sometimes you don’t want the users to have access to certain...
2015-11-12
672 reads
Blog Posts
New Version of MergeUi
I have made some changes to the way MergeUi works and also moved it into a new repository (https://github.com/GoEddie/SSDT-DevPack).
The way...
2015-11-12
49 reads
New Version of MergeUi
I have made some changes to the way MergeUi works and also moved it into a new repository (https://github.com/GoEddie/SSDT-DevPack).
The way...
2015-11-12
28 reads
New Version of MergeUi
I have made some changes to the way MergeUi works and also moved it into a new repository (https://github.com/GoEddie/SSDT-DevPack).
The way MergeUi used to work was that it enumerated the...
2015-11-12
4 reads
SQL New Blogger Challenge November 2015 Edition - Week 2 Digest
This week’s #sqlnewblogger posts!
Author Post @arrowdrive Anders On SQL: T-SQL Tuesday #72: Data modelling gone extremely wrong @rabryst Time After Time - An Introduction to Temporal Tables in SQL...
2015-11-12
4 reads
SQL Server Training
Brent Ozar’s group (http://www.brentozar.com/) just announced a pretty crazy set of “Black Friday” deals:
http://www.brentozar.com/archive/2015/11/announcing-our-2015-black-friday-sale-on-sql-server-training/
Insane sales if you can be one...
2015-11-12
580 reads
SQLSaturday 461: Join Me For a Full Day of Performance Training in Austin
Join me Friday, January 29, 2016 for a full day of performance tuning training as part of SQLSaturday 461 in...
2015-11-12
626 reads
The Resurrection of Reporting Services & The Maturing of Power BI
Spending the past two weeks at the annual PASS Global Summit and the Microsoft MVP Summit, I’ve consumed a literal...
2015-11-12
479 reads
T-SQL Tuesday #72 - Implicit Conversion Problems
This month T-SQL Tuesday is hosted by Mickey Steuwe (blog/@SQLMickey) and her topic of choice is “Data Modeling Gone Wrong.”
(If...
2015-11-12 (first published: 2015-11-10)
1,863 reads
Why are you still using datetime?
It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a...
2015-11-12 (first published: 2015-11-10)
4,848 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