SQL Server Admininstrators – This One Is For You!
Our next SQL Server Expo is just around the corner – this is a free event and you need to get registered today. The expo is Friday Feb 26 starting at 9:00a Pacific. We’ll have three different sessions centered around great topics for administration with your SQL Servers. The presenters are bringing you great information and all straight to you and your computer. Check out the Expo site here and get registered today – we’ll see you there!
Building .NET Applications?
Building applications with the right tools can be a huge boon to the success of your application development work. This is where Telerik OpenAccess comes in. Telerik OpenAccess is an Enterprise-grade .Net ORM that does the data access plumbing in desktop and web applications. Supporting both forward (model-first) and reverse (schema-first) mapping, the tool offers transparent persistence for your DAL and business objects. OpenAccess ORM provides tight Visual Studio integration and allows you to seamlessly create database independent code. You can even get a free trial and see how it works in your own environment. Check it out here.
Have You Reviewed Your Audit Requirements?
We received a HIPPAA notice today from our health insurance broker. New regulations are on the very near horizon that dictate how they lock down information in their systems. They also have to have well-defined responses to a data breach – responses that indicate what information is available to those impacted by the breach. They also have to do the whole notification thing to their clients simply outlining the fact that they have these processes in place. Great fun.
It had me thinking about how these requirements impact our database systems and how we stay in the proverbial loop for requirements. I have talked with DBAs in the past that are pretty much innocent bystanders and simply have things edicted upon them (is that a phrase??) for what must be done to respond to compliance and audit situations.
I strongly suggest you get involved. Talk with those that are working through your best practices and compliance issues and make sure you’re in on the process that defines what you’ll be doing. Don’t be reactionary, instead be proactive and involved. By getting into the mix a bit more early-on, you won’t be able to change the requirement of course, but you may be able to change how things are implemented and that leads to how your systems are impacted. Help people understand native tools, what’s straightforward, what’s not, etc.
You can save yourself immense amounts of time in implementing the operations to address compliance. While you’re out there getting involved, look through both native SQL Server tools and third-party tools. Arm yourself with options and you’ll not be facing having to generate all new approaches – you’ll know what’s possible, you’ll know the first steps to making the build or buy decision, etc.
SSWUG.ORG Spring Virtual Conference…
…is just around the corner! We are super-focused on bringing you excellent sessions, outstanding speakers and an environment that focuses on you, the attendee. This virtual conference brings it all to you on your desktop, making it easy to learn while still covering your work schedule. Watch sessions as they air, or catch them on-demand (or both) – you can’t lose. Check out our sessions, then check out the speakers. Second to none and really solid information.
[Click Here to Register Today to Take Advantage of Early Bird Registration]
Featured Script
search syscomments for ‘word’ references in objects
A quick & ‘dirty’ way of searching through syscomments for a ‘word’, returning the name and type of objects where the word … (read more)