Archives

Upcoming Presentation and Blog Events

I mentioned in the last article that I am taking a temporary break from the T-SQL Basics Series of articles. I’ll return to it in a few weeks, but in the meantime I’ve been working other stuff for your amusement.

Next week Wednesday, I’ll be presenting at the Fort Worth SQL Server User Group. Come [...]

Database Views - Using PowerPivot with Problem Databases Part 2

In the previous post I mentioned the use of views to simplify querying your database in general and PowerPivot in particular.

What are Database Views?

Views are virtual tables, which you can create with a SQL statement. Some of the advantages of using views are:

Simplified Data Access – The view hides the data structure from [...]

Come See Me Present at Consona Connect 2010 Next Week

In recent articles, I’ve apologized because my blogging has become sporadic and mentioned that there were reasons for it which would be revealed soon. Well, one of them is that Consona (Made2Manage) has foolishly graciously asked me to present at their national conference in Vegas next week and I’m all kinds of geeked about it. [...]