I'm not going to blab about the speculation, or how Microsoft seems to like making their promised deadlines by the skin of their teeth. I'm too busy preparing how we're going to deploy and...
Tip : SQL Server Data Type Consistency
Last night Microsoft released Service Pack 1 Cumulative Update #10: KB #2279604 : Cumulative update package 10 for SQL Server 2008 Service Pack 1 The build number is 10.00.2799 and there seem to be...
On the #SQLHelp hash tag today, @zippy1981 asked the following question: Is there an easy one-liner (powershell,sqlcmd/SSMS/etc) to load a single html file on the local filesystem to a field in the DB? While...
This morning we were attempting to test an existing app on a server where we had recently made some AppPool and other changes to IIS (installing a newer application to run side-by-side). When we...
Tip : Use Consistent SQL Server Naming Conventions