Another reason that T-SQL beats the GUI
In IT, we have a few very solid and universal principles that no one ever argues with. The first of...
2011-11-14
574 reads
SQL Awesomesauce
Things I Favorited on Twitter (a weekly wrapup, of sorts)
Each Friday on @Midnight">DBAs@Midnight (my live weekly webshow, 11pm CST at webshow.MidnightDBA.com!) I don’t feel like I have enough time...
2011-11-04
934 reads
SQL Tribal Knowledge
Calling all unpublished* SQL Server folk!
I’m now accepting abstracts for a new project we’re putting together – a community-written book of...
2011-11-01
869 reads
Applied SQL: Demonstrate Simple Backup and Restore
Let’s apply a little backup and restore knowledge, eh wot?
I introduce this whole concept in Applied SQL: You Have Homework....
2011-10-26
799 reads
Un-SQL Friday #006: Living in the Intertubez
We’ve had some BIG fun this week, relatively speaking, with #SQLSue and #SQLIdiot and just general #SQLcraziness. We’ve had several...
2011-10-20
598 reads
RSS Tuning Whitepaper notes and clarifications
This morning this caught my eye on SQLServerCentral.com: Maximizing SQL Server Throughput with RSS Tuning(it came with a catchy SQLCAT...
2011-10-19
665 reads
Rat Sues Corn! Rather, rat accuses corn of thought-theft! Or something!
Note: I will be updating this post with, er, updates as I get them…
We’ve had our fair share of plagarists,...
2011-10-18
679 reads
PASS Summit 2011 Day 3 – Keynote Live Blog with Dr. DeWitt!
Today’s keynote with Dr. DeWitt starts at 8:15am EDT. Click here to watch today’s keynote live. For information on today’s...
2011-10-14
1,681 reads
PASS Summit Day 2 – Women in Technology Live Blog
Jes Borland Hosts the 2011 WIT Luncheon
Click here to watch today’s WIT luncheon live. For information on today’s luncheon and...
2011-10-13
874 reads
PASS Summit 2011 Day 2 – Keynote Live Blog
Today’s keynote with Quentin Clark starts at 8:15am EDT. Click here to watch today’s keynote live. For information on today’s...
2011-10-13
600 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