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.
2009-11-23
9,562 reads
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.
2009-11-23
1,893 reads
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.
2009-11-23
718 reads
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.
2009-11-23
874 reads
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.
2009-11-23
1,074 reads
Not all DBAs have the opportunity to attend formal classroom training or attend conferences. While there are many SQL Server...
2009-11-23
841 reads
A colleague of mine who is getting to grips with SQL Server had an issue after creating and implementing a...
2009-11-23
1,829 reads
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.
2009-11-23
4,186 reads
Some useful undocumented extended and stored procedures in SQL Server 2005
2009-11-20 (first published: 2008-05-09)
33,450 reads
or our first feature on working DBAs and their lives, we selected Grant Fritchey, the self-styled Scary DBA, who has been so successful in the past year with his books and presentations. How does he manage to pack so much into his life? We sent Richard Morris to find out.
2009-11-20
3,936 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Comments posted to this topic are about the item Creating JSON III
Comments posted to this topic are about the item Testing is Becoming More Important
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers