When you need to insert a large set of data using T-SQL, what can you do? New author Melinda Sansone brings us a best practice when using T-SQL to load data for data marts, or warehouses.
Brad suggests some tips on how to maximize your professional development in 2010. Get a plan together now, and you'll make your life a lot easier.
Windows Azure and Azure Storage offers a new scalable and robust architecture that borrows much from the common feel of ASP.NET applications but brings plenty of new features as well. This paradigm shift from what has become traditional client-server architecture will offer new options to developers and headaches alike. While "the cloud" is not intended to be the answer for all applications and situations, it can only be a potential answer (another "tool" in the proverbial "tool belt") if you have at minimum a general understanding.
When you have a team of people working together to manage systems, communication becomes important. Steve Jones notes that a lack of working with each other and letting the rest of the team know what you are doing can cause unnecessary work for others.
When you have a team of people working together to manage systems, communication becomes important. Steve Jones notes that a lack of working with each other and letting the rest of the team know what you are doing can cause unnecessary work for others.
When you have a team of people working together to manage systems, communication becomes important. Steve Jones notes that a lack of working with each other and letting the rest of the team know what you are doing can cause unnecessary work for others.
Not all DBAs have the opportunity to attend formal classroom training or attend conferences. While there are many SQL Server...
A colleague of mine who is getting to grips with SQL Server had an issue after creating and implementing a...
The Transaction Log provides the means by which either the complete set of tasks of a database transaction are performed or none of them are. It ensures that , via rollback, only valid data is written out to the database, and it allows transactions to be played back to recreate the system state right before a failure. Robert Sheldon explains the various basic tasks involved in managing the transaction log.
Would you like to have only SQL Server Authentication on your instances? That's the subject of this Friday's poll.
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
I’ve been learning more about the google knowledge panel and it seems like one...
I’m currently researching the best wireless credit card terminal for a growing business and...
Comments posted to this topic are about the item Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers