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', […]

2003-03-13

298 reads

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. […]

2003-02-13

341 reads

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 […]

2002-11-30

1,241 reads

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 […]

2002-11-21

512 reads

Blogs

Daily Coping 2 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting

By

Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...

MVP for Another Year 2020-2021

By

Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...

Read the latest Blogs

Forums

Unusual use of the WHERE clause

By michael.leach2015

I am working an exercise problem where the solution provided has a WHERE clause...

How to get the SSAS Server administrators in MDX query?

By sabarishbabu

Hello, Is there any way to get the list of server administrators from SSAS...

Upgrading from SQL Server 2012 to SQL Server 2017 - Any Tips or Gotchas

By HookSQLDBA7

We are running SQL Server 2012 SP4 Standard Edition on Windows Server 2012 R2...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers