Review of Micrsoft ADO.Net Step by Step
Andy takes a look at another entry level book, this one on ADO.Net.
2002-08-23
4,279 reads
Articles
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.
2002-08-23
50 reads
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.
2002-08-22
6,334 reads
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.
2002-08-22
64 reads
VB TV
What's VB.NET? Microsoft has launched a new learning platform called VBTV. Check it out if you are interested in VB at all.
2002-08-21
1,344 reads
Review: MSSQLCrack
A new SQL Authentication password cracker you should be aware of. It can crack your SQL passwords and give you an idea of how secure you are.
2002-08-20
18,038 reads
The Case for SQL Logins - Part Two
In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.
2002-08-19
6,812 reads
Upcoming SQL Server SP3 Beta Program
It’s almost time for the newest Service Pack for SQL Server 2000, and you don’t want to be caught unprepared for this one. In addition to the normal QFE fixes, the top service pack requests from our PSS organization and the latest security fixes, this service pack will be shipping with MDAC version 2.7 SP1. You’re going to want to be involved in this service pack beta! This beta is scheduled to start in mid to late September.
2002-08-19
3,325 reads
Beware to the System Generated Constraint Name
New columnist Gregory Larsen used to not care what his objects were called until recently when he began to become concerned with the system generated constraint names. This short article tells you why.
2002-08-16
7,141 reads
Interact with SQL Server's Data and Procedure Cache
This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.
2002-08-15
14,167 reads
Blogs
Extending a SQL Server Failover Cluster Across Regions in Google Cloud Platform (GCP)
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
Heading to 2024 PASS Summit
By Brian Kelley
I am able to head back to Seattle for the PASS Summit this year....
Tell me the positives of your solution
By Brian Kelley
I still have a tendency to talk about all the cons of a proposed...
Forums
The Cloud Security Problem
Comments posted to this topic are about the item The Cloud Security Problem
Virtualizing AWS data by using Fabric Shortcuts: Data Engineering with Fabric
Comments posted to this topic are about the item Virtualizing AWS data by using...
Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer
Comments posted to this topic are about the item Timescale Brings PostgreSQL into the...
Question of the Day
The LAGging NULL
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers