SQLSaturday Orlando–Power BI On-Premises In A Day
Please join me for a day of developing and deploying Power BI reports in an On-Premises environment. This event is...
2018-08-20
249 reads
The Smiling DBA
SQLServerCentral.com Stairway Series–SSAS Tabular
The first 2 articles have been published on a SQLServerCentral.com Stairway series for SQL Server Analysis Tabular models. This is truely a blessing to be able to publish on...
2018-07-25
18 reads
SQLServerCentral.com Stairway Series–SSAS Tabular
The first 2 articles have been published on a SQLServerCentral.comStairway series for SQL Server Analysis Tabular models. This is truely...
2018-07-25
271 reads
Idera Greek Sync: Performance Tuning with Execution Plans
On Wednesday July 11th, please join Idera Geek Sync at 11AM Central for a walk through some basics in Execution Plans. We will look at the history of execution...
2018-06-24
12 reads
Idera Greek Sync: Performance Tuning with Execution Plans
On Wednesday July 11th, please join Idera Geek Sync at 11AM Central for a walk through some basics in Execution...
2018-06-24
350 reads
2018-04-26
10 reads
2018-04-26
437 reads
24 Hours of PASS – April 25th–26th
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours session go on once an hour for 24 hours....
2018-04-18
23 reads
24 Hours of PASS – April 25th–26th
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours...
2018-04-24 (first published: 2018-04-18)
2,311 reads
DBA Fundamentals–Tuesday 11 Central–Execution Plans
WHAT: EXECUTION PLANS FOR BEGINNERS
WHEN: Tuesday, 04/17/18 - 11:00 am – 12:00 pm
WHO: Thomas LeBlanc
WHERE: https://attendee.gotowebinar.com/register/7086336336602188044
This will be a Beginners session highlighting the starting point for using the...
2018-04-12
15 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...
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...
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