Undocumented SQL Server 2012 log shipping stored procedures In this article, I want to describe the following six undocumented log shipping stored procedures shipped with SQL Server 2012: sp_add_log_shipping_monitor_jobs sp_check_log_shipping_monitor_alert sp_create_log_shipping_monitor_account sp_delete_log_shipping_monitor_info sp_delete_log_shipping_monitor_jobs sp_log_shipping_get_date_from_file sp_add_log_shipping_monitor_jobs The sp_add_log_shipping_monitor_jobs log shipping stored procedure is used to add ‘Log Shipping Alert Job – Backup’ and ‘Log Shipping Alert Job – Restore’ jobs. Syntax...
Pro Members
Developing Report Models – (Part 1)
Developing Report Models – (Part 1) Author: Basit A. Farooq A report model is a metadata description of a data source. It contains a business model of a data, a physical model of the underlying database, and a mapping between the two. The business model, also known as a semantic model, describes the data by using familiar business names, usually...
Undocumented SQL Server 2012 Database Engine Stored Procedures
Undocumented SQL Server 2012 Database Engine Stored Procedures SQL Server 2012 supports the following useful undocumented database engine stored procedures: sp_bcp_dbcmptlevel sp_MSforeachdb sp_MSforeachtable sp_MSindexspace sp_MStablespace sp_objectfilegroup sp_oledb_defdb sp_oledb_deflang sp_oledb_language sp_who2 sp_bcp_dbcmptlevel The sp_bcp_dbcmptlevel database engine stored procedure is used to get the database compatibility level for the specified database. Syntax sp_bcp_dbcmptlevel [ @dbname = ] ‘dbname’ Arguments [ @dbname =...
How to capitalize on your GENIUS
How to capitalize on your GENIUS Hello, this is Laura Lee Rose. I am a speaker and author. My background is in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time to learn...
Create an Email Notification Template
Create an Email notification template: Now, putting it all together; we want to send out informative consistent email alerts to reduce the amount time needed to correct on-call issues. Using the information you have previously gathered for each job we will create an email that matches the Sample Email Template defined below. Sample Email Template: From: [DB Mail Account] To:...
Undocumented SQL Server 2012 Security Stored Procedures
Undocumented SQL Server 2012 Security Stored Procedures SQL Server 2012 supports the following six undocumented security system stored procedures: sp_MSdbuseraccess sp_MSdbuserpriv sp_MSchangeobjectowner sp_MSGetServerProperties sp_MSloginmappings sp_MSSetServerProperties sp_MSdbuseraccess The sp_MSdbuseraccess system stored procedure is used to check what kind of access the current user has in the specified database or in all databases. Syntax sp_MSdbuseraccess [ @mode = ] ‘mode’, [ @qual...
Guidelines for Multilingual Web Design
Guidelines for Multilingual Web Design Globalization and multiculturalism have redefined online marketing. Consequently, Web design as such must also keep up with the requirements of the present-day multicultural and multilingual reality of business dealings. Before starting to create or adjust your Website to meet the expectations of users from all over the world, take into consideration the main tenets of...
How to Manage a Difficult Partner
How to Manage a Difficult Partner Hello, this is Laura Lee Rose. I am a speaker and author. My background is in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time to learn...
Directing emails/alerts to the person/group who can diagnose the issue
Directing emails/alerts to the person/group who can diagnose the issue We need to determine which team should be contacted first if a given job (or job step in some cases) fails! A lot of times when there is an error in the middle of the night, the chances are that the DBA did not author the failing process and therefore...
Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 2)
Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 2) Author: Basit A. Farooq Editor’s Note: In the first of this three part article series, I discussed the considerations for creating reports. In this part, I will talk about the guidelines and best practices for implementing data sources and report layouts. Guidelines...