Blog Contributors

Kevin Kline

Kevin Kline, a longtime Microsoft SQL Server MVP, is a founder and former president of PASS, and the author of SQL in a Nutshell...

What's the Data Modeling Standard for Business Intelligence Systems?

What are the industry standard approaches for modeling dimensional data modelling?....More

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 03, 2015

Power BI Preview Gaining Market Momentum

As summer nears, the Power BI Preview is making bigger waves with every weekly release. Popular data sources and a plethora of Power BI Designer enhancements are being released at light speed pace. Check out the highlights on what has been released and what we might see next....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
Jul 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 29: Practical Implementation Tips

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....More
Jul 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 28: Additional Options for Tackling Jobs Failover

Throughout this series of posts I’ve taken a somewhat pessimistic view of how SQL Server Agent jobs are managed within most organizations – meaning that most of the code and examples I’ve provided up until this point were based on assumptions about how CHANGE to jobs is managed. That pessimism, to date, has come in two forms:...More
Jul 1, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 27: Options and Concerns for More Advanced Deployments

In this series of posts I’ve called out some of the concerns related to SQL Server AlwaysOn Availability Groups and their interaction with SQL Server Agent jobs – both in the form of Batch Jobs (see post #3) and backups....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) ×