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
09/09/2014 (All day)

AlwaysOn Availability Groups and SQL Server Jobs, Part 5: Setting Up Failover Alerts

Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....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
06/20/2014 (All day)

Microsoft Azure Machine Learning Moves Predictive Analytics into the Cloud

Find out about Microsoft's new Azure Machine Learning Predictive Analytics....More
06/20/2014 - 5:47pm

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
09/12/2014 - 12:03pm

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....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) ×