I need your help We’re looking to learn more about decision-making in the industry – and specifically how it works in your own organization. You can win a $50 Amazon gift card too – but whether it’s for the chance to win or to help out, we really need your feedback. The ways decisions are made, and who makes them, […]

Today I was talking with a colleague about a performance issue he was having on a SQL Server instance. It reminded me of a few war stories that may be of interest. The key point I want to make is based on data dissonance. Data dissonance is when you are joining or searching for data where one or more columns […]

Many applications use ORM tools and generators that provide a lot of bells and whistles. The more functionality added to the ORM, the less responsive they seem to become. You’ll find ORMs with Cache, relational mapping, data change migration, repositories, all on top of interacting with the data store. I have an application using Entity Framework that takes a few […]

Swallowing errors is not a good practice in software development. But it is often done because it’s the least path of resistance. What do I mean by Swallowing errors? Most of you understand this term. For those of you who haven’t heard this phrase, Swallowing Errors is the technique where we capture errors, do nothing with them, and allow the […]

If you have been following the Dot Net world lately then you will know how Open Source is impacting the development of the framework. I watched a presentation by Jeffrey Fritz, who is a senior program manager with the Microsoft Developer Outreach Group, regarding the impact of open source contributions to the Dot Net framework, and its specific impact on […]

There are times when you need to store information for configuration or tracking SQL operations. This can be true regardless of the SQL engine you use. I have found that a simple, Key Value pair, table definition allows me to flexibly store and retrieve data inside a database, allowing it to be accessed by SQL queries without having to make […]

Today I wanted to open a conversation comparing two different dot net implementations of web services. Windows Communication Foundation (WCF) has been with available for many years, and is quite powerful. A later technology started as a RESTful api, hosted originally in WCF, but was later released as Web API. Both implementations have grown to be mature products. WCF was […]

Webcast Today – and It’s Free! (just have to get registered!) Today’s webcast will be a great look at in-memory OLTP – here’s the summary: SQL Server 2016 greatly improves the performance and ease of use for In-Memory OLTP. In this session we give a recap of the In-Memory OLTP feature, discussing scenarios as well as expected performance improvements. We […]

What was null!? I’m sure you’ve had your share of frustration asking the question, what was null, when receiving an error message in your application stating that you have “An unhandled exception of type ‘System.NullReferenceException’ occurred in…’ and then gave you the name of your exe or dll causing the error. If you’re like me, your response is something like, […]

What’s Your Favorite Data Tip? We would love to work with you to show off your data management skills to data professionals around the world. The call for speakers is currently open for the SSWUG.ORG Fall Virtual Conference. Now, I know a lot of people shrug off speaking because of time, or because you’ve never done it before. Or because […]