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

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, 296 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, 333 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, 248 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, 3,464 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, 282 reads

Posted in SQL Barbarian on 18 March 2016