Additional Articles

Retrieving SQL Server Fixed Database Roles for Disaster Recovery

by Additional Articles

MSSQLTips.com

Database Roles

We ran into a case recently where we had the logins and users scripted out on my SQL Server instances, but we didn't have the fixed database roles for a critical database. As a result, our recovery efforts were only partially successful. We ended up trying to figure out what the database role memberships were for that database we recovered but we'd like not to be in that situation again. Is there an easy way to do this?

2011-02-23

3,104 reads

Streamlining granular recovery for SharePoint, with Red Gate and Metalogix

by Additional Articles

Other

Backup and restore

We have recently found an elegant way to reduce the time, and disk space required for SharePoint administrators who need to perform granular recovery operations out of their SQL Server backup files. I used to get customer calls that would go something like this:

2011-02-23

2,185 reads

How to Communicate Between SSBS Applications Across Instances

by Additional Articles

Database Journal

Service Broker (SSSB)

Arshad Ali demonstrates how to verify the SQL Server Service Broker (SSBS) configuration when both the Initiator and Target are in different SQL Server instances, how to communicate between them and how to monitor the conversation.

2011-02-22

2,249 reads

Understanding SQL Server 2008 R2 Fixed Database Level Roles

by Additional Articles

MSSQLTips.com

SQL Server 2008 R2

To easily manage the permissions in SQL Server databases, Microsoft has provided several roles in SQL Server which are security principals that group other principals.

2011-02-21

3,665 reads

Column-Level Encryption in SQL Server

by Additional Articles

Database Journal

Encryption

Beginning with SQL Server 2005, column-level encryption and decryption capabilities were made available within the database, providing a solution for situations where one-off types of data need to be secured beyond your existing authorization, authentication or firewall settings. This article provides an overview and example of securing a column using native SQL Server cryptography functions.

2011-02-18

4,894 reads

Using SQL Server Integration Services and StreamInsight Together

by Additional Articles

SQLCAT

Integration Services (SSIS)

The purpose of this paper is to provide guidance
for enriching data integration scenarios by integrating StreamInsight with SQL
Server Integration Services. Specifically, we looked at the technical challenges
and solutions for such integration, by using a case study based on a customer
scenarios in the telecommunications sector.

2011-02-17

2,719 reads

Working with SQL Server Profiler Trace Files

by Additional Articles

MSSQLTips.com

trace files

In a previous tip we looked at the steps to Create a Trace Template in Profiler. In this tip we will look at a few more tips such as creating a trace template from an existing trace file and saving a trace file to a SQL Server table.

2011-02-16

4,352 reads

SQL Server: Natural Key Versus Surrogate Key

by Additional Articles

Database Journal

Database Design

When designing a database to support applications you need to consider how you are going to handle primary keys. This article explores natural and surrogate keys, and discusses the pros and cons of each, allowing you to determine what makes the best sense in your environment when you are designing your databases.

2011-02-15

5,434 reads

Avoid External Dependencies in SQL Server Triggers

by Additional Articles

MSSQLTips.com

Triggers

I sometimes want to perform auditing or other actions in a trigger based on some criteria. More specifically, there are a few cases that may warrant an e-mail; for example, if a web sale takes place that requires custom or overnight shipping and handling. It is tempting to just add code to the trigger that sends an e-mail when these criteria are met. But this can be problematic for two reasons: (1) your users are waiting for that processing to occur, and (2) if you can't send the e-mail, how do you decide whether or not to roll back the transaction, and how do you bring the problem to the attention of the administrator?

2011-02-14

2,819 reads