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

Sheldon Hull

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.

Ultrawide Monitor - Samsung CF971 - First impressions

As a developer, I’ve been a big fan of multiple monitors for a long time. I moved to a triple screen setup years ago, and up until recently, had no desire to try anything different.

Well… I’ve finally found the replacement. The holy grail of productivity, immersion, as well as… Read more

0 comments, 52 reads

Posted in Sheldon Hull on 15 August 2017

Fixing VirtualBox Only Showing 32bit Windows OS Options

Original help was identified from this article Why is VirtualBox only showing 32 bit guest versions on my 64 bit host OS?

In browsing through the comments, I saw mention that the root issue is that Hypervisor running interferes with Virtualboxes virtual management, so I disabled Hypervisor service, repaired the… Read more

0 comments, 41 reads

Posted in Sheldon Hull on 10 August 2017

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, 932 reads

Posted in Sheldon Hull on 9 August 2017

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, 61 reads

Posted in Sheldon Hull on 8 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, 358 reads

Posted in Sheldon Hull 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, 296 reads

Posted in Sheldon Hull 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, 583 reads

Posted in Sheldon Hull 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,536 reads

Posted in Sheldon Hull 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, 328 reads

Posted in Sheldon Hull 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, 409 reads

Posted in Sheldon Hull 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,923 reads

Posted in Sheldon Hull 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, 3,083 reads

Posted in Sheldon Hull 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, 519 reads

Posted in Sheldon Hull 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, 158 reads

Posted in Sheldon Hull 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, 327 reads

Posted in Sheldon Hull 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, 208 reads

Posted in Sheldon Hull 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, 319 reads

Posted in Sheldon Hull 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, 155 reads

Posted in Sheldon Hull 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, 1,033 reads

Posted in Sheldon Hull 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, 322 reads

Posted in Sheldon Hull on 31 October 2016

Older posts