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.

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, 154 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, 1,919 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, 124 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,082 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, 147 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, 155 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, 163 reads

Posted in SQL Barbarian on 18 March 2016

Previewing the new SSRS 2016 portal

Ran into an issue with the “Preview New Reporting Portal” link on a fresh install of 2016 giving me a not found error.

Changing the virtual directory in the Report URL tab for SSRS configuration fixed this invalid link. In my case, I changed /Report to /Reporting.

Thanks to Adam… Read more

0 comments, 178 reads

Posted in SQL Barbarian on 18 March 2016

Calculating Some Max Mirror Stats

This turned out to be quite a challenge. I couldn’t find anything that made this very clean and straight forward to calculate, and in my case I was trying to gauge how many mirroring databases I could run on a server.

In my scenario, I wasn’t running Expensive Edition (@BrentO… Read more

0 comments, 148 reads

Posted in SQL Barbarian on 18 March 2016

SQL 2012 SP3 and entity framework conflict

the problem

An issue with SQL Server 2012 SP3 was identified that impacted EF4/5 due to additional datatypes in the dll.

System.EntryPointNotFoundException: Unable to find an entry point named 'SetClrFeatureSwitchMap' in DLL 'SqlServerSpatial110.dll'  

diagnosing

To easily identify the available dll versions of sql server, I ran a quick adhoc bat… Read more

0 comments, 445 reads

Posted in SQL Barbarian on 18 March 2016

TFS Work-Item Fancy Filtering

If you want to create a TFS query that would identify work items that have changed, but were not changed by the person working it, there is a nifty way to do this.

The filtering field can be set to <> another field that is available, but the syntax/setup in… Read more

0 comments, 142 reads

Posted in SQL Barbarian on 18 March 2016

Should I use option(recompile)?

Should I use option(recompile)?

This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of the content located in the fantastic learning resource provided by Brent Ozar Unlimited. Most of the core material based on a training class entitled: Table Variables, Temp Tables,… Read more

0 comments, 263 reads

Posted in SQL Barbarian on 2 February 2016

Should I use option(recompile)?

This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of the content located in the fantastic learning resource provided by Brent Ozar Unlimited. Most of the core material based on a training class entitled: Table Variables, Temp Tables, and OPTION RECOMPILE Credit… Read more

0 comments, 37 reads

Posted in SQL Barbarian on 2 February 2016

Easy way to test log shipping or availability groups setup

Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention after all the training on log shipping and availability groups that you can use a lab environment from TechNet to actually get going on familiarizing yourself with the technology more. Read more

2 comments, 220 reads

Posted in SQL Barbarian on 29 January 2016

Easy way to test log shipping or availability groups setup

Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention after all the training on log shipping and availability groups that you can use a lab environment from TechNet to actually get going on familiarizing yourself with the technology more. Read more

0 comments, 44 reads

Posted in SQL Barbarian on 29 January 2016

Transaction Logging & Recovery (part 3)

Transaction Logging & Recovery (part 3)

… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server: Logging, Recovery, and the Transaction Log. Please consider supporting his excellent material by using Pluralsight and subscribing to his blog. He’s contributed a vast amount… Read more

0 comments, 454 reads

Posted in SQL Barbarian on 20 January 2016

Transaction Logging & Recovery (part 3)

… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server: Logging, Recovery, and the Transaction Log. Please consider supporting his excellent material by using Pluralsight and subscribing to his blog. He’s contributed a vast amount to the SQL server community through… Read more

0 comments, 39 reads

Posted in SQL Barbarian on 20 January 2016

Verifying Instant File Initialization

Verifying Instant File Initialization

Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization was enabled, but found out that running the xp_cmd to execute ‘whoami /priv’ could be inaccurate when I’m not running it from the account that has the privileges. This… Read more

0 comments, 59 reads

Posted in SQL Barbarian on 13 January 2016

Verifying Instant File Initialization

Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization was enabled, but found out that running the xp_cmd to execute ‘whoami /priv’ could be inaccurate when I’m not running it from the account that has the privileges. This means that if my… Read more

0 comments, 60 reads

Posted in SQL Barbarian on 13 January 2016

Transaction Logging & Recovery (part 2)

Transaction Logging & Recovery (part 2)

… Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server: Logging, Recovery, and the Transaction Log. Please consider supporting his excellent material by using Pluralsight and subscribing to his blog. He’s contributed a vast amount to… Read more

0 comments, 93 reads

Posted in SQL Barbarian on 8 January 2016

Older posts