SQLServerCentral.com launched it April contest on April 1st sponosored by Lockwood Tech and SQL Server Magazine. Win LockWood Tech's Proc-Blaster Enterprise Edition, SQL Server Magazine, or Admin911 all for helping to build the SQL Server community.
2002-04-01
23 reads
AdminLog, by Lockwood Tech, has been added to the SQLServerCentral.com freeware library. AdminLog is a utility for managing projects, tracking bugs/tasks/assignments, etc.
2002-03-29
24 reads
Learn how to make the most out of ADO.NET and SQL Server. Find out how the new .NET Data Provider can boost SQL Server performance.
2002-03-29
1,053 reads
Last year Andy wrote about turning off the log reader as a way to reduce the overhead on a server, primarily when you have many logreaders running. In this follow up article he talks about the downside of using this technique and how the behavior of the logreader can be "tweaked" to make using non-continuous replication a little less of a headache.
2002-03-28
5,155 reads
Object Scriptr v1.0 for SQL Server 7/2000 by Rac4sql has been released as freeware on SQLServerCentral.com. The product quickly generates creation and drop scripts and insert statements.
2002-03-28
44 reads
SQLServerCentral.com today launched its new members only product discount area. The section allows members to purchase SQL Server related products at a deep discount.
2002-03-27
23 reads
Microsoft .NET Framework Service Pack 1 provides the latest updates to the .NET Framework. Service Pack 1 is highly recommended for all users of the .NET Framework, including customers of Visual Studio .NET.
2002-03-27
3,235 reads
This article written by Don Church discusses how to optimize your cubes schema, its worth a read.
2002-03-26
9,229 reads
Find out how SQL Server 2000 surpassed its previous number one result for the SAP Sales and Distribution benchmark.
2002-03-22
3,242 reads
As I work with a particular topic or problem, I often research on the Internet different opinions, white papers, etc. Here is a list of resources that deal with the licensing aspects of using SQL Server.
2002-03-21
5,070 reads
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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