Visual Studio Code appeared years ago as a light option to the full Visual Studio Environment. Being light, there are some features that we don’t have or at least took some time to appear. C# XML Comments is one of them. If a code needs to be full of comments, it’s possible the code is … Read more
Many DBA skills transfer when moving to the cloud, but you'll have to make some adjustments in many cases. In this post, Dennes Torres explains one of the differences when setting up Extended Events sessions in Azure SQL Database.… Read more
Azure Cost Management is in constant evolution to help manage the cost of services in the cloud. Microsoft provides the Azure Cost Management Power BI App to manage cloud costs, but this app only works with Enterprise Agreement accounts. This was a considerable limitation, since many companies use the cloud using Customer Agreement instead of … Read more
Introduction It is important for many development jobs to be able to look at the differences between PowerShell objects. It might be that you are checking how Windows processes change over time: Perhaps you are monitoring various signs of stress on a server but are at the exploratory stage, where you need to see the … Read more
How to make conditional decisions in a package It may seems strange the lack of a decision task for the control flow. However, there is a work around to allow us achieve the same effect we would have with a “decision task”. The precedence control between tasks can be based on an expression. Building the … Read more
Entity Framework had objects called conventions. These objects can be used to make configurations on the entity framework context to change its default behavior. Two examples of behaviors we usually configure are the pluralize behavior for object names and delete cascade for foreign keys. Entity Framework Core, on the other hand, doesn’t have conventions. How … Read more
In the previous blog, I illustrated how to create sub-queries in Kusto. However, sometimes we may face even more complex situations and we may need to create not only a sub-query, but a function. Another way to think about a function inside a Kusto query is like a parameterized sub-query. Let’s review the query from … Read more
The SQL Server graph database feature allows you to model relationships that would be too complex for traditional relational tables. In this post, Louis Davidson demonstrates how to load existing data into graph objects in SQL Server. … Read more
In the same way as other query environments, Kusto queries in Log Anaytics can become complex. We need similar features in Kusto as we have in SQL Queries and one of these features is sub-queries. The Problem On the example below I’m building a query over my blog’s Log Analytics Data to identify the amount … Read more
In my article “Filetables, Great For Business, Great For Hobbyist”, I implemented the basis of a hobby database I use for my Twitter accounts (@disneypicaday and @dollywoodp), where I post daily pictures of theme parks. As my inventory of prepped pictures has grown, one thing has become a major pain. Duplicates. I have tens of … Read more
I’m working on some personal .NET Core projects and I faced some strange errors. Ok, I’m too fresh on .NET Core and I expected this. What I was not expecting is to find problems with .NET Core folder structure no one would be able to correctly identify and in the end discover what I imagine … Read more
It’s been a while since I last wrote a new blog, and it has been a very long time since I last wrote a fresh new “What Counts For a DBA” entry. I celebrate this with a pun title. The last technical blog I wrote was scheduled to be published on March 19, 2021 and … Read more
You need to dig into old blogs I wrote before to fully understand how interesting this new extension is. On Saving Money with Log Analytics I mentioned how important log analytics is for azure clouds. This deserves more in depth analysis, which probably will be broken down in blog articles. On Connecting to Log Analytics using … Read more
What is EMR? Elastic MapReduce is an Amazon web service tool for big data processing and analysis. The MapReduce is a framework that allows programmers to process large scale data across distributed processors in parallel. Amazon EMR processes big data across a Hadoop cluster of virtual servers on Amazon Elastic Compute Cloud (EC2) and Amazon Simple Storage … Read more
I was developing some personal .NET projects when I faced some problems. Probably they are usual problems during a .NET development, but I had to ask some questions on the .NET Community. Where could I ask some .NET questions? First place I looked for was TechCommunity. However, to my surprise, TechCommunity doesn’t have a hub … Read more
A fully managed Memorystore option is a default choice for serverless technologies, but it's not without limitations. In this post, Tushar Jangle and Dhananjay Hedaoo explain how they worked through the issues for their application.… Read more
What is Spark? Apache Spark is an analytics engine for large-scale data processing, with powerful built-in modules for data streaming, SQL, machine learning and graph processing. When working with large-scale data processing, the spark is the best analytics engine to work with. Apache Spark achieves high performance for both batch and streaming data and workloads can be … Read more
How do you list all the objects and values within a PowerShell object, investigate an object or explore its structure? There must be a simple way. I used to use ConvertTo-JSON. This is fine up to a point but what if you just wish to search for strings or look for objects with a cartain … Read more
Introduction MVC 4 introduced request bundling and minification techniques to reduce request load time. Bundling allows us to request a collection of static files from the server in one HTTP request. Bundling The technique of bundling is shown in the diagram below: Source – Loading script files in separate requests In the namespace System.web.Optimization, MVC … Read more
What is ngFor in Angular Template syntax? Angular makes use of HTML for templates associated with components that eventually represent the views of your front-end application. A component controls the part of the user’s application UI and the associated template is what gets rendered in that part of the User Interface of an Application. The … Read more
Simple Talk Bloggers
Subscribe for more articles
Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
