The 2010 SQLServerCentral Opening Night Party
SQLServerCentral is hosting an opening night party at the 2010 PASS Summit. Read more about this and learn how to get a ticket.
2010-10-26 (first published: 2010-05-13)
4,052 reads
Articles
Working with null values in SQL XML
We all know NULL values must be dealt with carefully in T-SQL, but how exactly do you best deal with them in SQL XML?
2010-10-26
27,634 reads
Top 10 Mistakes When Building and Maintaining a Database
Building and maintain a SQL Server database environment takes a lot of work. There are many things to consider when you are designing, supporting and troubleshooting your environment. This article identifies a top ten list of mistakes, or things that sometimes are overlooked when supporting a database environment.
2010-10-26
7,946 reads
Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods
This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.
2010-10-25
14,031 reads
End of October Free Training from PASS Virtual Chapters
This wraps up the last of the free training the PASS Virtual Chapters are providing in October.
2010-10-25
911 reads
SQLServerCentral Webinar Series #3: Optimize your SQL Server storage with SQL Storage Compress
Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.
2010-10-25 (first published: 2010-10-18)
1,935 reads
Introducing ADO.NET Entity Framework
The challenge of bringing data from efficient storage engines such as SQL Server into object-oriented programming models is hardly a new one. Most developers address this challenge by writing complex data access code to move data between their applications and the database. This requires an understanding of the database so that you can access data either from the raw tables, from views, or from stored procedures.
2010-10-25
3,289 reads
Sending multiple rows to the Database from an Application: Part II
In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.
2010-10-22 (first published: 2009-08-25)
18,622 reads
Investigating Transactions Using Dynamic Management Objects
There can be a great difference in the performance of a particular routine in a test database, and in a fully loaded production system. When you hit performance problems in a database under load, and there is excessive locking and blocking, how can you determine exactly where the problems lie, in order to fix them?
2010-10-22
3,228 reads
Notifications for SQL Server Agent Restarts
This article demostrates how to set up email notifications for SQL Server Agent Restarts.
2010-10-21
1,926 reads
Blogs
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...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
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?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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