This year I was privileged to attend Microsoft Ignite 2019. I am honored and humbled to have gone. No one here has done to any conferences in decades, so I...

Microsoft Access is the bane of our existence. We have hundreds of Access databases and apps in production today. Allowing for duplication, since its likely more than 1...

Microsoft Access is the bane of our existence. We have hundreds of Access databases and apps in production today. Allowing for duplication, since its likely more than 1 person uses...

What I was assigned to do, when I first started working at my current job, had absolutely nothing to do with the job description, the listing on the website, or...

• This reply was modified 6 years, 6 months ago by Rod at work.
• This reply was modified 6 years, 6 months ago by Rod at work.

I like your suggesting we experiment with the various tools, looking to see which will work for us in a given situation. I think there's a tendency to choose one...

My recommendation would be to try it out.  You are licensed for it; give it a shot.

Build up a proof of concept data migration and compare it to the...

Over the years as both a Database Developer and DBA, I've found SSIS to be a good tool.  As others have said, not necessarily the best tool, but it...

Security is important. I do what I can and know how to do, in order to improve security. But I'll admit that I'm no security expert. I've been fortunate enough...

I've gotten some great feedback here. Thank you, all who have responded. My conclusion is that even among DBAs, you're not all enamored with SSIS, for various reasons. Some do...

Good points here, Steve. Although I'm finding Stack Overflow (SO) to be less helpful. I've been on it for almost 10 years. The last 3 years I've been insulted and...

Using initials for column names and then having a document at your desk for reference - that is so retro '80s RPG/COBOL.

I too would recommend implementing the database using...

Eric, your comment made me realize I hadn't even thought of column naming conventions! WOW, how could I have forgotten that!! I'm fairly flexible, although I prefer to use Pascal...

I don't know what to think of this editorial. I do agree that reading others code can be taxing and hard to do. But heck, when I go back to...

Until I came to this job, all my other IT jobs were for small companies. Or at least small IT shops. So knowing where to find something was easy. In...

I completely agree with you 100%. I know that for my own part it's hard to receive criticism. And most of it is just me. Even when criticism is blameless,...