We learned some things based on questions, speakers and attendance in sessions, along with survey results from the event. It was interesting to see sesions and interaction and see if we could determine how things are morphing over time between events, the site, articles and so-on. One of the surprises, for me at least, was the interest in AI. While […]

We recently talked about the logical Semi Join operation and the Anti Semi Join operation, and demonstrated method to generate those logical joins using traditional SQL operations found in just about any SQL engine. They are produced by using the IN or EXISTS operation for a Semi Join, or the NOT IN or NOT EXISTS operations for an Anti Semi […]

I have written in the past about using previous versions of a project as the requirements for a new and better product as being an exercise in futility. Without requirements, you don’t know where your are or when you are done. Today I want to talk about another process that is somewhat similar. That is where you have inadequate requirements […]

One of the things I like to do when a new version of a database engine is released is to compare the performance of different query techniques. Doing this comparison results in information that helps in understanding the optimizations that have been introduced with each release. I find it helpful to dispel assumptions of how certain syntax typically performs under […]

One of my favorite things to ask during an interview for a developer who is going to be working with databases is to enumerate the different kinds of joins that are standard in most SQL engines. Not only naming what they are, but how the work, or better yet, how they may be utilized is a great follow on series […]

If you’re not registered, this is the last day to get in on all of the sessions. The SSWUG.ORG Data Platform Virtual Conference kicks off in the morning (May 2) – it’s free, but you need to register to attend. http://www.sswugvc.com The event kicks off first thing in the morning tomorrow (May 2) and continues on Weds (May 3). Registration […]

From a conversation we were having in the comments from last week I was comparing the query plan produced from using different ways to retrieve the same results from the database. Just for fun, I used a new SQL Server 2014 instance for my test, comparing two system tables, sys.sysobjects and sys.indexes. I wanted to find a list of all […]

Many thanks to Brian Moran for sharing a bit of information from Gartner – about Chief Data Officers; is this in your future? It’s interesting because clearly this is something that needs addressing for systems, and “addressing” is going to take on all new meanings as we define data and how it’s stored, used, etc. The report indicates that by […]

Connected items, the Internet of Things and data collected there are all coming together, and in ways that perhaps aren’t so clear, but impact us all significantly. I will tell you that I’m still madly reading and lookikng through diffrent DMCA and copyright things, but the general push for this post is about copyright and ownership of code. Sort of […]