Changing Microsoft SQL Server Collation
June 18, 2014
The situation: You have a SQL server with a server collation that is incorrect for your usage and you need to change the entire server collation as opposed to a single database.
Category: SQL
Posts primarily about Microsoft’s Transact SQL (T-SQL) and Microsoft SQL Server – with a little bit of MySQL and standard SQL thrown in for good measure.
TSQL IsNull vs Coalesce
November 5, 2013
TSQL IsNull or Coalesce? The SQL Server Engine Tips Blog explains the differences nicely.
Enable Remote Connections in SQL Server
May 9, 2013
This blog post by Daniel Walzenbach (Microsoft) explains beautifully how to troubleshoot the “enable remote connections” message in SQL Server.
How to do a Dump
April 10, 2013
LINQPad is a nice piece of software for testing LINQ queries (or any other code, really!) The default input method (or ‘language’) is set to “Expression”. However, using the “Statement(s)” language, you can enter more than 1 line of code and it will evaluate it for you. To inspect a LINQ statement using Statements (like … More How to do a Dump
MySQL in a .NET App
February 22, 2013
When you have the MySQL .NET library installed on a local machine and want to deploy an Entity Framework application to a server without the library installed, I always (thus-far without fail) forget at least one of the following: EntityFramework.dll – set to copy local MySql.Data.dll – set to copy local MySql.Data.Entity.dll – set to … More MySQL in a .NET App
Duplicate Tables
July 24, 2012
SELECT * INTO NewTable FROM OldTable Absolutely brilliant snippet of SQL. NewTable doesn’t even have to exsit – it copies the schema from OldTable. Also, as suggested here, you can just copy the schema (without contents) by doing: SELECT TOP 0 * INTO NewTable FROM OldTable From what I can make out, this functionality was … More Duplicate Tables
