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

A Clock With Benefits

One of the difficulties I think that developers face is that so few people understand what actually goes into producing software. The end result that a user sees can mask the effort and complexity of the underlying code. A person … Continue reading

Posted in Editorial | Tagged

The Log Chain

I ran across a question recently from someone that received a similar message to the one showed in this image: In this case, the log chain is broken. I’ve received this message, usually from a script that is automatically restoring … Continue reading

Posted in Blog | Tagged , , ,

Surfing

How many of you have gotten up before dawn, driven to the coast, gotten on a long piece of fiberglass and paddled into the ocean before turning around to ride back to shore? It’s a great way to start your … Continue reading

Posted in Editorial | Tagged

Pick the Right Database in Azure

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Another quick post, because this is something that’s annoyed me regularly. Hopefully writing this will help me make fewer … Continue reading

Posted in Blog | Tagged , ,

Why Use Version Control?

I’ve spoken with quite a few people in the last few years that don’t see enough value in version control to actually implement it. Most of them agree using a VCS is a good idea, but they aren’t doing it. … Continue reading

Posted in Editorial | Tagged , , | 2 Comments

The Road to Success

I heard this quote recently from Dan Wood of Northwest Cadence. “The road to success is paved with cobblestones.” The meaning is that as we get better and gain success in those things we attempt, it will be a bumpy road. If you’ve … Continue reading

Posted in Editorial | Tagged ,