Categorie: 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…
-
Clear user objects from master db in Microsoft SQL Server
—
in SQL ServerEarlier this week I ran a script that inserted a lot of objects into a (new) database on my local machine, but forgot the USE newdatabase statement at the top. You guessed it… all my objects were created in the master database, and there were a lot of them. Deleting them by hand would be…
-
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)…
-
You cannot use a null propagating operator in an expression tree lambda
—
One of the features I like about the new C# 6.0 is the null conditional operator, and I tend to use it everywhere I can (and should). Until yesterday, when at a statement I wasn’t expecting it, the compiler bit me with error CS8072, An expression tree lambda may not contain a null propagating operator.…
-
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…