Category Archives: Editorial

Your Security Checkup

Recently I saw an article on Simple Talk, 15 Practical Tips for Securing SQL Server, and I thought that many of these are fairly simple things. Turn off unused features, disable sa, etc. These are things that a lot of … Continue reading

Posted in Editorial | Tagged , | Leave a comment

How Important Are Real Time Decisions?

Imagine a perfect world? I have an AI agent that knows my business well. It’s getting real time input from sales, from customers, it makes amazing decisions. We get a large order? We need to ramp up production of our … Continue reading

Posted in Editorial | Tagged | 3 Comments

SQL Server Licensing is Simple

Over the years I’ve had no shortage of licensing questions for SQL Server. At times it’s felt a little crazy. Look at the licensing guide. Choose EE or SE and the number of cores. Then check if you’re using VMs. … Continue reading

Posted in Editorial | Tagged | 3 Comments

Don’t Let Corner Cases Drive Your Design

If you graph computer/query cost against the size of data, you can get four quadrants: small data, small compute (most CRUD app queries) small data, big compute (complex BI queries for this quarter, most reporting) big data, small compute (logs, … Continue reading

Posted in Editorial | Tagged | Leave a comment