-->
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.

Setting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev

There are some beautiful ways to visualize time series data with the tools I'm going to go over. This post is purely focused on the initial setup and saving you some time there. In a future post, I'll show how some of these tools can help you visualize your server… Read more

0 comments, 205 reads

Posted in SQL Barbarian on 17 May 2017

Red Gate SQL Clone (#1) - Initial Setup

Note this was during earlier beta usage, so some of the UI and other features will have been updated more. I plan on writing more on this promising tool as I get a chance to dive into it more, especially the powershell cmdlets for database cloning automation. In the meantime,… Read more

0 comments, 142 reads

Posted in SQL Barbarian on 27 February 2017

Bad Idea Jeans: Query Optimization Through Minification

SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select customer from dbo.customers where id = 2 instead of a much simpler syntax like dbo.Customers | Customer like Powershell might offer. As I considered the disappointing verbosity of sql server,… Read more

0 comments, 32 reads

Posted in SQL Barbarian on 23 January 2017

Bad Idea Jeans: Query Optimization Through Minification

SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select customer from dbo.customers where id = 2 instead of a much simpler syntax like dbo.Customers | Customer like Powershell might offer. As I considered the disappointing verbosity of sql server,… Read more

0 comments, 147 reads

Posted in SQL Barbarian on 23 January 2017

Dynamically Set Powershell Variables from json

I created this small snippet to allow a list of values from a json file be turned into variables to work with. For working with a fixed list of configuration values, this might be helpful to reduce some coding effort. Read more

0 comments, 47 reads

Posted in SQL Barbarian on 5 December 2016

Attaching Database Using SMO & Powershell

Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw together a completed script and modified it for my functionality here. MSDN documentation on the functionality is located here Server.AttachDatabase Method (String, StringCollection, String, AttachOptions)I see some definitive… Read more

0 comments, 39 reads

Posted in SQL Barbarian on 18 November 2016

Parallel Powershell for Running SQL

This is just a quick look. I plan on diving into this in the future more, as I'm still working through some of the changes being made in the main parallel modules I utilize for SQL server. In the meantime, if you are looking for a quick way to leverage… Read more

0 comments, 37 reads

Posted in SQL Barbarian on 16 November 2016

Parallel Powershell for Running SQL

This is just a quick look. I plan on diving into this in the future more, as I'm still working through some of the changes being made in the main parallel modules I utilize for SQL server. In the meantime, if you are looking for a quick way to leverage… Read more

0 comments, 204 reads

Posted in SQL Barbarian on 16 November 2016

Get Backup History for All Databases in Server

Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions provided a single backup listing, but not the brief summary of the last backup details I was looking for. Read more

0 comments, 58 reads

Posted in SQL Barbarian on 31 October 2016

Get Backup History for All Databases in Server

Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions provided a single backup listing, but not the brief summary of the last backup details I was looking for.

Read more

0 comments, 240 reads

Posted in SQL Barbarian on 31 October 2016

Data Compare on Temporal Tables

I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went through the exercise to compare current to historical to see how Red Gate & Devart handled this. I'm a part of the Friends of Red Gate program, so love checking… Read more

0 comments, 59 reads

Posted in SQL Barbarian on 28 October 2016

Data Compare on Temporal Tables

I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went through the exercise to compare current to historical to see how Red Gate & Devart handled this. I'm a part of the Friends of Red Gate program, so love checking… Read more

0 comments, 1,422 reads

Posted in SQL Barbarian on 28 October 2016

Fixing Untrusted Foreign Key or Check Constraint

Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax.If you are deploying data through several tables, you might want to disable foreign keys on those tables during the deployment to ensure that all the required relationships have a chance… Read more

0 comments, 35 reads

Posted in SQL Barbarian on 22 October 2016

Fixing Untrusted Foreign Key or Check Constraint

Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax.

If you are deploying data through several tables, you might want to disable foreign keys on those tables during the deployment to ensure that all the required relationships have a… Read more

0 comments, 211 reads

Posted in SQL Barbarian on 22 October 2016

Easy SQL Maintenance with Minionware

Here's my personal tweaked settings for deploying Minionware's fantastic Reindex & Backup jobs. In the development environment, I wanted to have some scheduled jobs running to provide a safety net, as well ensure updated statistics, but there were a few default settings I wanted to adjust. In particular, I tweaked… Read more

0 comments, 38 reads

Posted in SQL Barbarian on 18 October 2016

Easy SQL Maintenance with Minionware

Here's my personal tweaked settings for deploying Minionware's fantastic Reindex & Backup jobs. In the development environment, I wanted to have some scheduled jobs running to provide a safety net, as well ensure updated statistics, but there were a few default settings I wanted to adjust. In particular, I tweaked… Read more

0 comments, 305 reads

Posted in SQL Barbarian on 18 October 2016

Cannot Generate SSPI Context

Troubleshooting

I ran into an error: The target principal name is incorrect. Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)

I evaluated the sql server configuration manager protocols for sql server and saw that named pipes was disabled. I tried ensuring that this wasn't causing the issue, but enabling… Read more

0 comments, 88 reads

Posted in SQL Barbarian on 17 October 2016

Centralized Management Server 101

Registered Servers

I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. :-) This is definitely not the intended usage. As I've explored the benefits of using this a little more, I put a few notes together to help share the concepts I came across.… Read more

0 comments, 54 reads

Posted in SQL Barbarian on 16 October 2016

Centralized Management Server 101

Registered Servers

I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. :-) This is definitely not the intended usage. As I've explored the benefits of using this a little more, I put a few notes together to help share the concepts I came across.… Read more

0 comments, 1,690 reads

Posted in SQL Barbarian on 16 October 2016

Diff All Files - Reviewing Changesets Quickly

If you need to do code comparison on a lot of files in Visual Studio, I ran across an extension Diff All Files that is really helpful for merging down the individual file changes into more consumable format.

Diff all files

In the changeset view you can select diff all… Read more

0 comments, 36 reads

Posted in SQL Barbarian on 12 October 2016

Older posts