Part 11 of this series presented the publishing options of ClickOnce-capable applications that involve User Instance-based databases. This article takes a closer look at the deployment process, demonstrating the impact of your selections on its characteristics.
Buck Woody examines examines some of the decisions you'll need to make when embarking on your DBA career, and some the character traits and skills that will help you succeed and progress.
What makes a good manager? In response to a recent thread, Janet Wong takes us through some of the good and bad managers she's had during her career and talks about the problems today with technical managers.
Now that you know how to speed up your SQL Server database queries, you can start delving into some of the more advanced tuning options.
If you are near Texas Christian University, you might want to check out this training from a SQL Server MVP.
Test data is critical to being sure your application works, but is production data ok to use in test environments?
Being a part of the community means that there are certain standards that we'd like you to adhere to. Steve Jones brings you a few reminders of how to behave when posting in the community.
Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.
This is the third article that deals with analyzing the various possibilities involving various RAID setups and differing numbers of hard drives. We used the same hard disks again here: eight Samsung HM321KJ SATA/300 drives powered all of the possible RAID 0, RAID 5 and RAID 6 setups, with from three to as many as eight hard drives configured to use stripe sizes of 4 to 128 kB.
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
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...
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