Sherpa of Data

Author: Kevin

  • More ways to stop errors

    —

    by

    Kevin
    in

    Errors can be the bane of a developer’s existence. They can stop even the best developer’s work. A process that takes several hours can be stopped dead in it’s tracks in the last hour because of a horrible error. Thankfully, last time, we discussed one way to make a stored procedure more aware of errors…

  • Making Stored Procedures Bulletproof

    —

    by

    Kevin
    in

    So last time in Stored Procedures – Why we talked briefly about ways of making stored procedures more bulletproof. First off, you have to ask yourself, should we? I mean, the data we work with is a known thing every time, right? Can people just blindly enter data in? Haven’t our apps been built to…

  • Stored Procedures – Why

    —

    by

    Kevin
    in

    So, last time we discussed why do we really want to use a stored procedure. One of the big things I said was, “so that my blocks of code can be re-used several times now and in the future. “ This statement, at least to me, forms the building block for stored procedures. They allow…

  • Stored Procedures

    —

    by

    Kevin
    in

    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…

  • Back to Basics

    —

    by

    Kevin
    in ,

    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…

  • Security Audit – Part 4

    —

    by

    Kevin
    in ,

    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…

  • And We’re Back!

    —

    by

    Kevin
    in ,

    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…

  • SQLSoldier

    SQLSoldier

    —

    by

    Kevin
    in

    I know most of you turned in today for the next post in my series on Security Audits. Well, I felt that I had to talk about something much more important. A friend of mine died on Monday (April 2nd, 2018). Not just any friend though. This was Robert Davis, also known as SQLSoldier on…

  • Security Audit – Part 2

    —

    by

    Kevin
    in

    Once again, we delve deep into what is part of a security audit and why each part is important. One part that I like to look at is the default directories where certain types of files are kept. To do this – on SQL Server 2012 and above – we simply run the following commands:…

  • Security Audit

    Security Audit

    —

    by

    Kevin
    in

    The words that many a person dreads hearing – Security Audit. Whether you’re the one having to perform the audit or just having to deal with the aftermath of one, it is never fun. Over the next few blog posts, we’re going to look at a few common points that are included in security audits,…