Report Alerts from SQL ErrorLog
Sends Back Critical Alerts from ErrorLog occurred in the last 24 Hrs. You can even modify the data [Check @start and change the value]
2019-05-03 (first published: 2015-05-15)
2,489 reads
SQl Hunt
- Interests: Like to make friendship with people.
Retrieving XML data to Table from dm_os_ring_buffers
Retrieving XML data to Table from dm_os_ring_buffers for better readable purpose
2019-05-03 (first published: 2015-08-03)
989 reads
Run a specific query across all servers using powershell
Run a specific query across all servers using powershell
2019-05-03 (first published: 2015-03-06)
3,260 reads
2019-05-03 (first published: 2010-12-15)
2,982 reads
Search a string in a text with number of occurrences
IF you have a long string and if you want to search a specific input string, and number of timeS the string has occurred then it's helps
2019-05-03 (first published: 2015-03-29)
1,421 reads
Send Email to recipients with Attachment using PowerShell
If you have a requirement to send email to recipients with attachment, can use the script.
2019-05-03 (first published: 2016-05-17)
3,142 reads
Setup Alerts for SQL Replication
If you want to monitor few specific alerts for SQL Replication (Merge and Transnational), you can may consider adding these 14 alerts.
2019-05-03 (first published: 2015-06-16)
1,482 reads
Shrink Tlog Files
DBA many a times need to shrink the log files if that grows very large. Though I am not recommending to do it daily or often but if space is an issue and you want to release space to OS, you may use the script.
2019-05-03 (first published: 2016-09-22)
930 reads
Simple script to list out SPID, Program_name and login details
If you have any requirement where you want to find out all the SPIDs running on a database along with the program/application name of the SPID and the login details. You can run the procedure to get the details very easily.
2019-05-03 (first published: 2014-06-30)
4,105 reads
Standardizing DBMAIL Profile & Account Setup for Notification
If you have a requirement to setup with a default global dbmail profile and account you can use my script.
2019-05-03 (first published: 2015-05-28)
1,077 reads
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers