Archives: October 2015
Of all the posts I’ve written I think this one is my favorite, even though it’s not a technical post. So while I’m at Summit (I’m even presenting today!) I thought I would re-post it for your enjoyment.
The new IT manager (Lou) walks into the DBA manager’s office… Read more
I consider myself lucky. I fell into a job that I truly enjoy, something that I do for fun even when I don’t have to. A job, a technology and a community that I’m truly passionate about. Unfortunately maintaining that passion can be a bit difficult at times. And I’ll… Read more
I make a habit of using the latest version of SSMS even if I’m not working with the latest version of SQL Server. For example right now at home I’m using SSMS 2016 even though I frequently work with SQL Server 2014 or 2012. Well this can cause a bit… Read more
What do you do when you need to use a special character in a name? Well, I guess I should define what I mean by special first. Special characters are any non-alphanumeric character, so &#!~\/ etc, including spaces. It’s really pretty easy. Put s around the name. Now you can… Read more
If you’ve worked with SSMS for any length of time this will look awfully familiar:
This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server Audits. Fortunately this is one I have a bit of experience with. It’s one of my favorite new features if only because it’s so simple to… Read more
This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say you have a failed SQL Server job.
Here is our job that will fail:
Then we run it and it fails!
And when we click on the error… Read more
Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned along the way a bit later. But in the mean time I promised I would make the PowerPoint for my SQL Server Security Basics session available on my blog and… Read more