Tag Archives: SQL Server

Rewiring the users and logins in SQL Server

Posted on Monday, 17 October, 2011 by Colin Mackay

As a developer I find that I’m frequently backing up and restoring SQL Server databases between servers for development and testing purposes. However, each time I do the link between the login (a server concept) and the user (a per … Continue reading →

Posted in Software Development, Tip of the Day | Tagged , , | Leave a comment

If you really must do dynamic SQL…

Posted on Monday, 21 September, 2009 by Colin Mackay

I may have mentioned in previous posts and articles about SQL Injection Attacks that dynamic SQL (building SQL commands by concatenating strings together) is a source of failure in the security of a data driven application. It becomes easy to … Continue reading →

Posted in Uncategorized | Tagged , , , | 7 Comments

Tip of the Day #5 (SQL Server memory usage)

Posted on Sunday, 20 July, 2008 by Colin Mackay

You can limit the amount of memory that SQL Server uses by using the sp_configure stored procedure. By limiting the amount of memory that SQL Server is permitted to use it means that more memory is available to other applications … Continue reading →

Posted in Tip of the Day | Tagged | 4 Comments

Spatial Operations in SQL Server 2008 (Katmai) – Union and Convex Hull

Posted on Saturday, 15 December, 2007 by Colin Mackay

CODE EXAMPLES IN THIS POST WORK WITH THE NOVEMBER 2007 CTP (CTP 5) OF SQL SERVER 2008. Say you would like to create a polygon out of a group of points. One way of doing this is to union the … Continue reading →

Posted in Uncategorized | Tagged , , , | 2 Comments

Contradictory messages

Posted on Saturday, 8 December, 2007 by Colin Mackay

While attempting to create a database project in Visual Studio 2008 against a SQL Server 2008 database I got a rather odd error message. The dialog used to create the project requests information about the SQL Server database. It clearly … Continue reading →

Posted in Uncategorized | Tagged , , , , | Leave a comment

Inserting geometry through a .NET Application

Posted on Thursday, 6 December, 2007 by Colin Mackay

THIS POST REFERS TO THE NOVEMBER 2007 CTP (CTP 5) OF SQL SERVER 2008 Following from my previous posts (Getting started with Spatial Data in SQL Server 2008, Spatial Data in a .NET application) on the new spatial features of … Continue reading →

Posted in Uncategorized | Tagged , , , , , | 4 Comments

Getting started with Spatial Data in SQL Server 2008

Posted on Saturday, 1 December, 2007 by Colin Mackay

THIS POST REFERS TO THE NOVEMBER 2007 CTP (CTP 5) OF SQL SERVER 2008 This post is probably going to be a wee bit random. After the running around over the last couple of weeks with the MSDN event (Sharepoint … Continue reading →

Posted in Uncategorized | Tagged , , , | 4 Comments

SQL Server 2008 (Katmai): I spoke to soon

Posted on Saturday, 4 August, 2007 by Colin Mackay

Looks like I spoke too soon. I was all resigned to go through and install Katmai (SQL Server 2008) in a new virtual machine, when it occurred to me that I could just uninstall SQL Server 2005 Express Edition as … Continue reading →

Posted in Uncategorized | Tagged , | Leave a comment

SQL Server 2008 (July CTP): More installation woes

Posted on Saturday, 4 August, 2007 by Colin Mackay

I’ve done it again. I’ve attempted to install SQL Server 2008 (this time the July 2007 CTP) and it hasn’t quite gone the way I expected. This time there was no Management Studio. Why? Well, when I tried to go … Continue reading →

Posted in Uncategorized | Tagged , | 4 Comments

Installing SQL Server 2008 (Katmai)

Posted on Tuesday, 3 July, 2007 by Colin A. Mackay

I’m just installing SQL Server 2008 (Codenamed Katmai) June 2007 CTP. The installation isn’t without its problems – which is fine for the moment. It is a CTP after all. The main problem is with the prerequisits. The installer will … Continue reading →

Posted in Uncategorized | Tagged , | 2 Comments