So, in our last post – Back to Basics – we went over what a stored procedure was and what goes into it. Now, let’s show you a simple stored procedure. CREATE PROCEDURE StoredProcedureTest AS SELECT 1/1 GO I know. I know. You thought we were going to begin by building skyscrapers, instead, we’re trying to find cinder … More Stored Procedures
Welcome to the New Year everyone! After debating with myself and talking to a few colleagues/peers over the last few weeks, I’ve decided that I have gotten away from my original sense of purpose for this blog. It’s time to fix that! My original idea was to have this blog be a place where people … More Back to Basics
So, since it has been some time since we looked at our Security Audit, let’s review what we’ve gone over so far: And We’re Back! Security Audit – Part 2 Security Audit On our next look at the Security Audit, let’s look at the server itself – SELECT COUNT(*) FROM sys.servers WHERE is_linked =’1′ This … More Security Audit – Part 4
So, as you can tell from the lack of posts over the past few months, I have been more than just busy. Between moving into a new house, moving my son into a college dorm, several SQL Saturdays, and just general work items, it has been extremely hectic. But, I am back now, and my … More And We’re Back!