Microsoft SQL Server 2000 Notification Services is the premier platform for developing and deploying a new class of scalable Web applications that deliver personalized, timely information updates to a variety of mobile devices. Review the resources on this page for details.
2002-09-18
3,314 reads
This program makes it easy to add and maintain extended properties for all objects in SQL Server 2000. Where as the Query Analyzer only allows you to maintain certain object SEPE allows all object to be maintained. This product is freeware for SQLServerCentral.com members.
2002-09-13
424 reads
SQL Server 2000 Enterprise Edition clocked an incredible 308,620 transactions per minute (tpmC)1 running on Windows .NET Server 2003, Datacenter Edition on an NEC TX7 server with 32 Intel Itanium 2 processors. The NEC system sets a new performance record on Windows, nearly doubling the best published 32-bit result. In addition, this Microsoft/Intel/NEC solution delivers the best price-performance of all results on the Top Ten performance list, at just $14.96/tpmC.
2002-09-12
3,369 reads
NGSSoftware have released NGSSQuirreL, a security audit and management tool for SQL Server. Designed to ease the administrative burden of securing SQL Server, NGSSQuirreL finds the security holes then generates a lockdown script based upon the vulnerabilities found so the server can be secured in a matter of minutes; and regular audits can help keep it that way. For more information or an evaluation copy please see the NGSSite - http://www.nextgenss.com/.
2002-09-11
464 reads
An interesting research paper by David Litchfield on how an attacker might go about attacking your server. Definitely worth a read.
2002-09-06
532 reads
This article discusses the advantages and disadvantages of using the SQL Server graphical administration tools (Enterprise Manager) versus the T-SQL administrative commands, with specific examples. Read up and decide for yourself, if you want to be a point-and-click DBA or a T-SQL scripting expert!
2002-09-04
781 reads
Liberty Beta 2 will incorporate all the updates of SQL Server’s Service Pack 3. Furthermore, Liberty Beta 2 will be optimized for the newest addition to Intel’s Itanium® Processor Family, the Itanium® 2 processor. This beta is scheduled to start in late September.
Note: Liberty requires 64-bit hardware with an Intel’s Itanium® or Itanium® 2 processor and will not run on standard 32-bit machines.
2002-08-29
40 reads
A list of tips that should make your code more secure. Note that SQL Server is mentioned in a few places, especially # 4
2002-08-28
1,230 reads
Incepto Ltd. announced the availability of SQL-UP! version 1.3, distributed SQL Server Cluster. SQL-UP! clusters SQL Server databases over LAN or WAN, with no shared storage device.
The software provides business continuity and complete disaster protection for business-critical databases. The new version adds support for online database schema changes, inter-domain clusters and high transaction load.
2002-08-23
50 reads
Proc-Blaster 2.32 has been released with much faster loading time, improved help file, new templates and more. Proc-Blaster is a RAD Code Generator for SQL Server.
2002-08-22
64 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