(Jayakumar Balasubramaniam) There are lots of online tools to convert JSON data into Excel. However, if you would like to develop a custom solution for your company here is a simple way to do so with Angular4.
Community
SQL SERVER – Unable to Remove Replication Publication – Could not Delete the Subscription at Subscriber ‘SubServer’ in Database ‘SubDB’
(Pinal Dave) While playing with my lab server having broken replication, I encountered an error message when I was trying to remove publication.
How can I pause my code in Visual Studio? Breakpoints FAQ
(Leslie Richardson) Have you ever found a bug in your code and wanted to pause code execution to inspect the problem? If you are a developer, there’s a strong chance you have experienced or will experience this issue many, many times.
A Kind Introduction MySQL Windowing Functions Part I
(Dave Stokes) Windowing functions are a critical tool for grouping rows of data that are related to other rows.
Using Angular in ASP.NET MVC 5 with Angular CLI and Visual Studio 2017
(Mithun Pattankar) Angular is one of most in-demand web front-end frameworks developed by Google, it gets integrated with any Server side technology.
Which Character Set Should You Use in MySQL?
(Jesper Krogh) MySQL supports a long list of character sets, and one of the strong points are that you can use different character sets per column. This is very flexible, but which character set should you use?
APEX New Workspace
(Michael McLaughlin) After you install APEX or upgrade a base APEX, you need to create workspaces. These instructions show you how to create a workspace in APEX 18.
Controlling Data Access in Azure for Administrators and Owners
(Melissa Coates) Recently a customer expressed concern that an owner of an Azure resource group automatically gains access to the data within the services contained in the resource group.
SQL Server Automatic Tuning in the Real-World
(johnsterrett) In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run faster.
BMC and the Mainframe: An Ongoing Partnership
(Craig S. Mullins) No, the mainframe is not dead… far from it. And BMC Software continues to be there with innovative tools to help you manage, optimize, and deploy your mainframe applications and systems.