SQL Server

Geocode Addresses in T-SQL

By mfleming ⋅ May 20, 2010 ⋅ Post a comment

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

SQL Server Management Studio: Fix Saving Changes Not Permitted Error

By mfleming ⋅ April 2, 2009 ⋅ Post a comment

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 here is to click the cancel button and wonder aloud how the heck do you update your table. In short this message means that the [...]

SQL Server: Set up Linked Server to MySQL

By mfleming ⋅ February 26, 2009 ⋅ Post a comment

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 server functionality for years now. In short it allows you to set up a data connection to another RDBMS and grab your data from it. [...]

Resolving SQL Server Deadlocks with SQL Profiler

By mfleming ⋅ February 2, 2009 ⋅ Post a comment

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 Profiler to determine where deadlocks occur and in one particular case how to solve them. Fantastic read if you do a lot of work with [...]

SQL Server Script to Search For a String in a Table

By mfleming ⋅ January 29, 2009 ⋅ Post a comment

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 the content lives in the database. I came across an article from MSSQLTIPS.com that showed a nice little stored procedure to search for a string [...]

Dynamic ORDER BY Clause in SQL Server Stored Procedure

By mfleming ⋅ November 12, 2008 ⋅ Post a comment

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 BY @orderVar But, no dice. SQL Server will not allow you to set the ORDER BY clause with a variable. There are two solutions to [...]

SQL Server Profiler

By mfleming ⋅ November 11, 2008 ⋅ Post a comment

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 use SQL Server regularly are familiar with it. It has many uses, but for me it has become an invaluable tool to help find some [...]

Search

Categories