Call That a Database? This is a Database.
If only the English language had a range of words to describe all the different types of database, there would be so much less confusion in the industry.
How to join a local table to a remote table by way of a linked server
Distributed queries on linked servers are not the greatest idea from a performance standpoint, but they can be quite useful.
The Power of Hadoop
Hadoop is an open source framework for working with data, and one that Microsoft has adopted. Is it worth using in your environment? Steve Jones thinks you should investigate it.
Point in Time Recovery Using New Timeline Feature in SQL Server 2012
SQL Server backups are key to recovering from a disaster or some type of data failure, but the real magic happens when the backup is restored. In this tip we look at a new enhancment in SQL Server 2012 for point in time recovery using the new timeline feature.
SQL Saturday #109 - Silicon Valley
Come to a free day of training on Mar 3, 2012 in Mountain View, CA
SQL Saturday #123 - Western Cape
Come to a free day of SQL training on Mar 3 in Tyger Valle, Western Cape in South Africa.
A Break from Databases
A Friday poll that's a break from work, and should be a bit of fun. Today Steve Jones asks about movies, and what's been interesting from the last year.
Using SSIS to Maintain the File System
Integration Services is one of the more flexible tools available on the SQL Server platform. Jason Brimhall shows us a way to remove old files, either backups or flat files, after a configurable period of time.
SSAS - Best Practices and Performance Optimization
There are several aspects that can take a toll on performance for your Analysis Services cubes. Some problems could be related to the source systems, some could be because of poor design of your cube and MDX queries and some could be related to network issues.
Future Virtual Machines
What's the benefit of virtual machines and hypervisors? Steve Jones has a few comments on them and their future.
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
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