Click here to monitor SSC
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.

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, 687 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, 1,088 reads

Posted in SQL Barbarian on 19 September 2016

Remote Desktop Workflow Improvements

Remote server management is a fact of life for folks involved with sql server. Since we work so often with remote machines I looked into a few tools that provided a better workflow than the default Microsoft tools. This one came out as the winner by far.

A better remote…

Read more

0 comments, 148 reads

Posted in SQL Barbarian on 29 August 2016

SSMS - Connection Color with SQL Prompt & SSMSBoost

If you haven't explored the visual color coding of tabs based on pattern matches with SQL Prompt, I'd suggest you check this out.

Earlier iterations of Red Gate's SQL Prompt did not change tab color immediately when the connection was changed.

Red Gate's tab color could get out of sync… Read more

0 comments, 185 reads

Posted in SQL Barbarian on 23 August 2016

SQL 2016 - Brief Overview on some new features

SQL 2016 - New Functionality

These are notes taken from the Houston SQL Pass User group from July. This presentation was given by John Cook, (Data Platform Solution Architect Microsoft) who did a great job with limited time on providing some great details on the new functionality with SQL… Read more

0 comments, 475 reads

Posted in SQL Barbarian on 19 August 2016

Install ReadyRoll via Command Line

command line install options

ReadyRoll has some great features, including the ability to use without cost on a build server. If you want to ease setup on multiple build servers you could create a simple command line install step against the EXE.

future changes

ReadyRoll was recently acquired by Redgate,… Read more

0 comments, 718 reads

Posted in SQL Barbarian on 18 August 2016

Does sp_rename on a column preserve the ms_description?

Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the column_id isn't changing, the existing mapping of the description for the column is preserved.

I know it's probably pretty obvious, but I had someone ask me, so figured proving the… Read more

0 comments, 108 reads

Posted in SQL Barbarian on 15 August 2016

Regex With SQL Server - SQLSharp

In the context of my developer machine, I had log files I wanted to parse through. I setup a log library to output the results on a test server to a sql table instead of text files. However, this meant that my "log viewers" that handled regex parsing weren't in… Read more

0 comments, 1,751 reads

Posted in SQL Barbarian on 11 August 2016

Improvements with SSMS 2016

The staple of every SQL Server developer's world, SSMS has been impossible to usurp for the majority of us. However, it's also been behind the development cycle of visual studio, and didn't have continual updates. That changed recently, as I've previously posted on. SSMS (Sql Server Management Studio) now being… Read more

0 comments, 2,521 reads

Posted in SQL Barbarian on 11 July 2016

Glasswire: (Giveaway Included) Networking Monitoring even a caveman could use

Giveaway details at the bottom for those interested

Dealing with development & sql servers, I like to know what type of network traffic is happening on my machine. What is the overhead of monitoring on network bandwidth, what is communicating across servers or even externally?

What is phoning home?

You… Read more

0 comments, 230 reads

Posted in SQL Barbarian on 1 July 2016

SQL Compare 12: Initial Look

I know there have been a few other folks going into more detail on SQL Compare 12 (beta), but I thought I'd share just a few looks at the new design. Looks pretty slick, and I like where the design is going. Just a quick look, as I'm sure there… Read more

0 comments, 158 reads

Posted in SQL Barbarian on 25 June 2016

SSMS Tools Pack - A Handy Tool for generating CRUD

So I've had this tool around for a while, but never found much usage out of it to be honest. I didn't end up writing a review as I had other tools that did text replacements, and history/session saving. I've always considered this tools implementation of SQL History/Tabs saver the… Read more

0 comments, 256 reads

Posted in SQL Barbarian on 17 June 2016

OmniCompare: A free tool to compare SQL Instances

comparing instances

When working with a variety of instances, you can often deal with variances in configuration that might impact the performance. Without digging into each instance you wouldn't know immediately that this had happened. There are fantastic tools, like Brent Ozar's SP_Blitz, but this doesn't focus on every single… Read more

0 comments, 1,761 reads

Posted in SQL Barbarian on 14 June 2016

Continual Deployment of Visual Studio SqlProj

Unveil the inner workings of the esoteric build system...

As a data professional, I've never worked extensively with msbuild or other pipelines. I'd been mostly focused on just running schema comparisons and publishing. However, I've had the needed to try and deploy a database project from visual studio automatically, and… Read more

0 comments, 322 reads

Posted in SQL Barbarian on 16 May 2016

The Mysterious Black Box of R - For the SQL Server Guy

Took a class from Jamey Johnston @ SQLSaturday #516 in Houston. Lots of great information covered. Follow him for a much more detailed perspective on R. Jamey Johnston on Twitter @StatCowboy. Did a basic walkthrough of running an R query, and figured I'd share it as it had been a… Read more

0 comments, 2,351 reads

Posted in SQL Barbarian on 14 May 2016

Red Gate Dependency Tracker - Making Databases Into Moving Art

data structures are art

If anyone thinks that working with complex data structures is boring... I don't know what world they live in. The problem is often that sql tables and data structures are just script files and lists of tables in an object explorer.

However, once you crack open… Read more

0 comments, 211 reads

Posted in SQL Barbarian on 27 April 2016

Automating SSMS 2016 Updates & Install

Figured I'd share a way to automate the SSMS 2016 updates until it gets it's own fancy self updater. I love staying up to date, but with Power BI, SSMS, and others updating monthly or more and not having any automation for keeping up to date, this is something I… Read more

0 comments, 1,425 reads

Posted in SQL Barbarian on 19 April 2016

Cool Tools: Powershell ISE-Steroids

Disclaimer: I have been provided with a free license because I am reviewing. This doesn't impact my assessment of the tool. I have a passion for finding tools that help developers, and even more specifically SQL DBA/Developers improve their workflow and development. I don't recommend tools without actually using them… Read more

0 comments, 259 reads

Posted in SQL Barbarian on 14 April 2016

Failed to Initialize SQL Agent Log... not worthy

Moving system databases in SQL Server takes a bit of practice. I got that again, along with a dose of SQL humility (so tasty!), today after messing up some cleanup with sql agent server log files.

Failed to initialize SQL Agent log (reason: Access is denied).  

I was creating a… Read more

0 comments, 474 reads

Posted in SQL Barbarian on 1 April 2016

Failover all databases to other server

Quick snippet I threw together to help with failing over synchronized databases to the other server in bulk. No way I want to click that darn Fail-over button repeatedly. This scripts the statements to print (i commented out the exec portion) so that you can preview the results and run… Read more

0 comments, 214 reads

Posted in SQL Barbarian on 18 March 2016

Older posts