This month for T-SQL Tuesday we are asked to describe our “Why”. I have a couple of Whys not related to my day job, but we will start with my day job. Since I was six years old, I wanted to be a computer programmer because I thought video games
This month Rily Major (b | t) ask us to talk about how we are giving back to the community if we are or how we would if we aren’t, to lay out a plan. I’m already heavily involved in the community and haphazardly landed that way with no plan,
This T-SQL Tuesday is brought to us by Jens Vestergaard (b | t), and we are asked to share our favorite SQL Server tools. Hint Profiler will not be on the list. But where do you start there are so many tools out there. In alphabetical order here are my top
This month Aaron Bertrand (b | t) has given us a Dealer’s Choice on the T-SQL Tuesday topic. I’m of course going to take the chance to talk about something I’m passionate about. It’s not something people would consider fun but it’s what I enjoy spending my spare time on. Warning
This T-SQL Tuesday is brought to us by Arun Sirpal (b | t) and wants to write about a technical challenge we have conquered. Having been a DBA for 18 years now it’s hard to pick on a technical challenge but I will stick to the more recent challenge of
This month’s T-SQL Tuesday blog is brought to us by Malathi Mahadevan (b | t) and this month topic is about setting our learning goals for 2018. I have for the last 5 (except for last year) years set learning goals for the year after attending a session at PASS Summit in 2012
This month’s T-SQL Tuesday is brought to us by Kendra Little (blog | @Kendra_Little). Kendra asked to write about interviewing patterns and anti-patterns and to be careful to protect our past/current employers and candidates. I’m going to talk about things I should have done better for interview that are really technical things
At my first official DBA job, I was being trained the current DBA on deploying stored procedures. They had system where you received a ticket with the SQL file attached. You proceed to see if the procedure existed and if it did. You right click on it and look at
At a previous job I had several developers that had passwords for SQL authenticated accounts for systems that would give them more access than they needed when they had Windows accounts that would give them enough to troubleshoot issues. Our trick was to write a login trigger that would block
This month’s T-SQL Tuesday is brought to us by Jason Brimhall. We are writing about times someone took chances with the databases that the DBAs felt were not worth it. I am going to talk about taking chances with your backups, our #1 job as DBAs is to have backups.