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 ,

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 , ,

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 ,