Contracting – Your best clients are your current clients…
and your old clients too.
Before I started my contracting business five years ago I realised the importance of selling and...
2012-06-20
831 reads
Gethyn Ellis
Washington DC in the Summertime
As I mentioned in my post last week I was fortunate enough to visit Washington DC a week or so...
2012-06-18
728 reads
@LearningTree: 2108 SQL Server 2012 Database Administration
This past week my international adventures have continued. As some of you know, for the past couple of years, I...
2012-06-13
1,537 reads
Twitter Handle Change
I have been thinking about this for a while now, but I have decided to change my twitter handle. I...
2012-06-08
729 reads
Ottawa In the Summer Time
I wrote a post earlier this week telling you all about my trip to Ottawa last week, during my trip...
2012-06-01
863 reads
How to Give your .NET application HA
By David Postlethwaite
I was at a meeting the other week when someone mentioned that you could specify two SQL Servers...
2012-05-31
1,741 reads
Learning Tree: SQL Server DBA Skills Upgrade
I’m very lucky in my work as freelance consultant and trainer I get to travel the world, and last week...
2012-05-30
2,131 reads
Books for Learning Transact SQL
I got asked a question recently about what books I would recommend for learning T-SQL. I posted a couple months...
2012-05-29
1,115 reads
The Importance of Regular Blogging
Between my old website, which I started back in 2007 (which has since disappeared) and my blog, which I switched...
2012-05-28
1,030 reads
Looking for a DBA? Looking for a New Job?
Ryan Recruiter meet Dave DBA…
As a contractor and consultant I get to speak to many agents and recruiters and over...
2012-03-14
709 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...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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