Oh Yes It’s Ladies Ni…errr…Month
Making WIT awesome since 1993
It’s March and this month sees a lot of celebration, amongst the parties are Mardi Gras...
2011-03-04
435 reads
sqlchicken
Pragmatic Transition: Lighthouses and Shipwrecks
Sometimes your mistakes are the greatest lessons...
This is the next post in my series about transitioning from a DBA to...
2011-02-21
686 reads
BIxPress 3.0: DBAs Welcome!
Much like the USA Network here in the States welcomes characters, I’d like to formally let the world know that...
2011-02-14
569 reads
SQL University: State of the Union
The new SQL University Logo
Well the new year is here and SQL University is back and better than ever! I...
2011-02-03
639 reads
Temporary Post Used For Theme Detection (da60724d-7ccd-4e8d-906c-51c74980afa7 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (983091ab-b664-45c1-9b17-9e54b839020e – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
Digg This PostStumble This Post
2011-01-25
421 reads
Policy for Ad-hoc Workloads
During my presentation at SQLSaturday 62 in Tampa I was asked by an attendee about having a policy to check...
2011-01-20
922 reads
SQL University: Spring 2011
The new SQL University Logo
Welcome back students! We’re very excited to start up a new semester and SQLU is back and...
2011-01-18
1,258 reads
EPM Framework and SQL 2008 R2
This weekend at SQLSaturday 62 in Tampa, I presented my policy-based management presentation. During my presentationone of the cool things...
2011-01-17
1,314 reads
SQL University: Spring 2011
The new SQL University Logo
Welcome back students! We’re very excited to start up a new semester and SQLU is back and...
2011-01-13
841 reads
Pragmatic Works: The Transition
So if you know me via Twitter or my blog you
probably know that as of about a month or two...
2010-12-21
971 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