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
This article provides a solution to executes 32 bit SSIS packages in 64 bit environment.
2013-10-14
7,320 reads
2013-10-14
1,021 reads
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
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
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.
2013-10-11 (first published: 2011-02-02)
18,299 reads
Red Gate is shipping new features and fixes this week, based on requests from attendees at SQL in the City Charlotte and PASS Summit 2013.
2013-10-11
707 reads
Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. In this article series Arshad Ali talks about how you can get started with using enhanced columnstore index features in SQL Server 2014 and do some performance tests to understand the benefits.
2013-10-11
3,531 reads
In November of 2012, I embarked on a Quixotic attempt at building a BI prototype in 7 days. I dubbed the experiment ‘OLAP Sprint’...
2013-10-10
2,565 reads
The Charlotte BI Group (CBIG) is excited to bring the 2nd annual SQL Saturday, BI Edition, to Charlotte on October 19. This SQL Saturday training event is focused on Microsoft Business Intelligence, Analytics, and Data Administration topics.
2013-10-10
399 reads
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
Comments posted to this topic are about the item How Well Does the MSSQL...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers