Posted in Admin

SQLDepository Database – Download

Download SQLDepository Database(Remove .txt extension and unzip the file):

Continue Reading... SQLDepository Database – Download
Posted in Admin

New Development in SQL Server 2019 – Scalar Functions

Download SQLDepository Database: http://sqldepository.com/sqldepository-database/

Continue Reading... New Development in SQL Server 2019 – Scalar Functions
Posted in Admin

MySQL Administration – day 8

slow query log, general log and blocking, Performance tuning, MySQL

Continue Reading... MySQL Administration – day 8
Posted in Admin

MySQL Administration – Day 7

Users in MySQL.

Continue Reading... MySQL Administration – Day 7
Posted in Admin

MySQL Administration – Day 6

Point in time recovery in MySQL using bin log

Continue Reading... MySQL Administration – Day 6
Posted in Admin

HTML Tables in an email body using database mails

SQL Server alerts: Send SQL query output as HTML table in an email body using database mail.

Continue Reading... HTML Tables in an email body using database mails