The Wayback Machine - https://web.archive.org/web/20150508072217/http://sqlmag.com:80/

SQL Server Pro

Connect With Us

SQL Server 2014

  1. SQL Server Public Preview Coming This Summer
  2. Migrating to SQL Server 2014 8
  3. SQL Server Data Tools for SQL Server 2014 6
  4. SQL Server Backup Encryption 3
  5. Getting Started with Azure SQL Database v12
Business Intelligence
Hybrid Business Intelligence with Power BI
Business Intelligence Market Shifts
8 Free Business Intelligence Tools
Power BI Preview now Globally Available
News & Information
May 6, 2015
Article

The Microsoft Ignite Keynote and the End of the DBA Role (as We Know It)

Did information divulged about SQL Server 2016 and Microsoft's new mission in the Microsoft Ignite keynote signify the end of the DBA role as we know it?...More
May 4, 2015
Article

SQL Server Public Preview Coming This Summer

The announcement was made this morning at the Microsoft Ignite keynote that a public preview for SQL Server 2016 will be released this summer.  "The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission-critical applications and deeper insights on your data across on-premises and cloud,” Microsoft corporate vice president T.K....More
Apr 30, 2015
IdeaXchange
SQL Server Pro

Effective Data Visualization - The Eradication of Ruler Reports

Effective Data Visualization – The Eradication of Ruler Reports I once had an efficiency consultant tell me that he went into an office looking for a ruler left out on someone’s desk. This was a sure sign that person received one or more reports that were so large and so complex, it was necessary to lay a ruler across the report in order to read it properly. These “ruler reports” were the first candidates to be redesigned and replaced....More
Apr 29, 2015
Article

Getting Started with Azure SQL Database v12

I realized that I’ve been talking about the wonders and glories of the new release of SQL Database when some of you might not even be prepared to work with it. Let’s remedy that. First of all, you’ll need an Azure account. There’s a free trial available. Go there and sign up. Better still, if you have an MSDN account you can take advantage of free credit on Azure....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...More
Apr 23, 2015
Article
SQL Server Pro

SSAS Tabular-Part 4: Deep Dive DAX

This is the fourth and final article in the four part series about designing SSAS Tabular models.  We go deeper into the DAX language to define more advanced measures and KPIs. Part 1 - Getting Started with SSAS Tabular...More
Apr 23, 2015
Article
SQL Server Pro

SSAS Tabular-Part 3: Tabular Model Administration

This is the third article in the four part series about designing SSAS Tabular models.  In this article you will learn how to manage and secure a deployed model on the server. Part 1 - Getting Started with SSAS Tabular...More
Apr 22, 2015
Article

PASS Business Analytics Conference 2015: Day 2

The PASS Business Analytics Conference 2015 is for Data Analysts, Data Scientists and Data Engineers who work primarily within the Microsoft set of tools, whether locally or on Azure. Today was the end of the second and final data of the conference. It was a very interesting event. I posted of my experience on the first day here. Day two was just as interesting....More
Apr 22, 2015
Article
SQL Server Pro

PASS Business Analytics Conference 2015: Day 1

If you're involved in the analysis of data as a data engineer, data analyst or data scientist and you're using the tools from the Microsoft stack, chances are you are in Santa Clara California attending the 2015 PASS Business Analytics Conference. Just in case you've missed out, let me share my experience with the event....More
Apr 17, 2015
Sponsored

Microsoft SQL Server on XtremIO- Meeting SQL DBA challenges

Hear from EMC experts how to empower your SQL Server...More
Apr 16, 2015
IdeaXchange

Being a Good #SQLHelp(er)

If you are active on Twitter, you may have found your way to the SQLHelp hash tag and seen the high level of interaction. SQLHelp has become a popular method of getting quick answers to SQL questions....More
Apr 16, 2015
Article
SQL Server Pro

Looking for SQL Server 2014 SP 1... Hold Off a Bit Longer

Microsoft released service pack 1 for SQL Server 2014 on April 15, 2015. Why can't we download it though?...More
Apr 16, 2015
Press Release

Who Will Be Attending HostingCon 2015?

Who will be attending HostingCon 2015?...More
IdeaXchange

IdeaXchange is timely, provocative, tech-savvy content for SQL Server Pro readers. Check out our experts and what they have to say!

What’s your favorite SQL Server feature?

View all polls
Join the Conversation

From the Blogs
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...More
Mar 17, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 21: Assigning Backup Preferences

An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences. It’s also something you can easily configure once the Availability Group has been set up as well – by simply right-clicking on the Availability Group and selecting Properties – then navigating into the Backup Preferences tab.  ...More
Mar 14, 2015
Commentary

For Data Quality, Intelligent Rules Add Value to the Golden Record 6

The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More
Featured Authors
Tim Ford
The Microsoft Ignite Keynote and the End of the DBA Role (as We Know It)
by Tim Ford
Published on May. 6, 2015
in Database Administration
Jen Underwood
Power BI Preview now Globally Available
by Jen Underwood
Published on Mar. 16, 2015
in Power BI
Itzik Ben-Gan
Puzzle Me This: String Replacement
by Itzik Ben-Gan
Published on Apr. 9, 2015
in SQL Server
Allen White
Using the ADO.NET Connection String
by Allen White
Published on Dec. 11, 2014
in Scripting
Recent Comments
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Community Sponsors

Readers Contribute

If you would like to submit an article, please ensure you are logged in and then click Contribute.

If you are not a registered user on SQL Server Pro, click Register.

SQL Server Pro Guest Blogs

All Sponsored Blogs

Online Conference

Deploying Affordable, High Performance Hybrid Storage for Clustered SQL Server

On Demand
Watch this webcast to learn about some essential best practices in storage, and how you can ensure that your SQL Server instances are performing at their best. Gain insight on:

--Storage challenges.
--Using SANs with SQL Server.
--Best practices with Tempdb.
--Using flash technology with SQL Server.
 

Register Now

SQLMag.com
Related Sites
Copyright © 2015 Penton

Sponsored Introduction Continue on to (or wait seconds) ×