SQL-DMO - Using the '2' Objects
In this short article Andy talks about the differences in DMO between SQL7 and SQL2K, why it matters, and when you should use the newer version of DMO that comes with SQL2K.
Book Review: SQL Server 2000 Resource Kit
This 1100 page book offers something for everyone. Using Blobs, Analysis Services, Replication, High Availability. 38 Chapters plus ebook and tools on the CD. Should you get it? Read our review of this book to find out!
SQL-DMO for Beginners
How many of you are VB programmers? How many of you have never worked with DMO? This is the article if you don't work with VB or DMO, but want to get started. One of the more powerful tools that you can add to your arsenal.
Upcoming SQL Server 2000 64-bit Beta Program
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.
Defend Your Code with Top Ten Security Tips Every Developer Must Know
A list of tips that should make your code more secure. Note that SQL Server is mentioned in a few places, especially # 4
DoEvents with SQL Server 2000 and Extended Procedures
In this article, we will leverage Extended Stored Procedures to extend the functionality of SQL Server and give a starting point to experiment with Extended Stored Procedures.
Review of Micrsoft ADO.Net Step by Step
Andy takes a look at another entry level book, this one on ADO.Net.
SQL-UP! version 1.3 now available
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.
VBScript Classes to Query SQL Server for Backup Information
A VBscript class is created that can be used to query the maintenance plans on an SQL server to determine when a backup has occurred. This class can be used with others to create a scripted method for monitoring backups.
Proc-Blaster Updated
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.
Blogs
Cost Visibility: Tracking and Analysing Your Cloud Spend
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
Whiling away an afternoon, thinking
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
Black Box vs. Gray Box vs. White Box Testing
By Brian Kelley
If your organization is spending money, then meaningful results are a must. Pen testing...
Forums
Fun with JSON II
Comments posted to this topic are about the item Fun with JSON II
Changing Data Types
Comments posted to this topic are about the item Changing Data Types
Answering Questions On Dropped Columns
Comments posted to this topic are about the item Answering Questions On Dropped Columns
Question of the Day
Fun with JSON II
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers