Archive for October, 2011

Stuff in the FROM clause: Virtual Structures

Continuing with my SQL Server basics series, I’m focusing this post on Stuff in the FROM clause: Virtual Structures. My last post talked about the only Base structure in a relational database, but I’m now moving on to a slightly more complicated concept. Virtual structures are database objects that don’t hold data in a tabular [...]

October 31, 2011 · stuart · No Comments
Posted in: Something New, SQL, SQLServerPedia Syndication

Stuff in the FROM clause: Base Structures

A few months ago, our user group started thinking about how we could get new members to start coming to our SQL Server user group meetings; we defined new user as one of two categories: 1: new to databases, or 2. new to SQL Server In both cases, we realized that we needed to start [...]

October 17, 2011 · stuart · No Comments
Posted in: Code, SQL, SQLServerPedia Syndication

#TSQL2sDay Roundup

So the launch was early, and the write-up is delayed. Time has no meaning…. Truthfully, I’m sorry I didn’t manage to squeeze this summary post in a bit sooner; I have the typical DBA excuse: too much to do, and too little time. One nice thing about this topic is that it seemed to resonate [...]

October 10, 2011 · stuart · 2 Comments
Posted in: Blogging is FUN!, SQLServerPedia Syndication, TSQL2sDay

AtlantaMDF Reviews

Kick some SSAS - Expert Cube Development with Microsoft SQL Server 2008 Analysis Services 2010-08-06

Recently finished (cover-cover) reading of Expert Cube Development with Microsoft SQL Server 2008 Analysis Services. Since then I've gone through a number of chapters several times as topics aligned themselves with work efforts. Looking at this book today, I noticed the covers are all curled, the pages dog-eared, and yellow highlighter is visible across […]

DBAMark

SharePoint 2007 Developer’s Guide to Business Data Catalog 2009-11-24

SharePoint 2007 developer’s Guide to Business Data Catalog is an essential guide to anyone who wishes to become proficient in building complex SharePoint applications. This book starts off assuming that the reader is a complete beginner to BDC, and explains in detail what it is. Soon afterwards, the reader is taught what can be done with it and how.The book […]

wildcat

The Art of Unit Testing 2009-11-08

As a Database Architect, I often work with Object-Oriented Programmers, but thankfully don’t often have to code in other languages other than SQL. However, it is useful to understand the methods and basic frameworks by which my team members develop; hence, I decided to review Roy Osherove’s The Art of Unit Testing (Manning Press, 2009). Although many of th […]

Stu

Music I Code By