sp_configure

Check Your SQL Server Configuration

I blog a lot about best practices, defaults and paying attention to your installations. It’s a huge pet-peeve of mine to see improperly configured instances. One of the things I always do when doing a health check is review an instances configuration options. On quite a few client environments, just a couple quick knob turns … Read more

How to use sp_configure in SQL Server

sp_configure is the "type set" of SQL Server

[et_pb_section bb_built=”1″ 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” custom_padding_tablet=”50px|0|50px|0″ custom_padding_last_edited=”on|desktop” 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=”off” 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” parallax=”on” background_color=”#152f3e” /][/et_pb_section][et_pb_section bb_built=”1″ 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 … Read more