04Jan 2010 by Grant Fritchey No Comments

SQL Server Standard Article Abstracts

Misc
I'd really like to publish your article in SQL Server Standard. All I need from you is an abstract, a description of what the article will be. I've posted this before, but I've never provided examples. So, to get people started, here are a few examples of articles that have been accepted and will be published (shortly I hope). Here's a great example from Andy Leonard. It includes a great amount of detail, more than I need to make my decision, but with this much detail, the decision is much easier because I know exactly what this article is likely to look like:    I'm interested in writing an article on SSIS for SQL Server Standard. I'd like to cover ways packages can exchange information at run-time. There are a couple…
Read More
23Jun 2008 by Grant Fritchey 5 Comments

Article Ideas, specifically on SQL Server 2008

Misc
I'm trying to come up with some ideas for an article (or six) on SQL Server 2008. I know I'm getting about 40 views a day on this blog. That must translate to about 20 users (the statistics on this site aren't clear, so I'm guessing). Do any of you have any good questions about new functionality in SQL Server 2008? I've been thinking about looking at sparse columns and filtered indexes or maybe the spatial data types. Those are the topics I'm most excited about as a database developer and designer. If I think about it in terms of being an admin, policy management, the data collector, and those types of new functionality are very interesting. I'm not even sure what's new in the BI space. So, if you're…
Read More
21Mar 2008 by Grant Fritchey No Comments

Top vs. Max

T-SQL
The company I work for has a very well defined need for versioned data. In a lot of instances, we don't do updates, we do inserts. That means that you have to have mechanisms for storing the data that enables you to pull out the latest version of all the data or a particular version of all the data, or the data at a particular moment in time, regardless of version.  That means maintaining a version table and a series of inserts into various tables. Some tables will have pretty much a new row for each version, some tables may only have one or two versions out of a chain. With the help of a very smart Microsoft consultant, Bill Sulcius, we have a mechanism that works very well. However,…
Read More