Tag Archives: databases

Virtual Data

Posted on February 20, 2018 by

Yesterday I republished an editorial from 2014 for the holiday. The topic was production subsets of data, which has been something that many data professionals have struggled with for years. Many of us have built scripts to delete, change, obfuscate, or alter … Continue reading →

Posted in Editorial | Tagged , , ,

Looking Back at Build–CosmosDB

Posted on May 24, 2017 by

Part of a series looking back at Build 2017, going over the 20+ pages of notes I took. One of the big announcements at Build 2017 was the release of CosmosDB. This is a rebranding of DocumentDB, the document store … Continue reading →

Posted in Blog | Tagged , , ,

The Great and Powerful Internet of Things

Posted on February 2, 2017 by

Will we have the IoUT (Internet of Useful Things? As some have said, the IoS (Internet of Sh**e) is really what we have because of the poorly built, poorly secured hardware and software devices. It seems that almost every month … Continue reading →

Posted in Editorial | Tagged ,

The Purpose of a Database

Posted on January 23, 2017 by

A great quote from a blog on machine learning in SQL Server: “…nobody buys a DBMS for the sake of DBMS. People buy it for what it enables you to do”. The post is from Rimma Nehme, who has given … Continue reading →

Posted in Editorial | Tagged

Writing the Correct Query is Important

Posted on January 16, 2017 by

There’s a saying in the data world: garbage in, garbage out. We use that when we can’t get good information from our database because the data we’ve stored isn’t as useful as we would like. That’s a problem, and it’s … Continue reading →

Posted in Editorial | Tagged , ,

Looking Back at 2016

Posted on December 29, 2016 by

We’re coming to the end of a crazy year. 2016 has seemed to be one of the craziest of my life with world events like Brexit and the US election as well as an astounding number of data breaches. More … Continue reading →

Posted in Editorial | Tagged | 1 Comment

THE Database Engine

Posted on November 14, 2016 by

Is there a “best” database engine? Is there one database system that you can use for all of your needs? The question is addressed in a long, but captivating, piece at O’Reilly. The author talks about finding an HTAP database, … Continue reading →

Posted in Editorial | Tagged | 2 Comments

One Million

Posted on October 19, 2016 by

Is a million writes/sec a large number? I guess it’s all relative, but I’d consider it a fairly large number. Our peak transfers for SQLServerCentral are in the hundreds/sec, though we’re not really a busy database server. Some of you … Continue reading →

Posted in Editorial | Tagged

Yet Another Database

Posted on October 17, 2016 by

The “yet another” moniker is used throughout technology. YAAF, YARN, YAML, and more ways that people talk about yet another way to solve some problem or build a platform. That’s one of the amazing things about technology is that we, … Continue reading →

Posted in Editorial | Tagged

Where’s the Unit Testing?

Posted on July 25, 2016 by

I’ve been a proponent of Unit Testing, especially for databases. I’ve given presentations on the topic and advocate the use of techniques to verify your code works, especially over time when the complexity grows, new developers change code, and potentially … Continue reading →

Posted in Editorial | Tagged , ,