I can't seem to build a query in SQL Server 2005 that returns rows that are not in a table. [more inside]
posted by DakotaPaul on Oct 7, 2009 - 17 answers

Can someone help me understand how the WITH common table expression works in Microsoft SQL Server? [more inside]
posted by DakotaPaul on Sep 11, 2009 - 9 answers

What is the best way to host an ASP.NET website? [more inside]
posted by talkingmuffin on May 13, 2009 - 3 answers

Hosting SQL Server and IIS on the same co-located server: Good idea, bad idea, or terrible idea? [more inside]
posted by JohnFredra on Mar 17, 2009 - 8 answers

What might cause a SQLOLEDB connection string (containing an admin username/password) to briefly appear on-screen in a browser session and would I be crazy to buy a product that's had this bug for who knows how long without realizing it? [more inside]
posted by aydeejones on Feb 16, 2009 - 8 answers

Fixing whitespace: Can someone translate 's/ */ /g' into T-SQL? [more inside]
posted by pompomtom on Jul 30, 2008 - 2 answers

Another SQL question (*sigh*), but this time a bit more complicated. [more inside]
posted by omnipotentq on Jul 15, 2008 - 7 answers

What's the best way to keep data one way synchronized between an internal Mircosoft SQL Server database and a web facing mySQL database? [more inside]
posted by advicepig on Apr 3, 2008 - 9 answers

IANA IT professional, but I need to move our SQL Server database from one server to another server. I can't get the DSN connections to work now that we're on the new server; can you please hold my hand? [more inside]
posted by bcwinters on Mar 15, 2008 - 7 answers

I have a set of dates/times in a MS SQL table that lack a timezone offset. I want to convert them to UTC, but I have to be mindful of Daylight Time for each of these dates (they're in the future). How can I convert them to UTC correctly? [more inside]
posted by dw on Nov 13, 2007 - 3 answers

I need to get part of a website onto a USB sick at will [more inside]
posted by Chuck Cheeze on Oct 24, 2007 - 7 answers

I have Visual Studio 2005 Professional. I installed VS2k5Pro with all of the options except the sample databases on my WinXP box, but now I can't figure out how to access the Enterprise Manager - replacement ... Enterprise Management Studio, or even find out if that app is included with the version I have. Any suggestions?
posted by SpecialK on Aug 1, 2007 - 3 answers

I need some SQL Server/database design help. I have a custom built admin for an ecommerce site where we manage our orders. During the life of an order, it can have many statuses ... [more inside]
posted by SoulOnIce on Aug 4, 2006 - 12 answers

MS SQL Server Filter: I'm supporting a pretty old process that loads data into and out of SQL Server 6.5. The process uses isql and bcp from a SQL Server 2000 installation. Is there anywhere I can download these utilities for free, perhaps as part of a "SQL Server Client" tool? I have searched the M$ website...
posted by joecacti on Aug 4, 2006 - 4 answers

Need a tinker-free Linux/MySql install for Ruby On Rails. Also, seeking advice for getting started in RoR. [more inside]
posted by Afroblanco on Jun 27, 2006 - 19 answers

Topping 400 and my dog is 14 1/2 years old... but it's not really about that. [more inside]
posted by auntbunny on Mar 26, 2006 - 2 answers

What's the best way to export data from a SQL Server 2000 database into QuarkXPress 4.11 using ColdFusion 5? [more inside] [more inside]
posted by kirkaracha on Feb 5, 2004 - 0 answers