Today I want to take a look at what could be considered bad SQL. The difference is that the bad, or at least less efficient, SQL is the result of design decisions when creating the tables. The root cause is the choice of the string data type when storing characters in a table. When fixed length data types are used, […]

Data Security – Is Encryption Enough? Once encryption is turned on – many people step aside from worrying about data security – information security. With things encrypted, are you safe and secure and can focus on functional items? Yes, and no. The “Yes” portion comes from the fact that your data is protected if someone gets a copy of your […]

Today I wanted to look at the problem of using fixed string length data types, as a follow on to some SQL mistakes folks make. However, there was some confusion (and inaccuracies) in my example from yesterday, that I want to take a step back and clarify. I had to create a bogus query example in order to protect confidentiality, […]

I recently came across some SQL code that I was surprised to find. Sometimes I forget about some of the basic things I have learned over the years, and simply assume others know them as well. Well, that’s not necessarily true. There are always new people coming into the profession of software development, and they have their journey ahead of […]

If you have read my editorial for very long, you won’t be surprised to find that I am a strong proponent of Testing; especially automated testing. While reading up on the XUnit project found on GitHub, I came across a blog by James Newkirk, one of the major XUnit qw2contributors, sharing why he dropped the [Setup] and [Teardown] decorations from […]

in 2005 Microsoft introduced Dot Net programming capabilities to SQL Server. You could now define your own data types, functions, procedures and more using a Dot Net programming logic, while fulfilling the appropriate interface for the object type you were implementing. Since that time, many of the things users defined have become first class clients in SQL Server itself. We […]

JavaScript objects serialized into JavaScript Object Notation (JSON) has a lot of power in the transportability of fully functional transmission of data and logic in an encapsulated form. As we have been discussing, JSON is now a first class citizen in SQL Server when it comes to JSON encapsulated data, but not the JavaScript methods also included in the JSON […]

in 2005 Microsoft introduced Dot Net programming capabilities to SQL Server. You could now define your own data types, functions, procedures and more using a Dot Net programming logic, while fulfilling the appropriate interface for the object type you were implementing. Since that time, many of the things users defined have become first class clients in SQL Server itself. We […]

Let’s face it; we live in a world where object oriented programming has become the predominant technique for writing most code. At least, that is the case for most current tool sets. That being said, I find it interesting that we find ourselves embracing some features of OO, and ignoring others. For example, I see a lot of dependency injection, […]