Technical Article

Weekly Reports Made Easy

Each week you are required to run various reports based on table entries made during the week preceding latest Sunday. Use this SQL7/2000 procedure (can be a UDF in SQL2K) to retrieve the latest midnight of a specified day of the week as illustrated below: Declare @StartDate datetime, @EndDate datetime Exec DBAservice.dbo.uspGetLatestWkDayMidnight @pDate = '1998-05-06', […]

You rated this post out of 5. Change rating

2003-03-13

308 reads

Technical Article

Rename SQL Server

Utilizing sp_dropserver and sp_addserver system procedures we will change local SQL Server name to a specified one, or, by default, to the WINS machine name. Just another utility in my DBAservice toolbox database.Notes:1.Tested in SQL Server7.2. In some cases it is necessary to rerun sql server setup in order to start the server after renaming. […]

You rated this post out of 5. Change rating

2003-02-13

363 reads

Technical Article

Check user activity

This stored procedure is another monitoring utility that can be executed periodically as a sql server agent job. The procedure checks if there are any open connections, and if there was any recent user activity within a given period of time in a given (or any) database by a given (or any/any except given) login […]

You rated this post out of 5. Change rating

2002-11-30

1,274 reads

Technical Article

Monitoring SQL Server downtime

The following script creates a monitoring utility to find out for how long a sql server was down prior to the latest startup. The script creates one table (tblHeartbeat), four stored procedures (uspFillHeartBeat, uspGetDowntimeSummary, uspCleanHeartbeat, uspAtStartup) and two jobs (FillHeartbeat and CleanHeartbeat).Notes:1. By convention I introduced in my company (UGO Networks, Inc.) all "service" database […]

You rated this post out of 5. Change rating

2002-11-21

802 reads

Blogs

Another AI Faux Pax

By

I was experimenting with a local model (article) and as a part of this,...

Monday Monitor Tips: Using the PowerShell API

By

Redgate Monitor has grown tremendously from its early days and I find many customers...

Data Governance: The Invisible AI Accelerator

By

The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.

Read the latest Blogs

Forums

Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv

By SKEITA

SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure...

PK violation in replication but only one subscriber

By cphite

We have a publication with three subscribers; it's basically a part list with around...

Recovery Takes 10-20 mins with ADR enabled

By VastSQL

Hi Experts, I have database about 300GB in size with ADR enabled but after...

Visit the forum

Question of the Day

Data API Builder Operations

What types of database operations does the Data API Builder support?

See possible answers