↓
 
Sql2Go Consulting

Sql2Go Consulting

MS SQL Server Database Development, Tuning, & Admin — ASP.Net Core 5 Development with DevExtreme

  • Home
  • Sql2Go
    • Services
    • Proximity Database
    • Reference Links
      • T-SQL Tuning
        • Indexing
        • Partitioning
      • T-SQL Coding
        • Indexing
      • SSDT
      • SSRS
      • SSIS
      • Azure
      • Development
      • Maintenance
        • Indexing
      • Architecture
      • .Net Framework/ASP.Net
      • Source Control
      • SQL XML
      • Geospatial
  • Contact Megan
  • About
    • Privacy Policy
Home→Published 2017 → February Log in

Monthly Archives: February 2017

STRING_SPLIT and SSDT do not mix

Sql2Go Consulting Posted on February 24, 2017 by meganApril 11, 2017

Update (3/28/17): As a simple workaround, I added a string split UDF that does the same thing (only much more slowly). If I need to compile the DB project, I replace the intrinsic function with the UDF in the two places it is called. Otherwise I switch back to the intrinsic. It’s annoying, but what else is a person to do? (I noticed this comment on Connect: “Some fixes have been added to SSDT regarding STRING_SPLIT. If you continue to experience the issue, please try out the next SSDT release.” I will indeed check it out.) [The fix is supposed to be in a “preview” release, which I have not installed. I will test it when the production release comes out.]

I happened to use the new (SQL Server 2016) STRING_SPLIT function in a table-valued function that I wrote the other day. When I went to sync the database to my SSDT database project, however, the project would no longer compile.

Continue reading →

Tagged SQL Server, SSDT, T-SQL

ogr2ogr (GDAL 2.x) fails mysteriously

Sql2Go Consulting Posted on February 24, 2017 by meganFebruary 26, 2017

Update (2/26/17): It turns out that I did have uses for several of the GDAL 2.1 features, and there was a simple fix for the problem — switch to a different distribution. I tried the GIS Internals msi installer and everything worked the way it should.

Continue reading →

Tagged geospatial, SQL Server 2016

“Proximity” Genealogy Database Project

Sql2Go Consulting Posted on February 14, 2017 by meganAugust 3, 2017

I am developing a proof-of-concept for a genealogical database intended to support querying for various proximities including Generational relationships (traditional family tree) Proximity of events in time and space (geolocation) Genetic proximity (DNA matching via SNPs)  

Continue reading →
Tagged Azure, Development, ETL, Genealogy, geospatial

Recent Posts

  • BundlerMinifier.Core quits working after Visual Studio 2019 update
  • .Net Core 3.1 Azure App Service startup exception: System.IO.DirectoryNotFoundException
  • Link: WDeployConfigWriter Account Issues
  • Specifying Schema Names in Entity Framework Core Code-First Models
  • SQL Server SP or CU upgrade script failures — Do WHAT to my master database?

Categories

  • ASP.Net Core
  • Code
  • Development
  • Entity Framework Core
  • JavaScript
  • Miscellaneous
  • MS Web Deploy
  • Proximity
  • SQL Server
  • Visual Studio 2019

Archives

  • April 2021
  • May 2019
  • December 2018
  • February 2018
  • October 2017
  • August 2017
  • July 2017
  • May 2017
  • April 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • September 2016
  • June 2016
  • September 2015
  • January 2015
  • December 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • October 2013
  • June 2013
  • May 2013
  • March 2013
  • November 2012
  • October 2012
  • September 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2011
  • January 2010
  • February 2009

Tags

Administration ASP.Net Azure BI C# CLR CMS CSV DBA DB Engine Deployment Development ETL Excel Functional Programming Genealogy geospatial Installation LINQ Locking Maintenance MDS Optimization Performance PowerPivot Relational Model Report Designer ReportViewer Security SMO Source Control SP1 SQL Server SQL Server 2012 SQL Server 2016 SSAS SSDT SSDT-BI SSIS SSMS SSRS T-SQL TFS Visual Studio XML

Sql2GoSM is an IT consulting service
located in Sacramento County, California, USA


© 2014-2021 - Weaver Xtreme Theme Privacy Policy
↑ Cleantalk Pixel