SQLSaturday #362 – Austin, TX – Let’s Get Weird
I used to spend the 4th of July weekend (or week) in Austin with some buddy’s when we were in...
2015-01-20
925 reads
The Smiling DBA
PASS – Connect, Share and Learn
The Professional Association of SQL Server (PASS) has a slogan for what they do – CONNECT, SHARE and LEARN. So, what...
2014-12-18
624 reads
PASS Summit: Blogger Q&A with Board of Directors Executive Committee
On Thursday, I was invited as a blogger to attend an intimate conversation (Q&A) with the PASS Board of Directors:...
2014-11-07
782 reads
PASS Summit 2014
Well, it is that time of year again. The Professional Associations for SQL Server (PASS) annual summit. This year we...
2014-10-29
1,250 reads
Can’t Create A Timeline in Excel on Multidimensional Cube
Excel 2013 - We can’t create a Timeline for this report because it doesn’t have a field formatted as Date.
After getting...
2014-10-15
3,360 reads
PASS got it right
This morning I received an email (really 3 emails) about an extension for voting for the Board of Directors giving...
2014-09-27
774 reads
PASS Summit 2014 Announcements
In case you do not receive the PASS connector, here are some announcements for this year’s summit on Nov 3rd...
2014-09-03
813 reads
Upcoming PASS Virtual Chapter Webcast (FREE!!!)
As always, there are many free ways to learn more about SQL Server and the Professional Association of SQL Server...
2014-08-08
683 reads
PASS Data Arch VC presents SQL Server MVP Grant Fritchey - How to Build a Database Deployment Pipeline
Please come join the Data Architecture VC this Wednesday to get info from MVP Grant about Database Deployment something all...
2014-07-21
459 reads
Upcoming Free PASS VC Webcasts
Here is a list of upcoming webcast presented by various PASS Virtual Chapters that are always free. Some are recorded...
2014-07-08
597 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