SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help
Today I want to talk about a common issue where we want to get a distinct list from a parent table, having a filtered value from a child table that may have many records. Here’s an example to explain the scenario, and it’s one that happens quite often. Let’s say you want to get a list of regions. For each […]
One of the cool features of Entity Framework is the ability to execute queries against multiple tables in a single round trip. It does this by combining all of the attributes from each table into a single result set. This works really well until you start joining to related tables with more than one record. When you think of an […]
Where have use cases gone when it comes to documenting software? I’ve been given all kinds of requirements, many from templates with all kinds of things for analysts to complete. However, I haven’t seen a Use Case in years. A use case is very simple, yet provides some very valuable information. It defines a business process your system must implement. […]
We’ve been talking about optimizing a database when it has a lot of data, at least from an indirect standpoint. What starting me on the topic was the use of an INSTAEAD OF trigger for something other than improving performance. INSTEAD OF triggers were designed to allow a DBA to spread data from a single large table across multiple tables […]
Today I want to review the concept of the INSTEAD OF trigger, and the original reason it was added to SQL Server. When earlier versions of SQL Server were continuing to be adopted by bigger and bigger data sets it would sometimes degrade in performance as the number of records increased. We started getting millions, billions, and even trillions of […]
It’s a complex topic and area to cover – we’ll be talking about it on the webcast today, but I have questions… With cloud, on-premise, even different ways of implementing both, do you find that assessing your environment has gotten a whole lot more complex? I know with our systems, it sure has. Sure, the basic pieces are there – […]
So much is happening on the data management and protection front. From movies to injection to keys to your data… There are a number of issues to know about on the show today – make sure you check it out and let me know of others we should be watching out for. Here’s a link to the show: https://sswug.org/katm/uncategorized/sql-injection-security-and-thoughts
It’s happened again. That conundrum of expedience over longevity. The design for the immediate, the just get it done mentality, over building software using well proven design patterns that last. I was talking with a colleague who asked me what I thought about making a database change using a Materialized View and an Instead Of trigger to handle a simple […]
You have SQL Servers you need to secure. But where do you start? In this presentation, we’ll look at how to do a security risk assessment on SQL Server. First we’ll start off with how to present your findings to management. What information do you need to give them? What will sway them to your side? We’ll then switch to […]
Practical application of social data streams is something that should change a LOT to do with our lives. Here’s one example, with all sorts of interesting ramifications…your mood and reception to the movie you’re watching. I saw this post about some work Disney is doing to figure out how people respond to movies. I think it would be fascinating to […]