You need a SQL Server-based application that will work with huge amounts of data and must perform calculations of startling complexity. How far will you go to deliver the required performance?
2014-01-06
174 reads
What often starts out as a simple, quick process, gradually expands over time, as developers use SQL Agent to schedule new data feeds, add more complex transformations...
2013-10-28
228 reads
We know a lot about how great exponents of the DBA profession work, but the role is changing rapidly. What makes a great Data Scientist? Or a great BI specialist?
2013-06-24
284 reads
While backup to the Cloud may be useful in terms of optimizing storage across the enterprise, for DBAs it remains essential that they retain fast, easy, access to the backup files. Azure Explorer is a free tool that might help.
2013-04-29
76 reads
Is there a sound technical reason why SQL Azure can't support extended properties?
2013-02-25
174 reads
It is late evening. Something is wrong with a database. You narrow down the possibilities, getting more frustrated and puzzled. Stay calm. Check the inputs systematically. No! The data going into that table is right, but when you then read it in the table, it's wrong. Why did I stop believing in the supernatural? Then it hits you. Every time it comes as a surprise. They're using triggers. (This editorial was originally published on Nov 10, 2008)
2013-02-19 (first published: 2008-11-10)
627 reads
It is easy to become overwhelmed by server symptoms (aka metrics), in the forlorn hope that the more we collect, the clearer a picture we'll assemble of what ails the server. We should, of course, be looking at the whole patient.
2013-02-04
141 reads
Tony Davis argues that the Standards and best practices exist to avoid being hacked, but implementing them requires time and investment and often there simply doesn't seem to be the will to do it.
2012-11-26
116 reads
Index fragmentation can certainly cause performance problems, but should it really dictate the way we design our clustered indexes?
2012-10-01
393 reads
Tony Davis argues that the WITH REPLACE option of the RESTORE DATABASE command is a case where the naming of the option masks its true "JFDI" nature…
2012-04-02
153 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