Geolocation has become a part of the life of anyone using an electronic device today. Often times we are not even aware that it is being used. Smart Phones often have the ability to perform GPS capabilities. Some stored have found they can capture your GPS information from your Cell Phone and determine where you are shopping while in their […]

Today I had the opportunity to learn more about the database connection settings and how they impact query performance and behavior. When you connect to SQL Server there are a number of connection settings. A key setting for the performance of your application is Arithabort . Arithabort determines the behavior of SQL Server when it encounters different mathematical errors such […]

Some predict the internet is fragmenting. It was not designed with the level of security in mind that we have come to require. Moreover, governments and organizations have broken into data assets not intended for their purposes under many guises of legality. Irrespective of the legality, individuals are not willing for their personal information to be monitored. The fragmentation is […]

The decision to use a Delegate over inheritance is pretty straight forward in my simple understanding. Inheritance is best when you have a number of methods or properties that must follow a specific contract, ie. an interface. When all you want to do is to dynamically determine what method to call, which may have a different internal behavior, but share […]

Today I want to talk about a time when I had to optimize some dot net code. I started using Linq. But the code didn’t perform fast enough (probably because I was a novice at Linq). I needed the fastest performance when joining data from two collections? I’m not sure Linq is the fastest…but generally it is good enough. One […]

Here’s a quote from the Fellowship of the Rings; “Sometimes it’s the little things that change the world.” I have found that to be true when working with databases. There are a few things that can make all of the difference in performance and accuracy. Here are some examples: Use appropriate normalization for an application: Denormalize may be appropriate for […]

Did you know that Microsoft supports two different kinds of queuing in the Azure Platform? You can view a comparison of both at http://msdn.microsoft.com/en-us/library/hh767287.aspx. There are Azure Queues and Service Bus Queue. Each have their own characteristics. Queues are a basic Rest based technology built on top of the Azure Storage Infrastructure for reliable messaging between services. Service Bus Queues […]

Greg writes in as a response to using an SQL Server table as a queue instead of a queuing service. His requirements are simple, and this method works well for them. Regarding your question about queues in SQL Server, we have an application that uses SQL Server as a queue for emails. We decided to take this approach instead of […]

If you are new to SQL Server you may not know about connection pooling, a topic I have been returning to quite a bit lately. Pooling may be turned on and off in the database connection string. However, if the connection string is not properly formatted it can end up in an unknown state. There is nothing you have to […]

I have written here on SSWUG a few times with tips or articles about how to use SQL Server tables as a queue. It’s rather simple to do and quite effective. Today I wanted to ask a few questions about this practice. There are some alternatives available today that you could use for queuing instead. For example, you could use […]