Monthly Archives: August 2015

Upgrading a SQL Azure Database to v12

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was looking to test some of the Azure v12 capabilities, but I needed to upgrade a database. Here’s … Continue reading

Posted in Blog | Tagged , , ,

No More Foreign Keys?

I struggle with removing FKs as a general idea. It’s presented in a piece from a developer. It appears to me that if you do this, you are merely moving the problem, and potentially causing other issues. Apart from Grant’s response … Continue reading

Posted in Editorial | Tagged ,

Adjusting Model

In July the T-SQL Tuesday theme was defaults. There were lots of posts about various items, but I found one by Kevin Kline interesting. Kevin noted that the settings for model are not necessarily what many of us would want in … Continue reading

Posted in Editorial | Tagged , | 2 Comments

tSQLt in Azure SQL Database

I was excited to hear about the v12 Azure databases supporting CLR assemblies. Mainly because I’ve been doing testing work with tSQLt and wanted to run tests in an Azure database. I upgraded a SQL Azure database to v12 and … Continue reading

Posted in Blog | Tagged , , , | 2 Comments