F# Type Inference
I’m just starting to look at functional languages from an Object Oriented background. One of the first things I thought...
2015-01-23
38 reads
Gavin Draper
Tools For Successful Remote Working
I’ve been asked a few times recently how I find remote working and how well it works so I thought...
2014-10-13
41 reads
Entity Framework Fluent API and Indexing
With the release of Entity Framework 6.1 the Fluent API can now be used to create indexes. It’s still pretty...
2014-06-26
144 reads
Rails Continuous Testing
Coming from the .Net world where continuous testing is expensive on both the wallet and processing power seeing what Ruby...
2014-03-11
49 reads
Browser Based Web Notifications
3 of the 4 major browsers now support web notifications (Safari, Firefox, Chrome) and no where near enough sites are...
2014-03-01
46 reads
Cloning a SQL Server Database
The following script will backup and restore a database to the same server with a different name. Tested on SQL...
2014-03-01
45 reads
Using Google Charts With AngularJs
I recently rewrote a small webpage in AngularJs and it was amazing how much lighter and cleaner it made the...
2013-07-30
94 reads
Debugging Issues With Log4Net Not Logging
When you find log4net is not writing anything to your logs it can be a pain to debug as obviously...
2013-07-29
153 reads
ASP.Net MVC Debugging "Internal Server Error 500"
I was recently seeing “Internal Server Error 500” when trying to make an ajax call from an ASP.Net MVC view...
2013-06-22
499 reads
Das Keyboard - First Thoughts
There seems to be a lot of buzz around mechanical keyboard lately as more and more manufacturers have started producing...
2013-06-19
43 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