Trello – Integrations
In December I wrote about working from home in which I talked about Trello. Trello is a virtual kanban board...
2018-02-02
100 reads
John Morehouse | Sqlrus.com
Javascript Postback Download via Powershell
Recently, one of my clients had a need to automatically download a file from a public facing state government website. ...
2018-01-26
1,128 reads
Javascript Postback Download via Powershell
Recently, one of my clients had a need to automatically download a file from a public facing state government website. ...
2018-01-26
126 reads
Implementing SSL for Your Blog
With the announcement of the recent security issues, namely Meltdown and Spectre, we at Denny Cherry & Associates Consulting have been...
2018-01-19
514 reads
Azure VPN – Point to Site IP Addresses
Recently, I got to work with a client on something interesting. We implemented transactional replication to send data to an...
2018-01-22 (first published: 2018-01-12)
1,327 reads
Trello – Overview
Last month in December, I posted an article about working from home. In it I mentioned a couple of tools...
2018-01-05
421 reads
Trello – Overview
Last month in December, I posted an article about working from home. In it I mentioned a couple of tools...
2018-01-05
576 reads
Out with the Old, In with the New
In a few days the year 2017 will come to a close. The brand new year 2018 is on deck...
2017-12-29
485 reads
Out with the Old, In with the New
In a few days the year 2017 will come to a close. The brand new year 2018 is on deck...
2017-12-29
325 reads
Working From Home
It’s now been one month since I’ve started to work for Denny Cherry & Associates Consulting. Working for DCAC now enables...
2017-12-01
467 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