Upgrading to SQL Server 2012?
Do you have any plans in place to upgrade to SQL Sever 2012 this year. We are now well into...
2013-03-06
1,054 reads
Gethyn Ellis
Virtualising your SQL Server?
Having just completed the latest revision of Learning Tree's SQL Server Virtualisation and consolidation course I thought I'd share with...
2013-03-04
663 reads
SELECT TOP 5 PERCENT WITH TIES
LinkedIn sent me an email on Monday that said my profile was in the top 5% of viewed profiles in...
2013-02-12
864 reads
SQL Server Auto grow
I had a great response to my blog post and poll last week about how DBAs use auto grow. In...
2013-01-16
1,026 reads
SQL Server Consulting: Weekly Round-up
The first full week in 2013 has been a a busy week for me with lots of SQL Server consulting...
2013-01-12
1,001 reads
#SQLSaturdayExeter–Superb SQL Server Event
#SQLSaturday194 is coming to Exeter on the 8th – 9th March.
What is SQL Saturday? The brain child of Steve Jones,...
2013-01-11
760 reads
Auto grow–On or Off Straw Poll
David Postlethwaite who contributes to this blog regularly sent me an email this morning asking about Database Auto grow.
This...
2013-01-10 (first published: 2013-01-07)
1,994 reads
SQL Server Virtualisation and Consolidation
Come and join me in London this March for a 3 day course on SQL Server virtualisation and consolidation.The course...
2013-01-10
1,025 reads
SQL Server Contracting and Business Network Wales - LinkedIn Groups Updates
I have been doing some work on some LinkedIn groups that I manage and look after over the holidays. There...
2013-01-04
866 reads
SQL Saturday #194 Exeter
I have read much about SQL Saturday’s but I have yet to attend one, that is about to change. I...
2013-01-03
833 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