Dennis Bottjer | ASP.NET + SharePoint Architect, Trainer & Speaker

"An Ounce of Prevention is Worth a Pound of Cure" - Ben Franklin
posts - 168, comments - 59, trackbacks - 41

My Links

News

Add to Technorati Favorites The views expressed in this blog are mine and mine alone, not that of my employer, Microsoft, or anyone else’s. No warrantee is given for the quality of any material on this site.

Tag Cloud

Archives

Post Categories

SQL & LINQ

SQL Server, LINQ to SQL, EF, etc.
SQL Reporting Services Error Installing TFS 2010

Over the weekend I spun up a new virtual machine for a practice TFS 2010 Installation.  The TFS installation process is much improved.  It can loosely be broken into two phases which are installation and configuration.  The installation is the easy part which basically prepares the server and copies some bits to the drive.  The configuration is a little more difficult but provides some guidance to help make the important decisions.  During the configuration you make the following three key decisions. Install WSS 3.0 or use an existing SharePoint installation Install SQL Express...

posted @ Thursday, September 9, 2010 1:18 AM | Feedback (0) | Filed Under [ Debugging SQL & LINQ TFS 2008 Tips-n-Tricks ]

Cumulative Update Package 2 for SQL Server 2008 Service Pack 1

Issues: SharePoint 2010 Foundation and Server require the Cumulative Update Package 2 for SQL Server 2008 Service Pack 1 to use SQL Server 2008 as the backend Database. Solution: SQL Server 2008 will not install properly on Windows 2008 Server without SQL Server 2008 Service Pack 1.  Download Download SQL Server 2008 Service Pack 1. To use SQL Server 2008 for the backend database for SharePoint Foundation or Server download Download and Install Cumulative Update Package 2 for SQL Server  2008 Service Pack 1.  Note: Installing the Cumulative Update Package 2 for SQL Server...

posted @ Sunday, January 3, 2010 8:57 PM | Feedback (0) | Filed Under [ SharePoint SQL & LINQ ]

Oklahoma City SQL Server Developers Group Kick Off Meeting

Oklahoma City has a new user group thanks to the hard work of Kristin Ferrier.  The Oklahoma City SQL Server Developers Group will meet monthly.  The Group’s first meeting is Monday April 13th.  See details below:   Event Details: We are excited to invite you to the first meeting of the Oklahoma City SQL Server Developers Group! Mike Hotek, former SQL Pass speaker, has graciously agreed to be our first speaker. Topic: Q&A with Mike Hotek (open topics are Database Administration and T-SQL in both SQL Server 2005 and 2008) Mike will be open to...

posted @ Friday, April 10, 2009 4:48 AM | Feedback (1) | Filed Under [ Community & Events News & Announcements SQL & LINQ ]

Multi-Tenant Data Architecture Reviewed

[Dave] first brought Multi-Tenant Data Architecture MSDN Article to my attention a few months ago.  Unfortunately, I've had this article in my items to review folder.  Anyway, I finally read the article in detail and thought it quite valuable.  Basically, the article describes several approaches for designing a Multi-Tenant Data Architecture.  It reviews each approach and reviews the pros and cons. [RoyAshbrook] blogged his thoughts on Multi-Tenant Data Architecture.

posted @ Tuesday, May 8, 2007 7:44 PM | Feedback (0) | Filed Under [ SQL & LINQ ]

Space Used By SQL Indexes

Found this query on MSDN SQL Blog and tweaked it a bit. It shows index info including the space used by each index.

posted @ Monday, October 30, 2006 6:59 AM | Feedback (1) | Filed Under [ SQL & LINQ ]

SQL Formatting for Easier Debugging

This Simple query was created from a demo Microsoft Smart Client Application called IssueVision. To create it I right clicked on IssueHistory table in SQL Server Management Studio 2005. Notice the commas are all to the left of the column names.

posted @ Saturday, October 21, 2006 6:03 AM | Feedback (1) | Filed Under [ SQL & LINQ ]

SQL Query By Year

SQL Query By Year

posted @ Saturday, December 10, 2005 1:12 AM | Feedback (1) | Filed Under [ SQL & LINQ ]

SQL Table Naming Conventions

How do you name your SQL Tables? Are the names singular or plural? A friend suggested that tables should be singular because they represent a single record instance of data stored in the table. When multiple records are selected then a collection is created.

posted @ Friday, September 23, 2005 12:34 AM | Feedback (0) | Filed Under [ SQL & LINQ ]

Stored Procs Vs. Dynamic SQL

There are many great topics of debate in software development. DataSets Vs. Objects, Smart Clients Vs. Web Apps, and Stored Procs Vs. Dynamic SQL. Many have argued that writing stored procedures is rigid and doesn't allow for an easy way to build detailed where clauses. Furthermore, SQL Server 2000 caches execution plans so in theory SQL Statements should be optimized if used often. Finally, .NET allows for parameterized queries helping to protect dynamic queries from SQL Interjection.

posted @ Tuesday, August 2, 2005 1:16 AM | Feedback (0) | Filed Under [ SQL & LINQ ]

Powered by: