Version Does Matter I received an Email from Michelle Poolet today. Michelle has a business providing support for SQL Server databases. As a result, she works with many different customers, each with unique problems and solutions. They also have many of the different versions of SQL Server available from Microsoft today. Michelle writes: Let me tell you about an incident […]

SSWUG TV – Interviews with Bob Zurek from Endeca and SSWUG.ORG Presenter Laura Rose. We also have the latest news on SQL Server 2012, product features from Sanbolic and insights on cloud computing from SQL Server MVP Stephen Wynkoop. [Watch the Show] SSWUG TV – Interview with Denny Cherry, SQL Server MVP and SSWUG.ORG Class Presenter. We also have the […]

String Comparison When doing searches on string data there are a number of comparison operators that are popular. I’ll give you a few from SQL Server. The = operation is the most common where you wish to strings to be exactly the same. Depending on your database and/or table configuration the = comparison will or will not be case sensitive. […]

Remoting I received this question from a reader regarding how to get applications operating on two different PCs to communicate. That is a broad topic, with many answers. So, today I thought I would consider one of the most difficult methods in Dot Net, which is Remoting. Obviously, there are a lot of other techniques/specifications to accomplish the same thing […]

Security When we think about security we often focus on things such as encryption, policies, procedures, building access processes, passwords and the like. We even look into tools for secure Email messaging. However, many of us walk around with the keys to the company residing in our laptop. Often, if we are developers, we have the source code in some […]