• subscribe


Check back for future polls! Previous Polls



SQL Server 2012

 

SQL Server 2012's New Features

SQL Server 2012 promises to be an exciting release. Learn about some of its new features and enhancements, as well as system requirements, the upgrade process, and changes in the setup program.


Get Newsletters

  • Get the Latest News
  • Product Updates
  • Helpful Tricks
  • Programming Tips

Business Intelligence

Editorial Announcement

Vote for Your Favorite Products in the SQL Mag Community Choice Awards!

The SQL Server Magazine Community Choice Awards let YOU decide what SQL Server products get chosen for acclaim and recognition. The nomination phase is finished, so now is the time to cast your final vote!

Click here to vote for your favorite SQL Server products!



Business Intelligence Articles

5 Tips for Developing SQL Server Integration Services Packages

By Robert Sheldon, 01/26/2012

These five tips help you avoid a few frustrations that might arise when developing SQL Server Integration Services (SSIS) packages so you keep your development efforts moving ...

Microsoft SQL Server 2012: Evolutionary New Features for the Enterprise Data Platform

By Michael Otey, 01/13/2012

Learn why Michael Otey thinks that SQL Server 2012 is the next evolution of Microsoft enterprise data platform.

New Products: CA Technologies, Melissa Data, Idera, and More

By Blair Greenwood, 01/13/2012

Check out the latest products from Panorama Software, CA Technologies, PlumChoice, Melissa Data, Werysoft, and Idera.

The SQL Server Community: Giving to Those in Need

By Brian Moran, 12/22/2011

The SQL Server community is known for banding together to help those in need, whether they have a SQL Server-related question or a charity they want to support. Here's two acts of ...

New Products: Attunity, Idera, and expressor software

By Blair Greenwood, 12/21/2011

Check out the latest database administration products in the SQL Server market from Attunity, Idera, and expressor software.


SQL Server Trends in 2008

Learn which Microsoft and third-party products will have the tools you need to stay on top of SQL Server development, administration, and business intelligence (BI) challenges in the coming year....

2011 SQL Server Magazine Editors' Best and Community Choice Awards

SQL Server Magazine editors and readers recognize standout products in eight categories, making it easy for you to find the right tool....


Clash of the Titans

Client/server accounting is gaining new dimensions as Windows NT continues to conquer the enterprise. NT's potential is encouraging vendors to focus on their resources on developing NT versions of...

Keeping Up with Convergence

Now is the time to focus on what's really going on in the software applications world....


Using Reporting Services in an Internet/Extranet Environment

How can you use SQL Server 2005 Reporting Services to deploy reports when Windows Authentication isn’t available—and without the risk of one partner seeing another’s data? Here’s how to set up custom...

Many-To-Many Currency Conversions in Microsoft's SQL Server Analysis Services

Using the Business Intelligence Wizard in SQL Server Analysis Services (SSAS), you can perform currency conversions but you can’t enter multiple dates or multiple exchange rates. Despite the...


More Business Intelligence Articles

New Products: Attunity, Idera, and expressor software

By Blair Greenwood, 12/21/2011

Check out the latest database administration products in the SQL Server market from Attunity, Idera, and expressor software.

SSRS How-To: Create Reports by User to Protect Sensitive Data

By William Vaughn, 12/13/2011

In SQL Server Reporting Services (SSRS), you can create reports that automatically morph based on who is viewing them.

SQL Server Magazine Announces New Name: SQL Server Pro

By Megan Keller, 11/28/2011

SQL Server Magazine has a new name -- SQL Server Pro! We'll continue to provide hands-on content that shows DBAs, developers, and BI analysts how to use and troubleshoot SQL ...

Introducing the SQL Server Consolidated Monitoring Tool

By Jeff Carrington, 11/24/2011

With the consolidated monitoring tool, you can access the live dashboard report for any SQL Server instance, collect and report on the latest performance data collected from one ...

Many-To-Many Currency Conversions in Microsoft's SQL Server Analysis Services

By David Tuppen, 11/23/2011

Using the Business Intelligence Wizard in SQL Server Analysis Services (SSAS), you can perform currency conversions but you can’t enter multiple dates or multiple exchange rates. ...

2011 SQL Server Magazine Editors' Best and Community Choice Awards

By Editors, 11/18/2011

SQL Server Magazine editors and readers recognize standout products in eight categories, making it easy for you to find the right tool.

Are You Prepared to Find Your Next SQL Server Job?

By Brian Moran, 10/27/2011

If you left or lost your job today, have you set your career up in a way that you can quickly find a new job?


Featured Blogs

SQL Server BI Blog

Updated SQL Azure Reporting Services CTP

by Mark Kromer Late last year, Microsoft announced the availability of an updated beta or...

SQL Server BI Blog

An Introduction to Power View in SQL Server 2012 RC0 UPDATED

By Mark Kromer   We’re coming up to the end of 2011 and it’s been a while since I’ve posted...

SQL Server BI Blog

SSIS Version Control Made Easy in Denali

by Mark Kromer For those SQL Server and development shops that have built a lot of SQL Server...

Business Intelligence Blog

What Is Business Intelligence?

Find out what business intelligence is and which technologies support it....

Business Intelligence Blog

Microsoft's Quentin Clark Discusses SQL Server 2008 R2 and the Parallel Data Warehouse

This past November at the DevConnections conference, Richard Campbell, from .NET Rocks, had the...

Business Intelligence Blog

Choosing a Primary Key

Are you unsure whether you should use a surrogate identifier or a natural value for a primary key?...

SQL Server BI Blog

An Introduction to Power View in SQL Server 2012 RC0 UPDATED

By Mark Kromer   We’re coming up to the end of 2011 and it’s been a while since I’ve posted...

SQL Server BI Blog

Updated SQL Azure Reporting Services CTP

by Mark Kromer Late last year, Microsoft announced the availability of an updated beta or...

SQL Server BI Blog

SSIS Version Control Made Easy in Denali

by Mark Kromer For those SQL Server and development shops that have built a lot of SQL Server...

advertisement

  • dynamic PIVOT
    Hi, THis is example I found on msdn: USE AdventureWorks ; GO S...
  • File Import
    good morning I am designing ssis that need to import flat file and then move it into archive I dont...
  • SSIS and transactions
    I have an SSIS package that truncates a table (we can call it TABLE1), runs a SQL query, and...
  • BIDS question
    This is a dumb question - On the start page, under the recent projects (that you can open w...

Featured Event

More Events


SQL Server 2008 R2 System Views Poster



SQL Server 2008 R2 System Views Poster

The Microsoft SQL Server 2008 R2 System Views Map shows the key system views included in Microsoft SQL Server 2008 and SQL Server 2008 R2, and the relationships between them. The map is similar to the Microsoft SQL Server 2008 version and includes updates which are also applicable for the Microsoft SQL Server 2008.

SQL Server 2008 R2 System Views Poster!