If you move a database from one server to another using backup\restore or detach/attach option then there is a chance of users become orphaned. Users logins mapping done by the SID and if there is a login present on the destination instance with same name but another SID then the user will not recognize and orphaned. Login mapping problem occurs only with SQL Logins when you move the database to...
Configuring Auditing in SQL Server 2012
The auditing session allows you to record events that occurring at server level or database level in file or in the windows event log. You can easily setup audit in SQL Server 2012 with Server Audit, define an audit and bind a specification that contains events to collect it. Database level auditing is only available in the Enterprise Edition. Follow the below steps to setup SQL Server Audit 1...
Microsoft Big Data Solution
What is Big Data? It is a popular term used to describe growth of structured and unstructured information. This post discusses the Trends driving the “Big Data†and Microsoft Big Data Solution. There are vendors in market which provide Hadoop deployments but most operate outside central IT operations. Microsoft Big Data solution can analyze over 100 petabytes of data to produce results...
Data Alerting in SQL Server 2012
You can create a data alert to email notification in SQL Server 2012 reporting services. This data alert sends e-mail notification when only when specific conditions in the data are true at a schedule time. This Date Alerting feature is available only when reporting services runs in sharepoint integration mode. It works only with reports that are designed using Report Designer or Report...
Tabular Modeling in SQL Server 2012
Tabular model is a new database structure in SQL Server 2012 Analysis Services. When you create tabular model project, SQL Server Developer Tools creates a Model.bim file to the project and creates workspace database in Analysis Services instance. Workspace database acts as a temporary storage for data when you develop a model in SSDT. Workspace Database Workspace Database stores the data...
Analysis Services Server Modes in SQL Server 2012
SQL Server 2005 and 2008 supports only one mode that is multidimensional mode, Where as SQL Server 2008 R2 supports additional mode PowerPivot for SharePoint. In SQL Server 2012 you have an option to deploy an analysis services instance in tabular mode. This post discusses the Analysis server modes and enhancements in SQL Server 2012. Server Modes Each server mode in SQL Server 2012 has...
SSIS Logging in SQL Server 2012
Enabling SSIS logging is a tedious process in earlier versions. Integration Services Packages has the two options to log the information during the execution, one option is configure the log providers in each package and associate them to executables within the package. Second option is to use SQL statements or script components to implement a custom logging solution. With the introduction...
Configuring SQL Server to listen a non-default port
SQL Server allows you to reassign the ports used by default instance or named instances. Using SQL Server Configuration Manager, you can reassign the TCP port. Your SQL Server environment is more secure when you change the default ports to a difference number.
Follow the below steps to configure the SQL Server Instance to listen a different port
Sorting Month Name in Date Dimension in SQL Server
In order to sort the month name in your date dimension, you need to define an attribute relationship and Sort Order in the Date Dimension. This post discusses about defining a new attribute in date dimension based on existing column in the underlying dimension table.
Step 1: Open the Date Dimension designer then switch to Attribute Relationships tab
Enabling Contained Databases in SQL Server 2012
Authentication mechanism to login to SQL Server database engine is either Windows authentication or SQL Server account. Sometimes you will face authentication issues with database portability, example when you migrate a database from one SQL Server instance to another SQL Server instance, DBA has to ensure that all logins in Source SQL Server instance is existed on the target SQL Server...