I heard this last week about an application that was attached by SQL Injection. The application wasn’t very old. I’m quite surprised at this turn of events. How SQL Injection works is well documented all over the web. Ways to exploit SQL databases through injection are simple. Blocking SQL Injection is simple as well. This is a topic I have […]

Continuing with the thoughts on using Chunky web service calls, one reader reminds us that using Chunky increases the potential for concurrency issues. Data remains in the client cache for a much longer period of time. It has a higher chance of becoming stale, and not representing the value currently in your data storage. SQL Server has a technique that […]

I’ve been reading about using chunky calls for REST based applications. This technique has been around for quite a while, and is growing in popularity. Chunky applications often implement MVC in the browser, using libraries based on Java Script. This kind of application allows you to scale, by taking advantage of the client computer browser to performa lot of heavy […]

Continuing on the theme of balancing priorities in IT roles, I want to turn, today, to operations. When I think of operations I think of the goal to keep the lights on. Change occurs slowly. Focus is placed on maintaining smooth operations with minimal disruption to systems and access to those systems. So what is there to balance in operational […]

Bursting to the Cloud In SQL Server 2016, we’ll be seeing some pretty incredible features that will fully integrate cloud and hybrid cloud solutions. One of those is bursting to the cloud – when additional capacity is needed, it’ll be possible to dynamically extend to Azure in real-time. This is a fantastic feature, full stop. I think it will relieve […]

Today I want to focus on coding in Dot Net as it pertains to comments. Folks responded to yesterday’s editorial with a position that comments are essential for them. I agree, and want to break out different kinds of comments I like to use in Dot Net Code. First there is the ability for you to define the purpose of […]

Expanding on the topic of balance I wanted to consider balance when writing custom software. There are a number of things we balance when writing code. We need our code to be understandable to ourselves and others that follow. We need the code to accurately reflect the system requirements. We need our code to be SOLID as much as is […]

If you’re like me you are constantly trying balance the different aspects of life in order to be healthy and efficient. We try to balance diet, exercise, wife, kids, family, friends, inner self, etc. All of these things take time, and if not balanced impact one another. Like a clown bicycle, having some spokes longer than another, resulting in an […]

One of the problems I have had with SQL Azure are the native restrictions for scaling data. The databases are limited in size. The only way to access large volumes of data, (a single table that is bigger than the allotted database size), from an SQL Azure database is through federation. This is always the case if you are accessing […]

I can’t believe I left out one of the key learning resources I user personally. I was just looking through my SSWUG email, and came across some courses available in the SSWUG learning center, and realized I had neglected to include this in my short list of training resources. It’s not my job to promote resources on SSWUG. In fact, […]