Phil Factor SQL Speed Phreak Competition
If you have a database application that is running slowly, or is straining the server, what do you do? After...
2009-10-25
3,144 reads
Blog Posts
SQL University: Authentication and Authorization
Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics...
2009-10-25
10,870 reads
Red Gate Has 10th Birthday
I first met Simon Galbraith, one of the co-owners of Red Gate Software at PASS in 2002, when they had...
2009-10-24
408 reads
Another Year, Another Missed PASS Summit
This year I was really looking forward to going to the PASS Summit. It's worth every penny in the knowledge you'll...
2009-10-23
1,666 reads
Download the Free eBook “The SQL Server Tacklebox”
Rodney Landrum, SQL Server MVP, is the author of the new book, The SQL Server Tacklebox: Essential Tools and Scripts...
2009-10-23
582 reads
Just Submitted Session for South Florida Code Camp
I can’t wait until Feb 27 when Code Camp is right in my backyard! I just submitted my session for...
2009-10-23
359 reads
Not Pointing Fingers - Microsoft and Sidekicks
Someone posted a note on Twitter about the Sidekick fiasco. Apparently the servers that lost data weren't Microsoft servers. They...
2009-10-23
810 reads
PASS Summit One Week Away
It’s just a week and a couple of days before I’ll be hopping a plane for Seattle and the 2009...
2009-10-23
582 reads
Some useful commands and sp for Transaction Replication
This blog is having some useful commands we use for replication and troubleshooting.
>>Some useful commands and stored procedures
How it works:
Log...
2009-10-23
18,452 reads
Some useful commands and sp I use for Transaction Replication:
I write several blog about replication and mansion commands and stored procedure related to transaction replication, but I would like...
2009-10-23
1,325 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