It’s time to switch to a new development tool for SQL Server and Azure SQL. Here’s how to get started with the MSSQL extension for Visual Studio Code. Microsoft recently ended support for Azure Data ...
A tool which treats CSV and JSON files as SQL tables, performs SQL SELECT queries on them, and stores the result into CSV and JSON files. Many tools and systems can export their data to CSV. Typical ...
In order to access geometry data from OGR, the PostGIS extension has to be installed: if it is not installed, geometry will be represented as bytea columns, with well-known binary (WKB) values. To ...
As PPC account managers, we’ve always had to do a lot of reporting to keep our stakeholders informed. Now with the continued rise in automation, reporting has taken on new importance as one of the key ...
Update 2018-06-06: Please not that in the step involving reviewing the schema for the Response step, be sure to check that each column’s type is specified as string, integer, boolean, etc. or the flow ...
With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them. In a previous Practical .NET column I showed ...
Data privacy is a major concern today for any organization that manages sensitive data or personally identifiable information (PII). Examples of such data include sensitive customer information such ...