SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help
Clearly, “data” on its own isn’t very helpful. That’s like saying “let’s look at a bunch of numbers, k?” and then presenting your worksheet with columns of information with no headings, no indication of what you’re looking at or what it represents. Yikes. You won’t have that position for very long. The job of making sense of it all is […]
Dynamic SQL using Entity Framework is a really cool capability. You can use dynamic SQL for any number of reasons. I have used it for custom filters, custom ordering, and other SQL features when you are able to work in Pure SQL while still having the benefit of SQL Injection protection through the user of execution parameters. There are other […]
With makers of home automation devices being pressured to release data that’s collected passively from those devices, it’s clear that data platform folks have their work cut out for them. Just recently Amazon has agreed to hand over information from their Echo service that may be helpful in a murder investigation. (ref: Gizmodo) I think this is pretty significant. I […]
I’ve been using Entity Framework for a few years now. Having some production applications based on EF I have found some of the following guidelines to make it work for me. EF is fine for Many to Many relationships. In doing so, you create your data models with having virtual collections of the other object. Then when you map the […]
Choosing a provider is incredibly important when it comes to the cloud. There are some fundamental differences in approach between the providers. There are several components to selecting a provider and, for a while now, I’ve felt like one of the biggies is less obvious – the approach you want to take to managing your resources. My own experience with […]
Today I wanted to share an implementation of a proxy pattern for SQL databases. This story comes from a dot net implementation from a very large scale, with multiple web services all hitting the database server concurrently. The problem is that when enough services are operating, especially when they are clustered or use load balancing technology, the SQL database server […]
Sessions, sessions and more sessions. From experts, authors and MVPs that are really here to share their expertise and lessons learned… free. Doesn’t get any better. You can register today! I’m really excited about the upcoming SSWUG.org Virtual Conference. Where other online events (and even some in-person events!) have a few sessions about SQL Server that you have to pick […]
Recently I have been enjoying the use of a proxy pattern. A proxy is a software object acting in place of another software object. For example, I was developing a software system for which the SQL database did not yet exist. So I wrote a simple provider that would perform my crud operations, and save them to a disk file. […]
It’s incredible what you can do with your data centers, the ease of access to functionality, tools and such is increasing daily, and already stunning. It does come with a cost. I was reading this article from DBTA and I think they hit the nail on the head for why cloud services may surprise some people when it comes to […]
Any reader of Science Fiction, especially space science fiction, knows that a lot of things that were dreams and ideas in books have become reality today, or there are active projects working to make it so. Our robotics technology is bringing us closer much faster for things like automated vehicles, service, warfare, and much more. There is really a plan […]