Tips on Getting Hired – Part 2
Yesterday I posted Part 1 containing five ideas for those looking for work. Today I’m going to focus on what...
2009-06-16
998 reads
Blog Posts
Better Know A SSIS Transform – The Pivot Transform
This is part 1 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-06-15
1,692 reads
Notes on SQLSaturday #12 in Portland
I didn’t attend, but wanted to get this written down somewhere!
I’m just catching up on email, Ken Starnes said all...
2009-06-15
540 reads
PASS Summit 2009 - PowerShell and Performance
Over the weekend I received the great news that I've been selected to present a new session, Gather SQL Server...
2009-06-15
353 reads
Pensacola Results
A week ago I spoke at the Pensacola SQLSaturday event to about 30 people. A few drifted in late, so...
2009-06-15
918 reads
See You In Seattle For PASS 2009!
Last Friday I got the official notice that I've been selected to present a community session at the 2009 PASS...
2009-06-15
463 reads
Tips on Getting Hired – Part 1
I was recently asked for advice about seeking a job, a request we all get from time to time. In...
2009-06-15
725 reads
Update on PASS Selection
I received my notification from the PASS Program Committee on Friday evening,
and found out that I will not be...
2009-06-15
597 reads
What I Learned at PASS
There’s a contest going on at PASS looking for answers to “Best Thing I Learned at PASS”. I don’t want...
2009-06-15
1,064 reads
Finding a New Laptop Bag – Progress!
Way back on May 19 I wrote about my search for a new laptop bag to replace my somewhat tattered...
2009-06-14
713 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