(Kenneth Fisher) If you’ve worked with SSMS for any length of time this will look awfully familiar:
Tag: sql server
Dynamically Read event_file Data
(Jason Brimhall) In the previous article I covered the basics on extracting the payload for the events in a session from the event_file target. That article was a basic introduction.
Store JSON data in a table, OPENJSON and JSON_Value functions | SQL Server 2016 – Part 4
(Manoj Pandey) In my previous posts I talked about how to [export] a Table or Query data into JSON string format, and [read it back] from JSON string to Relational-table format, and with [nested elements].
Run a SQL script across all Dynamics GP company databases
(Steve Endow) This may be posted elsewhere, but I just whipped it up quickly and thought I would post it for posterity
Copying data from Azure Blob Storage
(James Serra) In a previous blog I talked about copying on-prem data to Azure Blob Storage (Getting data into Azure Blob Storage). Let’s say you have copied the data and it is sitting in Azure Blob Storage (or an Azure Data Lake) and you now want to copy it from Azure Blob Storage into either SQL S
Automating Everything (and Integrating IoT) with Azure Logic Apps
(Scott Hanselman) Jeff Hollan stops by Azure Friday and he’s brought a Raspberry Pi. Jeff shows Scott how to turn on his sprinklers using a Raspberry Pi and the automation power of your own Logic App running in Azure App Service.
SQL SERVER – Why Should You Not to Use Old Style JOIN?
(Pinal Dave) If you want to JOIN two tables you can do it in two ways. One using ANSI compliant INNER JOIN and another with old style join
Counting NULLs and sub-sets of data
(Derik Hammer) You have been asked to produce a chart which will visualize a few data points.
Enabling Data Compression – October 2015 Update
(Shaun Stuart) It’s been about a year and a half since I last posted an update to my script that scans databases for objects to compress and, optionally, compresses them. This time around, I’ve just incorporated a bug fix and added a check to make sure the script is running on an edition of SQL Serv
In SQL Server 2016 CTP3 objects can DIE (DROP IF EXISTS)
(Jovan Popovic) Do you like to write following conditional DROP statements:
