You can write DDL triggers to prevent connections with Excel and Access?! I didn't know that! Guess we're going to have to look into that.

Very relevant to me. I've been using Microsoft's HealthVault service for a few years now. I literally use it daily, to record my weight for that day. I like the...

For a year or so, I've decided to adopt Git for my personal VCS. I have to ride a train to work, because I live far from where I work....

As far as Integrated Authorization goes, how do you detect that? How can do determine that a user is trying to access tables within a SQL Server database using Microsoft...

And thank you for the mention of Sonarqube. I've never heard of it, but looking at it a little bit, it looks like it would be useful.

Good article, Steve. I've got a few comments about it. First, I completely agree that having more secure code, to begin with, will help prevent problems down the road. However,...

My first, real programming job was in the private sector; manufacturing. This was before the company adopted a SQL-based RDBMS. We worked on VAXes, where the OS was VMS (if...

• This reply was modified 7 years, 2 months ago by Rod at work. Reason: corrected misspelling

We're doing it piecemeal. Right now it's being investigated by IT, in small ways. Some databases are there; some networking and dabbling with Azure AD. I tried, unsuccessfully, to get...

Notebooks is a fascinating idea, Steve! I've never heard of them before. It kinda reminds me of GitHub's gists, but different. Thank you for sharing this!

This editorial is very apropos for me. I'm involved in a new project to take an old, legacy application written years ago as a Microsoft Access app, into modern technology....

For the most part, I like to new website. Of course, not everything. But I don't perfectly like everything I write, either. I'm curious to know what requirements...

For the most part, I like to new website. Of course, not everything. But I don't perfectly like everything I write, either.

I'm curious to know what requirements Google and other...

I've not been fortunate enough to be in the situation you've described, Andy. I'll follow this thread with interest.

I'd...

Igor, I'm not following you when you talk about a "System DBA" rather than a generalist/application DBA. Sorry for being so dense, but could you please that more, please?