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 the business intelligence, data warehouse and Big Data world for over 20 years for Microsoft, Oracle, DataStax and 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, founder of Impact Analytix, LLC, has 20 years of experience in “hands-on” development of data warehouses, hybrid data integration, reporting, dashboards, and predictive analytics. In...

Jan 25, 2016

Top Takeaways from Microsoft's Reporting Roadmap

The future for on-premises Microsoft business intelligence looks a whole lot brighter these days. Here are the top five takeaways from Microsoft's recent business intelligence announcements....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 6, 2016
Sponsored

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016
Sponsored

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More
May 12, 2016
blog

The 7 C's of Data Quality

Data quality is really important. Why? Because it helps you save money while increasing profits because of accurate contact data. It’s important to understand what data quality is and why it is important....More

Sponsored Introduction Continue on to (or wait seconds) ×