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.
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. Advertisements
TSQL IsNull or Coalesce? The SQL Server Engine Tips Blog explains the differences nicely.
This blog post by Daniel Walzenbach (Microsoft) explains beautifully how to troubleshoot the “enable remote connections” message in SQL Server.
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
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
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
