I recently had the pleasure of being a guest on a Podcast episode with the SQL Data Partners Carlos Chacon (B|T) and Steve Stedman (B|T). If you haven’t had a chance to attend one of my sessions on Survival Tips for the Lone DBA, this is great insight into it. I share via questions and answers how it is to be a Lone DBA. http://sqldatapartners.com/2017/03/28/episode-89-lone-dba/
-
-
I didn’t know about this little gem, so I shared it with my team and they didn’t know about it either. Then I tweeted about it and found others who didn’t know about it, so I decided I should write a short little blog. Denny Cherry (B|T) posted a blog on twitter telling everyone to blog as much as possible no matter how small the topic, so I figured why not do this one. So What Is It? Windows PSR “Problem Steps Recorder”. It’s a nifty tool that helps you trouble shoot a computer problem by recording step by step what the user is doing. How to: Go to Start…
-
We have all made mistakes in our careers, I thought I’d share one of mine as a quick tip to others so that you don’t make the same one. Everyone has their SQL Alerts setup right? If not, I have included the script below and here is the MSDN link to find out more (https://msdn.microsoft.com/en-us/library/ms180982.aspx). For those who have setup their alerts, how many of you have remembered to set the DELAY BETWEEN RESPONSES setting? When I worked at the Port of Virginia, I was a little less experienced in SQL and didn’t notice this lovely little option. I of course failed to set it. Can anyone guess what happened?…
-
How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains how to execute all your jobs and SSIS packages. In addition, I preference mine with all key elements someone might need, like where passwords are stored, architectures, backup times, where are backups stored, etc… then dig into the job steps. The purpose of this document is so that someone with some SQL skills could step in if needed. You never know when you will be hit by a bus or win the lottery and someone has to take over for you. Important things to note: Step by Step with Pictures…
-
Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like have multiple versions of the same report out there. So, I got a little fancy with the current version of the report and added a parameter then used expressions to group the data differently and hide columns. For those new to SSRS I’ve embedded some links to MSDN to help you along the way. Current Report The report gives summarized counts by invoice date. It currently has a ROW group using date_invoiced and the detail row is…
-
Ok everyone; here goes my first crack at replying to a T-SQL Tuesday. For those that don’t know what it is, it’s a Monthly blog topic hosted by a member of the SQL Community. It was started originally by Adam Machanic (t | b) This month’s topic hosted by Andy Yun (t | b) is on Growing New Speakers, which I find to be a perfect topic for me to leap off from, since this was my first year speaking and blogging. How did I get started? I 100% blame Derik Hammer (t | b) whom at the time was running my local user group. After attending just one meeting I was “volun-told” I would be presenting…
-
My life for the last 2 years has been a constant battle of putting out fires with system performance; finally user complaints have moved getting this resolved as my top priority. Let’s see how I tackled the problem… Symptoms: Very High Disk Latency as high as 300,000 milliseconds (ms) is not unusual Average: 900 – 15,000ms Memory Pressure Slow User Experience Problem: Bad hardware Over-provisioned VM Hosts (what happens on one VM effects the other) Old NetApp SAN No infrastructure budget for new hardware Challenge: Make the system viable with no hardware changes or tweaks Step 1: Brain Storming (in no particular order) Reduce I/O I can probably tune a ton…
-
This year has been a whirlwind so far, thanks to the Idera ACE program. For those that don’t know what that is … What is an Idera ACE? (According to Idera) “ACEs (Advisors & Community Educators) are active community members who have shown a passion for helping the community and sharing their knowledge. We help the ACEs pursue that passion by sponsoring travel to select events and offering guidance for soft skill training.” Requirements to become an Idera ACE: Enthusiastic members & leaders of the SQL community Accomplished contributors to the SQL community Good speaker, writer and presenter Demonstrated a passion for educating fellow community members Being an ACE has been…
-
I’m It Survival Tips for the Lone DBA – Level 100 (Not Accepted: Higher rated session selected) Track: Professional Development As others have done I also will share my feedback from my submission to speak at PASS Summit in hopes it will lend some more insight into the process. Abstract: Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll…
-
I love getting get a laptop, but getting all the software reinstalled and making sure everything works can be trying. Last week, I was lucky enough to get a new one and spent two days getting it setup just right. At least so I thought…. once I started working on it of course, BAM I hit my first road block. Visual Studio using SQL Server Data Tool will not render any reports in the Preview tab. Let the trouble shooting commence! Error Message? No help… gives me nothing useful Can I deploy report to SharePoint and View? (We use SSRS Integrated Mode)- Success!! This leads me to believe the issue probably lies…
