Blog Contributors

Mark Kromer

Mark Kromer has been a technical product manager & solution architect in business intelligence, data warheouse and Big Data world for over 20 years for Microsoft, Oracle and AT&T, currently for Pentaho. Twitter: @mssqldude

Oct 29, 2013

Old BI vs. New BI

A very common reference to business intelligence approaches has emerged, comparing "old BI" to "new BI."....More

Beta for New Microsoft Visual Studio LightSwitch Announced

LightSwitch is a developer tool based on .NET that “will be the easiest way to build business applications for the desktop and the cloud,” according to Microsoft....More
in L.E.A.P Think Jul 31, 2012

What would the world look like if businesses led a purpose driven life rather than focusing solely on shareholder value?

Many books exhort you to live a purpose driven life. But the notion of trying to lead a purpose driven business is rarely discussed outside faith based organizations. In fact, companies, along with officers and directors of the company, are often sued for doing anything other than worrying about maximizing shareholder value. Scot’s....More

Michael Otey

Michael Otey, technical director for Windows IT Pro and SQL Server Pro, is president of TECA, a software-development and consulting company in Portland, Oregon. Michael has covered the topic of virtualization extensively for Windows IT Pro, having written several...

in SQL SELECT Blog Nov 05, 2014

SQL PASS Summit 2014 Day One Keynote

Highlights from the PASS Summit 2014 day one keynote....More

Paul S. Randal

Paul Randal worked on Microsoft's SQL Server team for nine years in development and management roles, writing many of the DBCC commands. Randal was ultimately responsible for SQL Server 2008's core storage engine. Randal now works as a consultant, trainer, speaker, and writer...

Jul 31, 2012

Recovering a database with a missing transaction log

Usually when a database has open transactions and the server crashes, crash recovery will run on the affected database and roll back the open transactions....More

Kimberly L. Tripp

Kimberly L. Tripp has been working with SQL Server since 1990, and she’s worked as a consultant, trainer, speaker, and writer specializing in core SQL Server ...

Apr 03, 2012

What about moving LOB data while keeping the table online?

Moving LOB data associated with a table isn't simple—even with the SQL Server 2012 ability to rebuild indexes that include LOB data as an online operation. The key reason is the behavior of LOB data during these operations....More

Jen Underwood

 

Jen Underwood, Microsoft Sr. Program Manager, has almost 20 years of experience in data warehousing, business intelligence, and predictive analytics. She was formerly a Microsoft Business Intelligence Technical...

Jun 20, 2014

Microsoft Cloud Predictive Analytics Preview Coming Soon

A preview of Azure Machine Learning, or Azure ML (project code name "Passau"), will be made publicly available in July 2014....More

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....More
SQL Server Availability Groups screenshot
Nov 11, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 14: Establishing Synchronization Checks

When compared to AlwaysOn Failover Cluster Instances or clustered deployments of SQL Server, one of the main problems with AlwaysOn AGs is that a single database is made to straddle multiple hosts....More
Stretch SQL Server into Azure
Nov 5, 2014
blog

SQL PASS Summit 2014 Day One Keynote

Highlights from the PASS Summit 2014 day one keynote....More
SQL Server Pro Forums

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

Sponsored Introduction Continue on to (or wait seconds) ×