-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Ed Elliott's Sql Developer Blog

Ed is a Sql developer who has a mixed background in support, as a dba and as a developer working with a number of languages c, c#, vb, go, assembly with a variety of technologies and is currently trying to make the sql developer community a little bit more agile, one build step at a time!

tSQLt Visual Studio Test Adapter

tSQLt Visual Studio Test Adapter

What is this?

This lets you use Visual Studio to run tSQLt tests easily. Visual Studio has a built in framework for finding and executing tests so that if you have tSQLt tests in an SSDT project for example, although this just requires you have…

Read more

0 comments, 1,532 reads

Posted in Ed Elliott's Sql Developer Blog on 17 August 2016

DacFxed - Powershell Nugetized DacFx wrapper

Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open a dacpac, compare to a database and either create a script or get the database to look the same as the dacpac but there are a couple of problems with…

Read more

0 comments, 412 reads

Posted in Ed Elliott's Sql Developer Blog on 2 August 2016

SQLCover v 0.2 - Bug fixes and Azure V12 Support

I have released a new version of SQLCover which is a code coverage tool for T-SQL (let's you identify where you need to focus when writing tests).

This includes a few minor fixes but also support for SQL Azure so if you run your test in a v12 database or…

Read more

0 comments, 390 reads

Posted in Ed Elliott's Sql Developer Blog on 5 May 2016

Where do you put your business logic? In stored procedures?

There seems to be two trains of thought and I think this is mainly down to who and where your developers are. The first is that a stored procedure or a function is a great place to put all the business logic that an application needs. The second is that…

Read more

0 comments, 3,779 reads

Posted in Ed Elliott's Sql Developer Blog on 5 May 2016

How do you audit automatically generated sql deployment scripts?

I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because of the restirctions put on them by the requirements for auditing and the ability to be able to demonstrate exactly what was deployed at what time.

When automating deployments it…

Read more

0 comments, 679 reads

Posted in Ed Elliott's Sql Developer Blog on 3 May 2016

What is code coverage for?

Code coverage gives you an indication of how well tested a particular area is. It is not a measure of code quality and having a statement covered by a test does not mean that the code is accurate.

Using code coverage you can see how risky changes are to a…

Read more

0 comments, 366 reads

Posted in Ed Elliott's Sql Developer Blog on 11 April 2016

SQLCover Code Coverage for SQL Server T-SQL

Open Source code coverage tool for T-SQL, SQL Server 2008+

What is code coverage?

Code coverage is a way to see how many statements in your database code have been executed when you ran your tests(s). It is a way to see how well covered with tests a particular area…

Read more

0 comments, 2,019 reads

Posted in Ed Elliott's Sql Developer Blog on 8 April 2016

Post Deploy Scripts In Composite Dacpac's not deploying

Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy into a database as a whole. Even if you have a fairly simple database in a single SSDT project you should put your unit tests somewhere. What I like to…

Read more

0 comments, 431 reads

Posted in Ed Elliott's Sql Developer Blog on 3 March 2016

Where did january go?

I have been pretty busy over january and the first half of feburary and haven't had time to write any blogs, I did have an article on simple talk published:

https://www.simple-talk.com/sql/sql-tools/connected-development-with-sql...

A couple of exciting things did happen, firstly I was allowed back into the friends of redgate programme -…

Read more

0 comments, 348 reads

Posted in Ed Elliott's Sql Developer Blog on 16 February 2016

T-SQL Code Coverage in SSDT using the SSDT Dev Pack

Code Coverage

What is code coverage?

When you write some code and then test it, how sure are you that you have tested the whole thing? Code coverage gives you an idea of how well tested a bit of code is.

If you have lots of branches in your code…

Read more

0 comments, 1,664 reads

Posted in Ed Elliott's Sql Developer Blog on 13 January 2016

What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!

In the final part of this 3 part series on what SSDT actually is I am going to talk about the documented API. What I mean by documented is that Microsoft have published the specification to it so that it is available to use rather than the documentation is particularly…

Read more

0 comments, 459 reads

Posted in Ed Elliott's Sql Developer Blog on 7 January 2016

What is SSDT? Part 2 - More Reasons to Bother!

In part 1 of this series available here I introduced my drawing of what I think SSDT is and talked about the first major category the development ide and how it can help us. Just to recap for each subject on the image I give a bit of blurb and…

Read more

0 comments, 584 reads

Posted in Ed Elliott's Sql Developer Blog on 6 January 2016

What is SSDT all about aka Why should I bother?

I often get asked the questions “What is SSDT" and I have wanted to have a single reference as to what it is as it is actually pretty big. To be clear I am just looking at the database projects version of SSDT what was originally SSDT rather than the…

Read more

0 comments, 3,295 reads

Posted in Ed Elliott's Sql Developer Blog on 5 January 2016

SSDT Migrating Data Without Losing It

You sometimes want to do things like split a table into two or move a column into another table and when you use SSDT or the compare / merge type of deployments it can be hard to migrate the data in a single deploy as you can't insert the data…

Read more

0 comments, 822 reads

Posted in Ed Elliott's Sql Developer Blog on 30 December 2015

T-SQL Clippy

I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a lot of boiler plate stuff and offers re-writes for you that mean you can concentrate on writing the useful bits of code. T-Sql Clippy is no where near as great…

Read more

0 comments, 479 reads

Posted in Ed Elliott's Sql Developer Blog on 10 December 2015

Automatically re-write non-sargable isnulls into sargable code in SSDT

"where ISNULL(column, 'DontMatch') = 'Match'" - is kind of a bad thing to do in SQL as it means that any index on column can't be used. It is a really simple thing that is a waste of time, fixing it is pretty simple but I see it a lot…

Read more

0 comments, 420 reads

Posted in Ed Elliott's Sql Developer Blog on 10 December 2015

Find duplicate indexes in SSDT

Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...

Duplicate indexes, one of the most pointless things you can do to a table that just adds pure overhead. No one likes them so SQL Developers do your DBA's a favour and stop them from ever being deployed :)

This new tool for the…

Read more

0 comments, 612 reads

Posted in Ed Elliott's Sql Developer Blog on 27 November 2015

Convert select statements in scripts into Inline-TVF's automatically

Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...

In-line TVF's are awesome, they are a great way to reuse T-SQL code without the performance penalties of multi line TVF's or horror of horrors Scalar Functions. Taking select statements and turning them into in-line TVF's is actually really really simple using the TSql…

Read more

0 comments, 501 reads

Posted in Ed Elliott's Sql Developer Blog on 25 November 2015

ScriptDomVisualizer - Now Displays TSqlParserToken's

New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part of the query that is covered by the token so it is really easy to see where you are in the script.

Honestly if you are doing anything with the…

Read more

0 comments, 577 reads

Posted in Ed Elliott's Sql Developer Blog on 25 November 2015

Changing case of T-SQL Keywords

Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...

Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person "Mr Bert Ernie" anyway I digress, whether you are working by yourself or in a team you sometimes want to change…

Read more

0 comments, 2,543 reads

Posted in Ed Elliott's Sql Developer Blog on 24 November 2015

Newer posts

Older posts