Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
Database Tools
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
News Via RSS Feed

follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2

Database user and programming tips

Database User and Programming Tips

Reading and Searching a Large Error Log File 10/03/2016

SQL Server’s undocumented extended stored procedure, called “xp_readerrorlog”, can read both the SQL Server ERRORLOG and the SQL Agent log files. Read on to learn more.

Reading Backup History Information for a Database 10/03/2016

There are times when you might want to read backup/restore history information to identify a backup’s start and finish date/time, the location where the backup was written, the size of the database backup, etc. Greg Larsen shows you how to do this in SQL Server.

Managing SQL Server Backup and Restore History Information 09/01/2016

SQL Server provides a couple of different ways to delete backup and restore history.  If you want to remove backup and restore information for all databases based on a date you can use the sp_delete_backuphistory system stored procedure.  Or you can use the system stored procedure named sp_delete_database_backuphistory if you want to remove all backup and restore history for a specific database.

Masking Your Data with SQL Server 2016 09/01/2016

There are times when you want some users to see part of a column value but not the whole thing, but you want other users to see the complete column value without any masking. The new SQL Server 2016 Dynamic Data Masking feature will allow you to define these different kinds of masking rules.

Database User and Programming Tips Archives