Interesting survey came out about cloud plans – while I’m sure our audience is somewhat biased, I’m curious what others think of the findings. Specifically, in a nutshell, the findings were that Azure is overtaking AWS in terms of environment of choice where there is a preference. This last bit I thought was intriguing. I haven’t personally been able to […]

There are many things you can do to improve the performance of your OLTP system when it experiences exceptionally high volume causing the system to slow to the point of visible perception. Normalization, file separation, index and statistics tuning, memory management, and report separation are your first targets for any OLTP database. We even talked about pre-assigning keys externally last […]

I had originally asked about the success/failure of rebuiding due to trying to implement new technology, new approaches, ideas, etc. Here’s a link to the original post In our own work, our experience with our own systems and with customers has been that this is one of the hardest projects to succeed in putting together. There are so many variables […]

It’s not difficult, you don’t have to be a professional writer (though you will instantly be one) and we’d love to work with you… SSWUG is all about sharing lessons learned, things that happen in the field, thoughts about where things are going, etc. All of those things that impact someone working with data platforms. We’re actively seeking authors, presenters, […]

In dealing with high performance systems there is another method of addressing the normalization of data when it is persisted to an SQL relational database with appropriate normalization. This was alluded to by Eilenblogger in his comments yesterday. The method uses two stages of persistence. First, the data is persisted to a temporary data store with extremely fast performance. There […]

Have you worked with any machine-learning scenarios? With SQL Server? There are so many options and opportunities for starting work with SQL Server in particular and with interesting data flows in general. It’s a bit overwhelming the types of things you can do – from working across database platforms to analyze information to machine learning right in the SQL Server […]

Today I am sharing some specifics for building your own key assignment implementation, allowing you to allocate multiple key values in advance of actually creating records. When you use the database engine to create unique keys for you data you usually follow the following sequence. Add data to a table Capture the assigned key value Return the key value to […]