Inserting and updating table contents with data from other tables and/or views within the same database need not be a nail-biting ordeal. Rob Gravelle shares some common Insert and Update tasks to help avoid any problems.
2015-09-25
2,820 reads
OpenStack holds a great deal of promise as a cloud platform built on open standards, and has support from the major players in cloud services. It has the potential for allowing organisations to set up their own private cloud services that are designed to inter-operate. Is it ready yet for companies that want the convenience of cloud solutions, but with more control, and without the large subscription fees? Robert Sheldon finds out.
2015-09-24
4,857 reads
Koen Verbeeck shows how to easily extract metadata from files in your directories with Power Query.
2015-09-23
3,175 reads
Redgate’s Database Lifecycle Management solution ensures database changes made in development environments are always tested and reviewed before being deployed, and adds automation to the process. Find out how by joining Steve Jones, MVP and editor of SQLServerCentral, as he demonstrates the solution and shows why such an approach is essential if you want to release changes frequently.
2015-09-22 (first published: 2015-08-11)
8,420 reads
This article from Paul White examines some surprising behaviour of INSTEAD OF triggers and reveals a serious cardinality estimation bug in SQL Server 2014.
2015-09-22
3,472 reads
New version of the Free Baseline Collector Solution released. Do you collect baseline data? If not, let's start doing it!
2015-09-21
5,627 reads
References and links about the Stretch to Azure feature in SQL Server 2016.
2015-09-21
1,379 reads
Want to 'trick' SQL Server into performing millions of logical reads to return data, when only are few thousand were really required? In this article, Gail Shaw examines three common forms of generic SQL that can and will confuse the SQL Server Optimizer to the point that it generates and reuses very inefficient execution plans.
2015-09-21
3,875 reads
Learn how to develop and test a template for logging and error handling in a multi-step SQL stored procedure
2015-09-18 (first published: 2014-01-20)
39,217 reads
Before SQL Server had SQL window functions, SQL Server developers had to use all manner of tricks and algorithms to come up with ways to rapidly process large amounts of data. Do we need these techniques now that we can express a SQL task in terms of window functions? Kathi revisits a famous SQL challenge to find out.
2015-09-18
4,213 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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