There are still a lot of tools out there that demand SA login. Some even have checks to make sure they have such elevated privilege. Bowen if you run...

We did a test run of AG in our DEV environment. Getting 1.5+ TB of databases synced took a bit but it worked and using our cname for the DEV...

A boss I had was famous for walking through the area and if he saw an unlocked machine, he'd hit <ctrl><alt>arrow to rotate the developers screen and then lock it....

SQL Server 2012 Express Edition only uses up to 1GB of memory. So if you need more than that to perform your work, you'll either need to see if you...

Before the pandemic, I was working from home 3 days a week. My commute is a 90 mile round trip nightmare (Boston traffic is a thing of legend). I'll stick...

I'm with you Steve. Like you, I usually lie about my birthday and make up random answers to security questions and store them in my password vault. Each site gets...

I worked for a company in the late 70’s that was running on DEC VAX 11/780 systems. One day you could hear everyone saying, “Hey! Where did my files go?”...

I think the default should be that you're automatically "opted out" unless you decide to "opt in".  Of course, that won't be profitable for these vendors and so that...

This year was my first PASS Summit. I've wanted to go for quite a while but there was no way my employer would spend the money needed to attend the...

We have Redgate SQL Monitor looking after 10 servers at work. It's been very helpful in tracking down issues. The main dashboard gives me a quick look at what is...

I live in Salem, MA, a.k.a. The Witch City. We're Halloween central here. I thought this year we'd see almost no one come around in September and October. I mean...

Maybe the SQL Agent account cannot access the CSV file. If it's coming from a network location I believe you will need an AD account for SQL Agent. Something to...

Things are certainly different now then when I had my ticket back in high school.

My scary leap right now is setting up AOAG. Although most of the walk throughs are...

I was already working from home 3 days a week so I was pretty well setup when they told us to work from home full time. My commute was 45...

I started with Visual Source Safe (a long, long time ago), then TFS and we've moved to Git about 2 years ago. It's taken me a while to wrap my...