(Manoj Pandey) In my [previous post] I discussed about how to Import or Read a JSON string and convert it in relational/tabular format in row/column from.
Tag: sql server
Intro to Reading Event_File Target Data
(Jason Brimhall) Having covered the metadata for a deployed session from just about every angle (yes there is more on metadata that could be discussed, has not yet been discussed, and that I am not planning on covering at this time), it is high-time to start figuring out how to query the payload tha
Advanced Azure Logic Apps with Jeff Hollan
(Scott Hanselman) There’s a lot more to Azure Logic Apps than just a nice visual editor. There’s a whole JSON-based language grammar in this episode of Azure Friday Jeff Hollan explains the internals of Logic Apps and gives us the tools to explore more.
SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results – Part 2
(Pinal Dave) What do you do when you encounter something that you didn’t expect? A lot of times such experiences take you to a state of shock or a state of bafflement. The curiosity sometimes pushes you off the cliff to understand why certain behaviors occur.
Getting Started with Power BI Designer
(Scott Murray) Microsoft is offering a new tool called Power BI Designer; what exactly is this tool and what is it used for?
SQL SERVER – Steps to Backup to Windows Azure storage
(Pinal Dave) Moving to a cloud based world is inevitable, it is something we need to learn soon. Ever since SQL Server 2014 has been released, the concept of uploading your backups to Blobs with Windows Azure has been around.
Keep an eye on those Audit files!
(Kenneth Fisher) This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server Audits. Fortunately this is one I have a bit of experience with. It’s one of my favorite new features if only because it’s so simple to use. There is howeve
Passing multiple/dynamic values to Stored Procedures & Functions | Part 5 – by passing JSON string
(Manoj Pandey) This post is part of the [Passing multiple/dynamic values to Stored Procedures & Functions] series, and as well as the new feature Native JSON support in SQL Server 2016.
Azure API Apps 102 – Adding Authentication
(Scott Hanselman) Guang Yang continues to educate Scott on Azure API Apps. In this episode, we add authentication and an understanding of identity to an Azure API App.
SQL Server 2016 Installation Changes
(Rajendra Gupta) SQL Server 2016 CTP 2 (Community Technology Preview) was recently released. It is a big leap forward with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and new hybrid cloud scenarios. There are
