SQL Server Restart or Cluster Failover Notification
How to create an automatic SQL restart or failover notification.
2018-06-22 (first published: 2015-12-10)
7,717 reads
notification
Disk Free Space Check
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2019-05-03 (first published: 2015-06-03)
1,535 reads
Disk Free Space Check
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2015-06-03
313 reads
Email SP Results
Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.
2016-12-05 (first published: 2015-05-29)
2,741 reads
Introducing Boomerang - A Notification Framework
Boomerang is a notification framework for IT professionals providing service oriented infrastructure with a SQL based rapid development interface.
2013-01-10
2,318 reads
Bringing Alerts and Operators together with Notifications
FatherJack shows you how to check that your alerts and notifications are linked up so that when an Alert condition is met that you get the appropriate Notifications sent to Operators.
2011-12-05
2,306 reads
RE: WARNING: Failed to reserve contiguous memory of Size= Can anyone help?
We ran into this on a 4-way machine running win2k and sql2k. MS recommended that we have use the '-g 384' switch for SQL Server startup. That reserves more space for COM objects and extended stored procedures.We ended up having to increase to '-g 512'. But the problem has not reoccurred since then.
2004-08-25
RE: Convert table into a crosstab table in SQL Server
Nivedita: This query does work. Thanks for your help.
2004-07-21
RE: How to work with result set from exec in a stored procedure?
You need all of them.If you don't know what the structure is i.e. is notify_level_eventlog an int, smallint, byte it doesn't matter because SQL is intelligent enough to do an implicit cast provided that the data will fit in the datatype chosen for your specific table.i.e. an int holding 32767 will fit into a smallint […]
2004-07-20
RE: variable column alias
SET DATEFIRST 7 --Set First Day of Week to Sunday SELECT SUM(CASE WHEN DATEPART(weekday,[date]) = 1 THEN [column] ELSE 0 END) AS 'Sun', SUM(CASE WHEN DATEPART(weekday,[date]) = 2 THEN [column] ELSE 0 END) AS 'Mon', SUM(CASE WHEN DATEPART(weekday,[date]) = 3 THEN [column] ELSE 0 END) AS 'Tue', SUM(CASE WHEN DATEPART(weekday,[date]) = 4 THEN [column] ELSE 0 […]
2004-07-20
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers