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…… Continue reading Back to Basics
Security Audit – Part 4
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…… Continue reading Security Audit – Part 4
And We’re Back!
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…… Continue reading And We’re Back!
SQLSoldier
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…… Continue reading SQLSoldier
Security Audit – Part 2
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:…… Continue reading Security Audit – Part 2
Security Audit
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,…… Continue reading Security Audit
Welcome Back (to me!)
I know it has been quite some time since I last posted, but, well, life happens. Sadly, there is only one of me, and so many things that are expected of me. Whether it be something at work, something personal, or a combination of both, it just had to be done by yours truly. But…… Continue reading Welcome Back (to me!)
PASS Summit 2017
For those of you that don’t know, PASS Summit 2017 is literally just around the corner and I just happen to be going! For those who have never been before, it’s possibly one of the greatest networking events for those of us into data imaginable! You can literally go into multiple presentations, where you will…… Continue reading PASS Summit 2017
Hello world!
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
Concatenation of Strings!
Now, I know for most of you, this seems like a rather simple idea. The definition of concatenation is, according to Dictionary.com is : verb (used with object) 1. to link together; unite in a series or chain. Simply put, you combine two or more strings together to form a new string. So, the first…… Continue reading Concatenation of Strings!