One of the fundamental skills a developer needs is the ability to test their code. Most people don't really do a good job, partly because they don't have a good process and leave testing until the end. Grant Fritchey brings us a new method of unit testing T-SQL stored procedures that can help you build automated tests for your code.
You can build very powerful and flexible text-formatting solutions in SQL Server. Learn how to apply techniques that handle the simplest to the more complex text-formatting tasks.
How do you go about looking for someone to fill a DBA position? SQL Server guru and head of the Colorado Springs PASS Chapter, Chris Shaw, brings us a look at how an experienced manager goes about filling DBA positions.
Automating the installation of SQL Server was made simple in SQL Server 2005. SQL Server 2005 can be installed using a GUI, an ini file or just run setup.exe with a bunch of parameters.
This article, the last in the Stored Procedure series, will focus on RETURN parameters.
Over the last year we've taken a look at a number of people influential in the SQL Server community. This time Steve Jones spent a little time interviewing noted trainer and author Bob Beauchemin.
s running .NET Framework code within SQL Server 2005 exciting or a threat? Which is it? This article explores the security issues of SQLCLR code so that both developers and DBAs can make informed decisions about its use.
Make a little extra money and find a contract job through our partnership with HohGigs.
Differential backups are left out of many DBAs backup strategy, but they are a great tool to shrink your backup window, save disk space, and more. However they can be slightly tricky when you look to perform a restore. New author Qian Ye brings us an interesting issue that occured during differential testing.
SQL Server 2005 comes with a built-in answer to this problem: the Database Engine Tuning Advisor. Combining a simple user interface with a deep knowledge of SQL Server, this utility can help you tune your databases for peak performance.
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...
A while back I wrote a quick post on setting up key mappings in...
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
Comments posted to this topic are about the item Testing is Becoming More Important
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