Tag: SQL Server
-
SQL project flag Invalid objects when run from Azure Pipelines
—
For most of my .Net solutions, I define the database in a database project (SQL Server Data Tools or SSDT) in the solution and use that to deploy to database server(s). For additional QA, using Azure Pipelines, I often spin up a localdb instance and deploy the database to it, after which I can run…
-
A (more) concise way to test a SQL MERGE for differences if there are nulls involved
—
in SQL ServerIn SQL, if you need to compare two columns that are both nullable, your compare statements can quickly get out of hand (and a lot less readable along the way). While fixing a bug in my code, I found out about a way to keep the comparison short and readable using the EXCEPT (or INTERSECT)…
-
If you publish a WCF service using EF to IIS, do not forget to distribute sqlserver.dll manually
—
I’ve spent several hours this week debugging a WCF application using Entity Framework, that was published to an IIS server, only to have every call to the service fill with the error message “The type initializer for [My]DbContext has caused an exception”. Of course, on the dev machine everything was working fine. Short answer: as…
-
An underrated operator: using EXCEPT in MS SQL Server to track changes
—
in GeneralWorking with a colleague who is a longtime Oracle user, I noticed he used an operator I didn’t know of, to grab hold of the differences in rows between two nearly identical tables: he used a “minus”. I couldn’t imagine MS SQL Server would not have something like it and it didn’t, it came up…
-
Update to SQL server tooling for Visual Studio
—
MS recently released the “March 2014” update to the SQL Server tooling for Visual Studio 2013, which was named SQL Server Data Tools for previous Visual Studio versions. Among the most notable new features are support for SQL Server 2014 and several productivity updates that simplify development and testing, also on SQL Azure. Read more…
-
SQL server views performing really bad when referencing a linked server
—
in SQL ServerWe had a view in SQL server (2008) that consisted of a simple SELECT with some fields from a table that was on another database server (an Oracle database even). Performance was not a problem, the query took less than a second to complete. Until we had to add a left join to another table…
-
SP1 for SQL server 2008R2 brings back Intellisense to SMSS
—
in GeneralYay! Installed Service Pack 1 for SQL Server 2008 R2 today. Among other fixes, it brought back IntelliSense support in SQL Server Management Studio, which had been broken since I installed SP1 for Visual Studio 2010 on that machine. So those of you that were bothered by the same issue, are advised to install the…