SQL Server 2012 Integration Services - Package and Project Configurations

Marcin Policht examines SSIS 2012 package and project configurations, which offer different ways of modifying values of variables and parameters without having to directly edit content of the packages and projects of which they are a part.

SQLServerCentral.com Users Survey 2012

We want to make sure we're covering the things that are relevant to you, so we're asking for some feedback on what you use on SSC, where we need to improve, and what you'd like to see.

It should only take a few minutes, and three randomly-selected people will win a $100 Amazon gift card for their efforts.

Managing Risk

Managing risk is a park of business, but it also requires that we have the information to properly assess the issues. Do we prevent that in IT?

SSIS Basics: Setting Up Your Initial Package

Up until now, it has been a curiously frustrating search to find out the basics of SSIS, fast, in order to get up and running quickly. No longer, as Annette Allen comes up with a simple introduction for the rest of us.

New Security Holes

Siri is seen as a data security hole at IBM. This is something that Steve Jones thinks we might need to be more concerned about in the future, especially as more and more processing takes places outside of our walls.

The Sequence Object in SQL Server 2012

The Sequence Object is one of the many exciting new features introduced in SQL Server 2012. Learn what this new feature can do for you and how you can use it.

The Upgrade Avalanche

This year we will see a large number of upgrades from Microsoft to much of its technology stack. Can IT Pros handle the load?

SQL in the City London - 13th July

SQL in the City the one day free SQL Server training event is back in London this July. Join fellow SQL Server professionals for 5 hours of technical presentations on key issues for SQL Server developers and DBAs delivered by top MVPs. The event also offers you the chance to network with users passionate about SQL Server and the chance to see the latest Red Gate tools and meet the developers who built them. Find out more and register today.

SQL Server 2012 Integration Services - Project Deployment

SQL Server 2012 Integration Services parameters introduce a new way of dealing with package development, deployment, and execution. In order to truly appreciate their relevance, it is necessary to take a look at the new Project Deployment Model.

10 tips on converting MS SQL queries to MySQL

The syntax of SQL queries in MS SQL and MySQL are similar but not identical. This article discovers 10 most popular differences between MS SQL and MySQL syntax.