Articles

During weekend maintenance, members of the support team executed an UPDATE statement against the database on the OLTP Server. This database was a part of Transactional Replication, and once the UPDATE statement was executed the Replication procedure came to a halt with an error message. Satnam Singh decided to work on this case and try to find an efficient solution to rebuild the procedure without significant downtime.

2013-10-17

2,886 reads

Error during installation of an SQL server Failover Cluster Instance

by Additional Articles

Microsoft MSDN

Clustering

A common issue I've run into while helping with SQL Server Failover Cluster (FCI) installations is the failure of the Network Name. In the following post I'll discuss a bit of background, the common root cause, and how to resolve it.

2013-10-16

2,239 reads

SQL Monitor Performance Metric: Buffer Cache Used Per Database in MB

by Press Release

Redgate

Custom Metrics

Data pages read from disk are placed in the buffer pool with the intention that they will be reused, and accessing them from RAM is faster than from disk. Knowing how much of your RAM is committed to each database can help you provision the right amount of RAM to SQL Server, and also to identify rogue queries that draw too much data into RAM and force data from other databases out of the cache.

2013-10-15

3,478 reads

SQL Server Integration Services Connection Manager Tips and Tricks

by Additional Articles

MSSQLTips.com

Integration Services (SSIS)

In this article, we will take a look at the following Tips and Tricks for Connection Managers: Adding an "Application Name" property to the connection string; Creating Two Connection Managers for each Database Connection; and Capturing Connection Manager details in Package Configurations

2013-10-15

5,063 reads

32 bit SSIS in 64 bit environment

by Michal Giczewski

SQLServerCentral.com

Integration Services (SSIS)

This article provides a solution to executes 32 bit SSIS packages in 64 bit environment.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(15)

You rated this post out of 5. Change rating

2013-10-14

7,393 reads

Discuss

The SSAS Tabular Model

by Phil Factor

SQLServerCentral.com

Analysis Services (SSAS)

Phil Factor examines SQL Server 2012's SSAS Tabular model.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2013-10-14

1,036 reads

Discuss

Introduction to SQL Server 2014 CTP1 Memory-Optimized Tables

by Additional Articles

Database Journal

Memory Optimized

There are a number of new features that became available with SQL Server 2014. One of the more exciting features is the new Memory-Optimized tables. In this article Greg Larson explores how to create Memory-Optimized tables, and what he's found during his initial exploration of using this new type of table.

2013-10-14

3,725 reads

Networking at the PASS Summit: First timers

by Steve Jones

SQLServerCentral Blogs

Blogs

The PASS Summit is just over a week away, and one again Andy Warren and I are hosting a networking dinner on Monday night. This is a free, informal event to help people get to know each other. Whether you are new to the community or have been to many events, you’re welcome to attend.

2013-10-14 (first published: 2013-10-04)

1,371 reads

Execute As

by Patrick Cahill

SQLServerCentral.com

Execute AS

Learn how you can use Execute As in a stored procedure to control permissions. This article includes an example that limits access to encryption routines for users.