What Will I See at SQL Connections?
The SQL Connections conference will be held this November in Las Vegas and Steve Jones is attending. See what he's interested in viewing at the event.
2009-09-16
126 reads
Editorial
What's Your Education Worth?
Most of us learn on the job, but is that the best way? If you could learn faster at a cost, would you pay it? Steve Jones talks a little bit about what he has done and what he would do today in today's editorial. What is a SQL Server education worth to you?
2009-09-15
153 reads
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
2009-09-14
991 reads
35K
Microsoft's new server lab building will house 35,000 servers. That's a lot of computing power, and it's being done in a greener fashion.
2009-09-14
83 reads
Moore's Law
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
2009-09-11
155 reads
A Good Word for ODBC
A guest editorial from Phil Factor puts in a good word for ODBC. This is the standard for Windows machines to connect to all kinds of data sources, and is both loved and hated by developers of all kinds.
2009-09-10
319 reads
Finding Passwords
There was a vulnerability announced in the SQL Server password system last week, but Steve Jones doesn't see this as much of an issue. Read his thoughts and see if you agree.
2009-09-09
227 reads
Using the Best
What's the best driver for your server? What's the best of anything? Steve Jones talks about how the experts determine this, and why there is no easy answer.
2009-09-08
95 reads
Had this been an actual emergency….
Rodney Landrum has lived through several simulated emergencies and one real one, in the form of Hurricane Ivan. The tests do not adequately prepare you for the real thing. Real emergencies bring tension, exhaustion and hunger pangs. Simulations bring lethargy, pre-determined end times, and warm pizza.
2009-09-07
179 reads
Happy Labor Day 2009
It's a holiday in the US and Steve Jones takes a day off with a blooper reel for the editorial.
2009-09-07
74 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