Blogs

11/18/2011 - 1:19pm

The SQL Server 2012 Special Ops Tour: Get Recognized for Your SQL Server Solutions

The SQL Server 2012 Special Ops Tour could come to your city and you could be featured at an event....More
07/31/2012 - 11:56am

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
04/15/2014 - 2:10pm

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
10/02/2011 - 4:03am

SQL Server 2012 T-SQL at a Glance: New and Enhanced Functions

Itzik describes new T-SQL scalar functions in SQL Server 2012 CTP 3....More
10/18/2013 - 12:24pm

PASS Continues to Grow and Educate the SQL Server Community

This year’s PASS Summit 2013 marked the second year in a row that the attendance for the conference was over 5,000 attendees who experienced three days of over 190 technical sessions....More
03/10/2014 - 11:19am

Does Excel Power Pivot Replace the Data Warehouse?

Power Pivot and other self-service BI tools are not a replacement for a data mart or data warehouse. When used correctly for Personal BI, Team BI, prototypes or proofs-of-concept, you can achieve truly agile, rapid reporting success with Excel Power Pivot....More
01/14/2014 - 6:14pm

Managing the Health of Your SQL Server Environment

How the SQL Server community helped to shape and create a new tool for DBAs to manage their environments more effectively....More
07/31/2012 - 10:58am

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
10/31/2011 - 1:42pm

Is SQL University's professional development week as cool as Shark Week?

I’m honored to be part of the the SQL University community project this week. Mike Walsh and I will be exploring topics related to professional development. Of course, my entire L.E.A.P. blog is focused on this topic in various ways so the SQL University theme isn’t too much of a stretch for me. I’m pretty sure that the fall 2011....More
07/02/2013 - 11:21am

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

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

Sponsored Introduction Continue on to (or wait seconds) ×