Today I wanted to talk about the difference between the WHERE clause and the HAVING clause in a SQL query. They both filter the data that is returned from the query, but the work quite differently. The WHERE clause is completely independent of the HAVING clause. If you specify a where clause in your query, every record returned from the […]
Tag: Editorials
Basic Joins – CROSS JOIN
A while back I was sharing some of my favorite SQL Developer interview questions. The one I shared was about the different kinds of JOINS operations you can do in any SQL relational engine. We talked about INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN and FULL OUTER JOIN. One of the joins I left out of the basic set […]
Think Small To Make Big Changes
One of the best resources I have found for database development was by Scott Ambler, “Agile Database Techniques.” The primary reason I say that is not to espouse the Agile Software Development Lifecycle as much as to encourage many incremental improvements. One of the things the Japanese auto makers started was a different way to introduce new features in their […]
Budget For Long Term IT Resources
Why can’t we budget to replace IT Systems? This is a common problem for many companies. They are willing to purchase many things to make their business run. But, it is difficult to absorb the cost of those resources that have a shorter duty cycle. A manufacturer can purchase a CNC machine, and have reasonable use if operated properly for […]
Applying AI
Is AI in your (near) future? How would you see it fitting in – at any level of functionality? It’s a huge push for upcoming releases – at Microsoft Build AI is all over the presentations, the tools, the direction for Microsoft. I wrote briefly about it earlier, talking about SQL Server and the integration of AI and machine learning. […]
VbScript Is Not Dead
One of the cool things (or bad things depending on how you look at it) about my job is that I get to work with many different tools at different application layers. I get to do DevOps kinds of work, data warehousing, transactional databases, Object/Relational Mapping, REST Services, WCF Services, Java Script, MVC Applications on both the server or on […]
Planning for Expansion and Contraction
Planning models are changing, along with the considerations as projects are starting. It’s interesting to see the influence of technology capabilities coming to be considered as part of mainstream applications and solutions development. In particular, the thing we’re starting to see and feel as an important piece of the overall solution puzzle is the bookend issue of expansion and contraction. […]
Learning Linq From SQL
One of the things I like about working in Dot Net is the Linq libraries. Having worked in SQL for so many years I have found my brain twisted to think in sets. There are so many things we do with sets, yet the sets we have available are not always in a relational database. Linq fills that gap quite […]
Why Upgrade Dev Tools?
One of the cool things about the separation of the Dot Net CLR and the Dot Net Compiler is that newer syntax implementations may be made in the compiler that are backward compatible with the Dot Net libraries that the CLR supports. If that confuses you, just hang on and I’ll lay out some examples that should make it more […]
UNION Set Operations
We’ve been looking at some of the set based operations that are part of the SQL Language, and different ways to achieve the same results. Today we add to the discussion the UNION operation. There are two varieties of the UNION operator, UNION and UNION ALL. The UNION operator takes two sets of data, combines the results, and then returns […]