Another quick question; am I correct in believing that sys.server_principals and sys.server_role_members are system views that return data relevant to the server and not one of the databases? I'm wondering...

So, are you saying that whether I use SMO or not, eventually a SQL SELECT will be performed?\

I posted a similar question in the EF forums on the...

In the past I was able to attend several conferences, some of which involved a product launch. It was very exciting. During the presentations and testimonials from companies who had...

I work in State government, which in our state is traditionally waterfall in practice. I've brought up trying to do some DevOps but it has met with resistance. The single,...

I think I'm like you, Steve. I've use PoSH when I can, but am not an expert at it. Whenever I'm using SSMS or Visual Studio I depend a great...

I've seen 2 practices; using so called "magic numbers" or using nulls. When I first went to work at my previous job, I had very little experience with any SQL...

Man, Steve, you covered a lot with this article. I want to address just one thing you mentioned; that's getting people, especially users, to test changes. In my experience that...

This topic interests me a good deal, but sometimes I've no idea at all how it can be applied. At least to some software I'm working on. First example, I'm...