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

Exploring SQL Server With Powershell And SMO Basics

SqlServer Powershell Cmdlets 2017 - Initialize Look

Diving into the Sql Server Management Objects library can be a pretty interesting process. You get to work with database objects as in a new way, and begin manipulating and execute code in a much different approach than purely using T-SQL. Powershell offers… Read more

0 comments, 758 reads

Posted in SQL Barbarian on 9 August 2017

Capturing Perfmon Counters With Telegraf

InfluxDb & Grafana Series


I had a lot of issues with getting the GO enviroment setup in windows, this time and previous times. For using… Read more

0 comments, 198 reads

Posted in SQL Barbarian on 8 August 2017

Dataedo - First Look

Diagraming and Documentation

Previously, I've written up on database diagramming for visualization of database structures. Check that out for more detailed review on what I've used.

I've recently taken a swing at this newer tool and found it very promising as a database documentation tool that bridged the gap of… Read more

0 comments, 144 reads

Posted in SQL Barbarian on 7 August 2017

ANTS Performance Profiler for the SQL Server Dev

There are a few .NET tools that until recently I haven't had the chance to work with as much, specifically ANTS Memory Profiler and ANTS Performance Profiler. The memory profiler is more useful for someone focused on memory leaks which a SQL Dev isn't as focused on for performance tuning.… Read more

0 comments, 450 reads

Posted in SQL Barbarian on 21 July 2017

Update SSMS With PS1

With how many updates are coming out I threw together a script to parse the latest version from the webpage, and then provide a silent update and install if the installed version is out of date with the available version. To adapt for future changes, the script is easy to… Read more

0 comments, 1,417 reads

Posted in SQL Barbarian on 3 July 2017

External Tool VSCODE called from SQL Management Studio

Previous Related Post: Split personality text editing in SSMS with Sublime Text 3

In this prior post I wrote about how to call Sublime Text 3 from SSMS to allow improved text manipulation to be quickly called from an active query window in SQL Management Studio. Vscode is a newer… Read more

0 comments, 233 reads

Posted in SQL Barbarian on 26 June 2017

Best Practices: Defining Explicit Length for Varchar/Nvarchar

SA0080 : Do not use VARCHAR or NVARCHAR data types without specifying length. Level: Warning

When using varchar/nvarchar it should be explicitly defined. This can be a very nasty bug to track down as often nothing will be thrown if not checked in an application. Instead, ensure your script explicitly… Read more

0 comments, 262 reads

Posted in SQL Barbarian on 7 June 2017

Powershell Module Improvements for SQL Server in 2017

simple setup

A major improvement that seems to have quietly slipped into the sql developers world is an improved SQLServer powershell module. The improved module is finally available in the powershell gallery, allowing a super quick setup on a server. No more installing SSMS to get them!

This is very… Read more

0 comments, 1,633 reads

Posted in SQL Barbarian on 31 May 2017

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

InfluxDb & Grafana Series


There are some beautiful ways to visualize time series data with the tools I'm going to go over. This post is… Read more

0 comments, 2,093 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, 345 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, 92 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, 252 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, 138 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, 129 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, 102 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, 606 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, 191 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, 451 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, 223 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,763 reads

Posted in SQL Barbarian on 28 October 2016

Older posts