Preparing for PASS Summit - Networking and Events
This is my second post in a series which I hope will help you (and me!) prepare for the upcoming PASS Summit November 4-8, 2019 in Seattle, Washington.
Networking, Networking!...
2019-10-14
4 reads
alevyinroc
- Website: https://flxsql.com
T-SQL Tuesday #119 - Changing Your Mind
For T-SQL Tuesday this month, Alex Yates (blog | twitter) gives us this challenge:
I would like you to write about something in your IT career that you have changed...
2019-10-08
5 reads
Preparing for PASS Summit 2019 - Logistics & Survival
It’s time once again to prepare ourselves for the endurance test that is PASS Summit, November 5-8. I’ve participated in the Summit Buddies program the past two years, but...
2019-10-07
5 reads
The "Go Pack"
I’ve found myself traveling quite a bit this year, with more travel on the horizon. Like many, I travel with a fair bit of technology and of course that...
2019-09-17
1 reads
T-SQL Tuesday #118 – Your Fantasy SQL Feature
It’s early September, which means it’s time for T-SQL Tuesday! This month’s topic comes from Kevin Chant (blog | twitter). Our mission, should we choose to accept it (click...
2019-09-10
6 reads
T-SQL Tuesday #118 – Your Fantasy SQL Feature
It’s early September, which means it’s time for T-SQL Tuesday! This month’s topic comes from Kevin Chant (blog | twitter). Our mission, should we choose to accept it (click...
2019-09-10
4 reads
Q&A: Dealing with Thousands of Databases (Part 3)
This is Part 3 in a three-part series. Please see Part 1 and Part 2 for more.
What does your average day look like?
I’m going to punt to my “A...
2019-09-06
6 reads
Q&A: Dealing with Thousands of Databases (Part 3)
This is Part 3 in a three-part series. Please see Part 1 and Part 2 for more. There we go! Thank you Jon for sending in your questions. This...
2019-09-06
5 reads
Q&A: Dealing with Thousands of Databases (Part 2)
This is Part 2 of a series. Please see Part 1 for the background and more. Stay tuned for the thrilling conclusion in Part 3, coming soon!
The post Q&A:...
2019-09-05
16 reads
Q&A: Dealing with Thousands of Databases (Part 2)
This is Part 2 of a series. Please see [Part 1]/2019/09/03/qa-dealing-with-thousands-of-databases/) for the background and more.
What is the most unexpected experience you’ve had in this position?
I have two answers...
2019-09-05
4 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