What is XML?
The use of XML is growing all the time and if you listen to the media, XML is a technology you cannot do without. New author Stephen Hirsch brings us a look at XML from more of a skeptic's point of view.
NET Application Architecture: the Data Access Layer
An in-depth, fully explained case study on how to design and create a data access layer for your .NET applications.
BlackBelt Administration: Linked Reports in SQL Server Management Stud
Create Linked Reports from within SQL Server Management Studio. BI Architect Bill Pearson examines another approach for using Linked Reports to provide multiple "versions" of a single-source report.
Performance Tuning Stored Procedures
Stored procedures are a great way to encapsulate code and reuse it in many places in your application. But when you have a performance issue, how do you know which part of the stored procedure is giving you problems? Steve Jones takes a look at a few techniques for diving into stored procedures and identifying problem areas.
SQL Server 2005 – Unattended installation – Part IV
In this section of this series, I am going to demonstrate how to install SQL Server 2005 Service Pack 1, to update the client components using command line options.
Using DDL Database Triggers
In this short demonstration, you'll learn how to use DDL database triggers to prevent changes to product and audit changes to comply with Sarbanes-Oxley and other change management requirements. Free registration required.
How many more Mondays until I retire?
Depending on your age, you may not want to know this number, but as you advance in your career, this might be a problem that you look to solve one day. Peter Larsson takes a few minutes to work out a function in T-SQL that can be used to solve this or any similar question.
SQL Prompt IntelliSense for SQL Server
Visual Studio developers have enjoyed the benefits of intellisense for some time, but us SQL Server users have had to work from memory. Wayne Fillis was so enthralled with a new offering from Red Gate he wrote a short review and sent it in. Check out his thoughts and how this product can help you.
Transform your SQL scripts with SQL Prettifier
This article describes the "beta" version of Simple-Talk's SQL formatting tool, SQL Prettifier. It provides links both to try it out online and to download the full source code (members only). Please give us your feedback! We will be offering prizes for any fixes and improvements that make it into "v1". I'd like this to become the de-facto (excuse the pun) tool for presenting code in the Simple-Talk articles, blogs and forums.
Analyzing Memory Requirements for SQL Server
The second in a series from Adindam Banerjee on server performance and capacity planning. This time Arindam takes a look at the memory requirements for SQL Server.
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Question of the Day
Creating a JSON Document I
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