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.

Archives: March 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, 417 reads

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

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

Posted in Sheldon Hull 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'  


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

0 comments, 6,153 reads

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

Posted in Sheldon Hull on 18 March 2016