What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0.
2001-08-09
1,435 reads
This is a great administrative reference for anyone using SQL Server 2000.
2001-08-08
3,286 reads
Sometimes as hard as you look you just can't find the answer or idea you're looking for - that's when a good discussion forum comes in handy! Read this article for some tips and tricks on using our discussion forums successfully. Then when you have time, browse our current discussions and see if they work.
2001-08-07
2,299 reads
Sometimes it is necessary to save binary data such as zip files, pictures or office documents into the database. This article looks at a way of using Java to perform this task.
2001-08-07
8,761 reads
This article will demonstrate how to monitor active spids, blocked by spids,cpu,I/O,cmds and app name being issued in a real time fashion by using the cmd shell calling a T-SQL script and a resource kit utility.
2001-08-07
49 reads
2001-08-06
3,770 reads
Read this article to learn how to use recursion to simply the task of creating multiple levels of folders on disk. Perfect for creating a folder hierarchy for holding backup files!
2001-08-03
13,009 reads
SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition.
2001-08-03
3,578 reads
A look at Index Statistics in SQL Server 7.0 and how to maintain them.
2001-08-02
3,264 reads
In this article, Brian Knight shows you the different ways to load data in DTS and how to optimize the Data Pump task for data loads. He also examines performance numbers on other data loading tasks in DTS.
2001-08-02
7,484 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