Properly sizing your SQL Server hardware and testing application loads against them is a complex and difficult topic. Anthony Bressi brings us a great new article that gives you a systematic approach to performing your own stress test.
This tip shows you how to execute and use the results of prediction queries in multiple ways within the SQL Server relational database engine.
Optional parameters are easily handled with NULL values in T-SQL, but there are cases where this doesn't always work. Alex Grinberg brings us a new technique to allow your stored procedures to be structured to deal with this situation without dynamic SQL.
Red Gate Software is releasing a low-cost version of its best-selling SQL Backup tool that makes data protection for small businesses fast and simple.
Microsoft has come to the rescue for managing large text fields in SQL Server 2005, by creating a few new large value data types. This article explores these new data types.
In the second of a series of articles that targets the DBA new to an organization, this article looks at how to manage DTS packages.
In Part 1 of this article, we looked at the basics of SQL Server Reporting Services 2005 (SSRS). We built one report with the Report Wizard, and one report using the Report Designer. In Part 2, we are going to look in more depth at the features that you can use everyday as an SSRS developer.
This video by Richard Waymire will describe how to install and configure SQL Server 2005 to support Visual Studio Team Edition for Database Professionals database projects.
There are so many new features in SQL Server 2005 that there's one that can make a significant impact in solving many different types of problems. Andy Warren takes a look at one of the features that has been enhanced and is extremely useful, albeit quirky: TOP.
Is your company trying to accelerate cycle times, lower costs, improve responsiveness, ensure compliance with policies and best practices, and increase customer satisfaction? Well, of course! That's why you need a comprehensive approach to managing your organization's business rules
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers