Tag Archives: security

It’s Almost Always the Humans

Posted on January 31, 2011 by way0utwest

Today we have an editorial reprinted from Sept 19, 2005 as Steve is on vacation. Zoom in |  Open in new window Most breaches of security, stolen data, etc. are almost always the result of some breakdown in the human factor … Continue reading →

Posted in Editorial | Tagged | Comments Off on It’s Almost Always the Humans

ETL Security Holes

Posted on January 17, 2011 by way0utwest

The addition of DTS to SQL Server meant that more and more of us could grab data from a variety of sources, easily, and move it to SQL Server systems. SSIS enhanced our capabilities and made it fairly simple for … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on ETL Security Holes

In Case of Breach

Posted on January 5, 2011 by way0utwest

What would you do if you received a phone call in the middle of the night saying that one of your databases had been hacked and data released? Do you know what to do as a first responder? There’s a … Continue reading →

Posted in Editorial | Tagged | Comments Off on In Case of Breach

Getting a Dedicated Admin Connection

Posted on December 28, 2010 by way0utwest

Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need to use a command line and SQLCMD. However while studying for the MCM, I learned that there’s an easy way. … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Getting a Dedicated Admin Connection