Editorials

Editorials

Chain of Ownership, Data, and AI

Interesting points about the whole artificial intelligence thought process.  It’s come up before that assuring the chain of ownership and who did what to information is critical when it comes to the trust of information.  If you don’t know how numbers were derived, or who modified them since they were calculated, how can you trust them? I’ve felt this uneasiness […]

Editorials SQL Server

Machine Learning, AI, Automation in SQL Server, Oh My!

There has been quite a bit done on the intelligence front with SQL Server – as in built-in functionality and changes that will help you bring these tools not only to the environment, but also to your own applications. As one example, In-database Machine Learning in SQL Server 2017 – “You can start using Python-based in-database Machine Learning Services for production […]

Amazon AWS Azure Editorials

Vendor Lock-In Challenges

I have to admit, I approached the whole question yesterday quite differently that everyone else.  I was worried more about new standards, development trajectories, compatibility and so-on.  When I wrote about the vendor-specific database flavors… I missed what could certainly be the larger issue. John Shadows wrote: 100% cloud also means you have to play by the cloud rules all […]

Amazon RDS Azure Editorials

Would You Use a Provider DB Engine?

Perhaps one of the odder questions I’ve asked.  For example, would you use a Microsoft-branded tweaked database platform?  Would you use an Amazon-branded, or Google-branded of the same? The major players seem to see these as the way forward, and I have to admit it has me both intrigued and baffled.  A strange combination for sure. With Microsoft, it’s Cosmos […]

Editorials

Claims Based Identity

I’ve been working through the different frameworks Microsoft has used in Dot Net for Authentication and Authorization of users. I’ve worked my way forward into the Dot Net 4.5 consolidated implementation of Claims Based Identity. The move to using Claims for Identity was a strategy shift from managing a set of fixed scalar values to managing a set of claims […]

Editorials

Identity

Identity is a central focus of most applications. The topic involves authenticating that the user is who they claim to be, and authorizing access to appropriate aspects of your application. Both of these concepts are bundled in the topic of Identity. It’s been a problem for which there have been many different solutions over time. Remember the Microsoft Passport and […]

Administration Amazon AWS Azure Azure SQL Database Editorials SQL Server

Managing Your On and Off-Premise Infrastructure

Increasingly, as we’re working with people to help out with infrastructure and with setup and considerations for their servers and solutions (wow, that’s a long breath), the trend is about handing off to cloud providers… That’s all well and good, but there’s a bit a devil in the details, so to speak.  One of the things that seems to be […]