simple-talk.com simple-talk.com

Using Log Analytics to Connect to Power BI

Log Analytics is a basic tool for the entire Azure environment, I wrote about it before. The possibility to access log analytics data from a tool for analysis, such as Power BI, only increases its importance. There are some options to make this access and we expect these options to improve very soon. Using Notebooks in Azure Data Studio That’s an interesting option, not related to Power BI: We can use notebooks in Azure Data Studio...

simple-talk.com simple-talk.com

Oracle Sequences: RAC

The series so far: Oracle sequences: The basics Oracle sequences: RAC In my first article on Sequences, I reviewed the fundamental reason why Oracle Corp. introduced the mechanism (i.e. synthetic/surrogate keys) and the mechanical threats (cache size and index contention) that still had to be addressed by the developer/DBA. In this article, I’ll spend most of my time explaining how the problems can get worse (and be addressed) as...

simple-talk.com simple-talk.com

Power Query: Transforming Desktop Queries in Dataflows

.There are some interesting ways to transform queries from Power BI Desktop to Power BI dataflows in the portal. The UI can be a bit confusing. I made some mistakes in the middle as well. Let’s see some options to make the conversion. Leaving Blank Query Blank Create a new dataflow Select Blank Query as the source Select the gateway used to access the on premise servers It seems strange to select a gateway for a blank query....

simple-talk.com simple-talk.com

Documenting and testing APIs with Postman

There’s no question whether testing is important to the evolution of your APIs, especially when they come in an automated manner. Many teams also lack documentation of all sorts to guide new people on understanding and using the endpoints. This article covers documenting and testing APIs with Postman. You probably have heard about Postman, the famous collaboration platform for API development and testing. Yes, testing. Many...

simple-talk.com simple-talk.com

What is an ad hoc query?

Someone recently asked me which queries are ad hoc in SQL Server. An ad hoc query is a single query not included in a stored procedure and not parameterized or prepared. Depending on the server settings, SQL Server can parameterize some statements initially written as ad hoc queries. Ad hoc doesn’t mean dynamic. Here’s a simple ad hoc query example in SQL Server: SELECT LastName, FirstName FROM Person.Person; SQL Server will...

simple-talk.com simple-talk.com

Malta Data Saturday and Our New Era

The Malta Data Saturday is finishing. I still need to compile the numbers, but the comments and feedback are great. Let’s talk a bit about the story of this conference and I hope this story can provide it’s 2 cents to the build of our new era, at least starting many discussions about do’s and don’ts on new era conferences. Specially for community members and event organizers, I believe it will worth reading. The story needs to...

simple-talk.com simple-talk.com

SQL Server plan cache mining – Plan attributes

The execution plan cache in SQL Server is a treasure trove of information about queries that have recently executed. In addition to query text and execution plan details, a wide variety of statistics, options, and parameters are available to research, if needed. This information may not always be needed for troubleshooting a performance challenge, but when it is, knowing where to go and how to use it can be a massive time saver. In...

simple-talk.com simple-talk.com

How different roles view database DevOps

Redgate released the 2021 State of Database DevOps Report in February, and I wrote a short article talking about the key insights from the report. More recently, I decided to take a deeper look at the data, especially how folks from different roles answered the survey questions. To simplify my analysis, I grouped respondents into four roles: Technical leaders Architects and business analysts Database administrators Developers Change...

simple-talk.com simple-talk.com

Using MySQL with Unity

SQL is the language of data management, and Unity is a game engine. The two seem to have very different goals, with one focusing on managing a database while the other is built primarily for the creation of video games. Can the two work together? As is so often the case in the world of programming, the answer is a resounding “yes.” As far as the games industry is concerned, databases are most useful in applications that require...

simple-talk.com simple-talk.com

Automating Azure DevOps with Logic Apps

The Azure DevOps Services is a cloud offering that offers a quick way for project managers, developers, and infrastructure engineers to set up their project foundation. The Azure DevOps core services include three components: Azure Boards, which include native support for Scrum and Kanban, aims to help project managers plan, track, and collaborate work across teams. Azure Pipelines to support continuous integration (CI) and continuous...

simple-talk.com simple-talk.com

How to choose between SQL and NoSQL databases

Organizations that support data-intensive applications must make many decisions about how to best implement and maintain them. One of the biggest decisions is to determine the best platforms to use for storing and delivering the application data. In the past, most organizations opted for SQL databases because of their ability to protect data and ensure its integrity. But the rise of the internet and cloud technologies—and the...

simple-talk.com simple-talk.com

Insurance price prediction using Machine Learning (ML.NET)

This article discusses how to write a simple console program for Insurance price prediction using ML.NET. This article does not discuss machine learning basics and types of algorithms. The focus of this article is how to use ML.NET for predicting the price of insurance. Machine Learning in insurance Machine Learning (ML) is all about programming the unprogrammable. For example, if you want to predict an insurance price, ML helps to...

simple-talk.com simple-talk.com

How to improve DevOps communication clarity

DevOps challenges and transforms existing cultural norms – the entrenched social, behavioral, and communication links between people. When technology and software delivery organizations respond to snowballing business demand, the drive for swifter software delivery, and amplified operational resiliency, communications must transform if revenue-driving business process outcomes are to be realized. The pace of business quickens...

simple-talk.com simple-talk.com

Can a monitoring tool save money?

When I was a DBA responsible for 40 to 50 SQL Server instances, I didn’t have many third-party tools to help me do my job. I remember that I was able to buy a tool to compress database backups before that functionality was built into SQL Server. I also had a handful of licenses for a monitoring product that I had to swap around as problems came up on different servers, losing the history and trends. It was almost not worth using the...