DBA

Documentation

Documentation (…Or how I learned to stop procrastinating and love tolerate a chore necessary task) Do you document? Do you document well? As I told Paul Randal (twitter, blog) today on twitter, this blog post was inspired by an observation in the shower and a recent question by Brent Ozar (twitter, blog). You didn’t need … Read more

Where do I start?!?!

As a SQL Server DBA, where do I start? So you are a new DBA. Maybe you are someplace that hasn’t had a DBA, maybe you are someplace that didn’t have a great DBA. Requests are piling up, your head is spinning with the instances you are discovering and people are getting excited that there … Read more

What SQL instances are installed on my network?

Find All SQL Server Instances On Your Network! It’s been awhile since a tool has given me that giddy, starstruck feeling but it’s happened this week… If you ever struggle with instance discovery and management, I hope you get excited and try this tool out as well. Bear with me as I walk through it. … Read more

Do you focus too much on your backups???

Have you lost your mind?! What could I possibly mean by that title? I’m a DBA… One of the basic tenets of a DBA is “backup, backup, backup”, right? Well sort of… Far too often I hear people asking questions like “will this setup allow our backups to be fast?”, “how is your backup process … Read more

Don’t Touch that Shrink Database Button In SQL Server!

[et_pb_section bb_built=”1″ admin_label=”Section” fullwidth=”on” specialty=”off” transparent_background=”off” background_color=”#ffffff” allow_player_pause=”off” inner_shadow=”off” parallax=”off” parallax_method=”off” padding_mobile=”off” make_fullwidth=”off” use_custom_width=”off” width_unit=”on” make_equal=”off” use_custom_gutter=”off” global_module=”2469″][et_pb_fullwidth_post_title admin_label=”Post Title” global_parent=”2469″ title=”on” meta=”on” author=”on” date=”on” categories=”on” comments=”on” featured_image=”off” featured_placement=”below” parallax_effect=”on” parallax_method=”on” text_orientation=”left” text_color=”dark” text_background=”off” text_bg_color=”rgba(255,255,255,0.9)” module_bg_color=”#152f3e” use_border_color=”off” border_color=”#ffffff” border_style=”solid” title_font=”|on|||” title_text_color=”#ffffff” meta_text_color=”#eeeeee” /][/et_pb_section][et_pb_section bb_built=”1″ admin_label=”Section” fullwidth=”off” specialty=”on”][et_pb_column type=”2_3″ specialty_columns=”2″][et_pb_row_inner admin_label=”Row”][et_pb_column_inner type=”4_4″ saved_specialty_column_type=”2_3″][et_pb_image admin_label=”Featured Image (700×394)” … Read more