Category Archives: Editorial

A SQL Server Bug and Data Security

This week I saw a post from Microsoft Tiger Team on the issues with backup compression and TDE databases. Apparently when they added compression, they didn’t test a few edge cases. Or a few regular cases, like WITH INIT. There … Continue reading

Posted in Editorial | Tagged | Leave a comment

The Flash DBA

The job as a DBA is the job. That’s been my view for a long time, which is why I am always concerned about the staff when I interview. The people I work with make the job good or bad. … Continue reading

Posted in Editorial | Tagged | Leave a comment

A SQL Server Bug and Data Security

This week I saw a post from Microsoft Tiger Team on the issues with backup compression and TDE databases. Apparently when they added compression, they didn’t test a few edge cases. Or a few regular cases, like WITH INIT. There … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Help from Cortana

I’ve been reading about and watching some of the experiments that people are conducting with Cortana and other types of devices. I’m not quite sure what I think, though I would like to experiment with Cortana at some point and see how … Continue reading

Posted in Editorial | Tagged , , | Leave a comment

The Avalanche of Cloud Computing

Cloud computing is growing fast. The leader, Amazon and Microsoft, continue to show more and more customers using their platforms every quarter. I do truly think that an increasing number of organizations are thinking cloud first for application development. That doesn’t … Continue reading

Posted in Editorial | Tagged | Leave a comment

Interviews: What is ACID?

I once had a job interview with a large group of employees at a company. They were arranged around a table, with me at one end. The interview was a round robin affair, with someone asking me a question and me answering. … Continue reading

Posted in Editorial | Tagged | 2 Comments

The Library Job Hunt

I was reminded of the ways I’ve looked for jobs by a post from the Job Headhunter about library time. Rather than looking for what jobs are available, the recommendation is to take a targeted approach of using the library as … Continue reading

Posted in Editorial | Tagged | 1 Comment

The Full Court CosmosDB Press

This year at the PASS Summit, Dr. Rimma Nehme (b|t) will give another keynote address. She has spoken at a number of previous Summits, and is a very popular speaker. This time her topic is CosmosDB, which is where she’s been … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Voting for Change

Microsoft does listen to us. They’ve made a number of changes in SQL Server 2016/2107 in response to community votes and requests. The main way to make these is through Connect, though keep in mind that lots of items get filed, … Continue reading

Posted in Editorial | Tagged , | Leave a comment

I Will Write Bad Code

I’ll write bad code. I know it will happen. I’ll produce a bad query, incorrect logic, or the wrong data transformation being returned. This won’t be a malicious act. It might be because of ignorance, or perhaps just a simple … Continue reading

Posted in Editorial | Tagged , | Leave a comment