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...
Standard Members
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...
Counting Characters Using Only SQL
Counting Characters Using Only SQL by Craig Mullins If you write SQL on a regular basis, it is very important to know the functions that are supported by your DBMS. For DB2, there are three types of built-in functions that can be used to transform data in your tables: Aggregate functions, sometimes referred to as column functions, compute, from a...