Blogs

Nov 18, 2011

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
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
Aug 27, 2015

A Replacement for Maintenance Plan Backups

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
Oct 02, 2011

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

Itzik describes new T-SQL scalar functions in SQL Server 2012 CTP 3....More
Nov 05, 2014

SQL PASS Summit 2014 Day One Keynote

Highlights from the PASS Summit 2014 day one keynote....More
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
Mar 14, 2015

For Data Quality, Intelligent Rules Add Value to the Golden Record6

The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions....More
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
Oct 31, 2011

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
Jul 02, 2013

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

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

Sponsored Introduction Continue on to (or wait seconds) ×