Articles

Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting configurations to parameters, converting packages to the project deployment model, updating Execute Package tasks to use project references and parameterizing the PackageName property.

2012-04-20

2,971 reads

Export data from MySQL to SQL Server

by Additional Articles

MSSQLTips.com

MySQL

Many people want to create a customized migration process using SQL Server Integration Services (SSIS), but it is hard to start working with heterogeneous databases like MySQL, Postgres, DB2, etc. Check out this tip to learn about how to import data from heterogeneous databases like MySQL to SQL Server.

2012-04-20

3,717 reads

A DDL Auditing Solution

by David Wiseman

SQLServerCentral.com

DDL Auditing

An article discussing DDL Auditing. Learn how to track schema changes that occur in your database, enabling you to see who changed what and when. Free GUI tool included.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(5)

You rated this post out of 5. Change rating

2012-04-19

4,670 reads

Discuss

Grant Execute to all SQL Server Stored Procedures

by Additional Articles

MSSQLTips.com

Security

With SQL Server 2000 no default server, database or application role was available to be able to execute all stored procedures. With SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 has this changed with all of the new security features? If not, what options do I have to grant execute rights to the needed database roles?

2012-04-19

2,470 reads

Microsoft SQL Server 2012 - (SQLPS)

by Additional Articles

Database Journal

PowerShell

Prior to SQL Server 2012, Microsoft provided a mini shell called sqlps.exe; in SQL Server 2012, SQLPS exists in the form of module. Learn how to make use of the SQLPS module and how to access SQL Server components and features via Windows PowerShell.

2012-04-18

3,631 reads

PASS Data Architecture VC presents Todd McDermit on Data Warehouse Dimension Processing with SSIS from Simple to Complex

by Press Release

PASS

pass

On Thursday April 19th 12PM noon Central, Todd McDermid will discuss "SSIS components for Data Warehouse Dimensional data processing".

2012-04-18

1,888 reads

Linked server to MySQL Server.

by Daniel Calbimonte

SQLServerCentral.com

MySQL

In this article, we are going to create a linked server to the MySQL Database.
Once finished that task, we will select, insert, update and delete some data using SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(15)

You rated this post out of 5. Change rating

2012-04-17

9,936 reads

Discuss

Understanding Retention Periods for SQL Server Transactional Replication

by Additional Articles

MSSQLTips.com

Replication

I have transactional replication configured in production. I have heard about the replication retention period, but what is the significance of this. Would there be any impact to my replication configuration if data is not synchronized with the subscriptions within the retention period?

2012-04-17

3,053 reads