(Jovan Popovic) GeoJSON is commonly used format for representing various geo-objects such as lines, polygons, etc. Sql Server 2016 enables you to parse GeoJson format using OPENJSON function.
Tag: sql server
Parallelize Data Flows with SSIS Balanced Data Distributor Transformation
(Daniel Farina) You have developed an ETL project that loads the contents of a flat file into a SQL Server database and after performing some tests you notice that there is a bottleneck with the transformations that slows the SSIS package execution. In this tip I will show you how we can speed up th
Store file data to SQL without streaming on server – MSDN TSQL forum
(Manoj Pandey) I need to store file(s) to SQL without streaming / reading at Server. I have created a Web API with AngularJS and SQL.
Parsing GeoJSON format in Sql Server 2016
(Jovan Popovic) GeoJSON is commonly used format for representing various geo-objects such as lines, polygons, etc. Sql Server 2016 enables you to parse GeoJson format using OPENJSON function.
Parallelize Data Flows with SSIS Balanced Data Distributor Transformation
(Daniel Farina) You have developed an ETL project that loads the contents of a flat file into a SQL Server database and after performing some tests you notice that there is a bottleneck with the transformations that slows the SSIS package execution. In this tip I will show you how we can speed up th
Store file data to SQL without streaming on server – MSDN TSQL forum
(Manoj Pandey) I need to store file(s) to SQL without streaming / reading at Server. I have created a Web API with AngularJS and SQL.
Geek City: Q&A
(Kalen Delaney) I have been accumulating a list of questions that have come up during my 5-day SQL Server Internals classes, that I cannot immediately answer. Sometimes I can figure out the answer myself with just a bit of research or a simple test, and sometimes I can ask one of my Microsoft contac
Coordinate Editing Functions for SQL Server Spatial
(Simon Greener) SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions:
The Azure SQL Data Warehouse gains an auditing feature
(Jessica Sirkin) Microsoft announced that it had enabled an auditing feature for the Azure SQL Data Warehouse. The new feature has many benefits, but storing audit logs won’t be free.
SQL SERVER – Reading Statistics IO data with SQL Server
(Pinal Dave) I am a supporter of always going to the basics when it comes to performance troubleshooting. Whenever I have done any perf tuning exercise, I start by enabling the Statistics IO as part of my debugging. When STATISTICS I/O is enabled, SQL Server maintains I/O statistics for the queries