Today we have a guest editorial from Grant Fritchey. The Boy Scouts motto is "be prepared" and most of you probably unconsciously follow that in your daily lives. Why is it that so many of us don't follow through on this same advice with our databases? Grant Fritchey gives a few examples of how you should "be prepared" for a database emergency.
2010-01-04
2,236 reads
In this article, we are going to focus on writing or refactoring the data access codes using the best practices. But, before we start playing the game, we need to prepare the ground first. So let’s do the groundwork at this very next step:
2010-01-04
7,082 reads
Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results?...
2010-01-04
2,795 reads
I have often needed a means to send zipped files via email. This article shows one method to do just this.
2010-01-01 (first published: 2008-09-22)
38,599 reads
The first day of 2010 has Steve Jones blooper reel in addition to some well wishes.
2010-01-01
2,406 reads
The first day of 2010 has Steve Jones blooper reel in addition to some well wishes.
2010-01-01
2,190 reads
In his continuing quest to bring a deeper understanding of Query Optimizer to the world at large, Fabiano Amorim takes a moment to point out a potential pitfall you may encounter. A light read, but one worth persuing.
2010-01-01
3,379 reads
My tips for cluster installation with Windows 2008 and SQL 2008 on a 64 BIT server which is clustered.
2009-12-31
7,638 reads
The end of another year has an early Friday poll this week from Steve Jones. What are you looking to do in 2010?
2009-12-31
2,062 reads
The end of another year has an early Friday poll this week from Steve Jones. What are you looking to do in 2010?
2009-12-31
2,194 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Comments posted to this topic are about the item 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