Welcome to AspAdvice Sign in | Join | Help

Browse by Tags

All Tags » SQL   (RSS)
Wednesday, April 16, 2008 7:24 PM

Microsoft Cloud Services

One of the quietly announced (at MIX - WMV here ) new things coming from Microsoft "soon" is SQL Server Data Services (SSDS). The SSDS team has a blog on MSDN. Ryan Dunn discussed it with me recently and also has been blogging about it . Last week he
Posted by ssmith | 1 Comments
Filed under:
Friday, February 22, 2008 10:30 AM

Use Unit Test Framework to Test Production DB Consistency

For Lake Quincy Media 's AdSignia Ad Server, I wanted to be able to ensure that the database had some internal logic rules checked periodically. What kinds of rules? Well, probably an example would be best. Suffice to say up front, though, that we're
Posted by ssmith | 3 Comments
Friday, February 15, 2008 4:36 PM

Stored Procedure Performance Varies Between ADO.NET and Management Studio

I ran into this very annoying issue earlier this week, that my buddy and SQL guru Gregg Stark was able to track down for me. I have a fairly intense XtraReport report that gets its data from a stored procedure. When I run that stored procedure in SQL
Posted by ssmith | 2 Comments
Filed under:
Tuesday, January 29, 2008 4:12 PM

Creating a New SQL Database

Today I need to set up a new database for a new web site I'm working on. Last week, I saw Rick's post about the "mousercise" that defines the typical table set up in SQL Server 2000 and 2005's table designer . I have to admit that I completely relate
Posted by ssmith | 0 Comments
Filed under: ,
Sunday, September 30, 2007 7:07 PM

Case Sensitive or Insensitive SQL Query

Suppose you need to perform a SQL query and you need for it to be case sensitive or case insensitive, and either your database is set up the opposite way or you're smart and you're trying to write your query so that it will work regardless of
Posted by ssmith | 3 Comments
Filed under:
Monday, September 24, 2007 3:48 PM

Installing SQL 2005 Management Studio

I've installed SQL Server on a few dev boxes in my time, and one thing I've noted on several occasion is that even if you check the box during the install to say you want to install all of the client tools, usually they don't install. You think they installed,
Posted by ssmith | 3 Comments
Filed under: ,
Friday, September 14, 2007 10:44 PM

Using PowerShell to Automate a SQL Task

I have a very large table in a SQL database that I need to clean up some old data on. I've already copied all of the data to another table in another database with a different schema. I have a legacy application that still uses the old data, but the data
Posted by ssmith | 5 Comments
Filed under: , ,
Thursday, January 18, 2007 12:33 AM

COPY One Table Row in SQL

I have a table with a bunch of columns in it that I wanted to be able to duplicate so that I could just change a couple of columns and not have to re-enter all of the columns and their values. I did some searching and the closest I came to what I wanted
Posted by ssmith | 3 Comments
Filed under: