SQL Server: Daily Failed SQL Job Email Report
This guide sets up: Database Mail a Database Mail profile a stored procedure that emails failed SQL Agent jobs from the last 24 hours a SQL Agent job…
Category
Databases
33 articles in this category
ManageEngine ServiceDeskPlus MSP: Change Starting Request ID (Postgres)
The procedure to change the request ID for ServiceDeskPlus MSP product (v10.5 and later) is outlined below. Navigate to the location of ServiceDeskPlus MSP installation and change into…
ServiceDesk Plus MSP 10.5 Postgre SQL password
The latest release of ManageEngine ServiceDesk Plus MSP changes the default user and password of the Postgres SQL database. Previously, the command to connect to the database was:…
WordPress SQLite to MySQL Migration Complete
Just finished migrating my website from SQLite to MySQL. What a rush. (lol) It was actually not as bad as I thought. A lot of sed, grep and…
400 Million Records in MySQL
So I'm trying to figure out a way to make searching a VARCHAR in MySQL fast when there are 400 million rows. I tried the UNIQUE approach using…
SQL2008R2 Licensing Quick Reference updated (PDF)
SQL2008R2_LicensingQuickReference-updated
SQL Server 2016 SP1 Edition Limit Changes
Microsoft made the following changes in their documentation (see screenshot above) to accurately reflect the memory limits on lower editions of SQL Server. Edition Information: https://www.microsoft.com/en-us/sql-server/sql-server-editions Estimate Memory Requirements for…
Change WordPress Password using MySQL
If the Forgot password option doesn't work for you (which it really should), then you can change the password of your self-hosted WordPress login. Check the contents of…
Calculate Date Differences in MySQL
There is a function in MySQL that will calculate the number of days between two given dates: datediff Example mysql> select datediff('2014-06-09','2014-07-07'); +----------------------------------------------+ | datediff('2014-06-09','2014-07-07') | +----------------------------------------------+ |…
MSSQL Find Last Date & Time Database Table Accessed
This is a T-SQL that will show all the last access date and time for Select, tables in a database.
MSSQL Server Uptime Using T-SQL
A sample T-SQL for determining uptime of a Microsoft SQL Server.
Determine a MySQL Database Creation Date
Here’s a simple way to determine the date/time a database was created in MySQL: SELECT create_time FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'DB_NAME' mysql> select create_time from information_schema.tables where…
MySQL Check For Fragmentation
I was working with a mail archive MySQL database today and was twiddling my thumbs waiting for simple queries to complete. The database has about 12 million rows…
Monitor SQL Performance
Here is a list of Windows' performance counters to use in monitoring performance of an SQL server. Create Performance Collection rules targeted to a SQL Server computer group…
SQL Server: Find Highest Wait on Server
From Paul Randal's survey of highest wait on server TSQL. WITH Waits AS (SELECT wait_type, wait_time_ms / 1000.0 AS WaitS, (wait_time_ms - signal_wait_time_ms) / 1000.0 AS ResourceS,…