Archive for the ‘SQL Server’ Category

Geocode Addresses in T-SQL

May

Just wanted to pass along this article from SQLServerCentral on how you can use Google’s Geocode API within T-SQL. This is some very slick code. Geocode Addresses in T-SQL

(read the rest)

SQL Server Management Studio: Fix Saving Changes Not Permitted Error

Apr

by Mike Fleming at 7:05 am SQL Server | SQL Server

If you have been working with Microsoft’s SQL Server Mangement Studio 2008 tool for any period of time, you have do doubt seen the message below: Your only real option… (read the rest)

(read the rest)

SQL Server: Set up Linked Server to MySQL

Feb

by Mike Fleming at 7:57 am MySQL, SQL Server

I saw a post yesterday that explains the simple process of setting up a MySQL database as a linked server in Microsoft SQL Server. SQL Server has had the linked… (read the rest)

(read the rest)

Resolving SQL Server Deadlocks with SQL Profiler

Feb

by Mike Fleming at 7:03 am SQL Server

I have blogged about the wonderful use of the SQL Profiler in SQL Server before. The guys over at SQLServerCentral.com have another article with some awesome tips on using the… (read the rest)

(read the rest)

SQL Server Script to Search For a String in a Table

Jan

by Mike Fleming at 7:33 am SQL Server

I had an urgent request the other day to find all the pages on a site that contained a certain string of text. The entire website is dynamic, so all… (read the rest)

(read the rest)

Dynamic ORDER BY Clause in SQL Server Stored Procedure

Nov

by Mike Fleming at 8:09 am SQL Server

Have you ever needed the ability to pass in your sort variable to a SQL Server stored procedure? At first thought you would think you could do the following: ORDER… (read the rest)

(read the rest)

SQL Server Profiler

Nov

by Mike Fleming at 7:00 am SQL Server

I do not want to cover everything that can be done with the SQL Server Profiler here, but I do hope that most of the advanced developers out there who… (read the rest)

(read the rest)