Monthly Archives: January 2018

Surround Code with Comments in SQL Prompt

I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool.  SQL Prompt will be yours as well if you give it … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Lowering the Noise

Over my career, I’ve had the chance to work in a variety of environments of all sizes. I’ve managed systems that powered all sorts of applications, with a variety of requirements. In many cases, I’ve had certain databases that needed … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Managing SQL Prompt Code Analysis Rules

I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool.  SQL Prompt will be yours as well if you give it … Continue reading

Posted in Blog | Tagged , , | Leave a comment

No Default CONTEXT_INFO()

I was doing a little testing of Row-Level Security (RLS) for the stairway, and one of the ways that some people implement RLS is with CONTEXT_INFO(). I haven’t every really used CONTEXT_INFO in production, though it’s been around for some … Continue reading

Posted in Blog | Tagged , | Leave a comment

IoT Increases Efficiency

There is no shortage of articles about problems with IoT, especially with consumer based IoT products. In fact, many of the ideas and sales are gimmicky with dubious value for me, but I know what some people get excited that … Continue reading

Posted in Editorial | Tagged | Leave a comment

Better Security with dbatools

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Are You Always Up?

I’ve had the opportunity to work for and with quite a few companies in my career. In some sense working as a database developer or database administratrator is very similar at many places. The “job’s the job,” as I’ve said … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Advent of Code 2017 Day 5–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is day 5 of the Advent of Code 2017. If you want to read about the puzzles, start … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Are You Patched?

It’s been a few weeks since the Spectre/Meltdown bugs were announced for most CPUs. Microsoft has been working hard to build patches, and they’ve provided fixes for Windows and SQL Server. Other manufacturers have released fixes for other platforms, though … Continue reading

Posted in Editorial | Tagged , | 1 Comment

tSQLt tests for Day 5 Advent of Code 2017

This is day 5 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1. As I worked through the puzzles, I decided that I should be testing using their test sets and … Continue reading

Posted in Blog | Tagged , , , | Leave a comment