-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Barbarian

After working in the mortgage industry for 7 years, I transitioned into Business Intelligence and began learning SQL and .NET. My goal is to integrate my business knowledge into my development to intelligently analyze and find solutions to problems. Blogging offers me an option to share what I've learned as well as receive feedback on better practices and solutions.

Archives: September 2016

SQL 2016 - Configuration Manager Not Showing in Start Menu

Didn't see SQL 2016 Configuration manager in the start menu. Ran a quick search to see if this was a common issue and found an article: Quick Trick Where is SQL Server for SQL 2012I looked and found the SQL Configuration Manager for 2016 in the same location: C:\Windows\System32\SQLServerManager13.msc

As… Read more

0 comments, 14 reads

Posted in SQL Barbarian on 21 September 2016

SQL 2016 - Configuration Manager Not Showing in Start Menu

Didn't see SQL 2016 Configuration manager in the start menu. Ran a quick search to see if this was a common issue and found an article: Quick Trick Where is SQL Server for SQL 2012

I looked and found the SQL Configuration Manager for 2016 in the same location: C:\Windows\System32\SQLServerManager13.msc Read more

0 comments, 1,255 reads

Posted in SQL Barbarian on 21 September 2016

Setting DBCC 1222 on startup

The following command is run to gain details on deadlocks.

DBCC TRACEON (1222,-1)

However, once the SQL instance is restarted this flag is set back to disabled.

To enable it on the instance upon startup:

  1. Open SQL Configuration Manager
  2. Services > Sql Service Instance > Properties > Startup Parameters
  3. Add…

Read more

0 comments, 36 reads

Posted in SQL Barbarian on 19 September 2016

Setting DBCC 1222 on startup

The following command is run to gain details on deadlocks.

 DBCC TRACEON (1222,-1)

However, once the SQL instance is restarted this flag is set back to disabled.

To enable it on the instance upon startup:

  1. Open SQL Configuration Manager
  2. Services > Sql Service Instance > Properties > Startup Parameters
  3. Add…

Read more

0 comments, 1,348 reads

Posted in SQL Barbarian on 19 September 2016