Migrating your databases to the cloud is a complicated and time-consuming task that involves a lot of variables, such as what to migrate, how to migrate it, and the target and SKU to which y… Read More
Few days back, one of my clients' faced an issue with their Availability group getting into the resolving state. On checking the logs found that the issue was due to a split brain scenario a… Read More
I am updating, or should I say, re-coding a website I have from ASP.NET Web Forms (aspx) to ASP.NET Core Razor Pages (chtml). The database it connects to only has a global admin, full… Read More
Azure Command Line Interface (CLI) is a command line library that enables you to quickly and easily work with your Azure SQL Managed Instances. In this post, you will see some basic CLI comm… Read More
Okay folks, we need to have a conversation about SYSTEM permissions in SQL Server. SYSTEM is constantly over-permissioned in SQL Server . Some of the reasons given for why SYSTEM is ove… Read More
As more users migrate their SAP workloads to Azure, they will discover the benefits of migrating the Microsoft SQL Server data tier as well. Storing SQL Server data files on Azure can help s… Read More
We recently released a new version of SQL Server 2016 Report Builder that contained a brand new feature – the ability to enter data directly into an RDL report as an embedded dataset… Read More
Azure Kubernetes Service (AKS) makes it simple to deploy a managed Kubernetes cluster in Azure. The sample application for this article is developed in Angular, ASP.net core and SQL Server… Read More
Today, we are very excited to announce general availability of offline migrations and public preview availability of online migrations to Azure SQL Database Managed Instance in the Azure Dat… Read More
SQL Vulnerability Assessment is now available for Azure SQL Data Warehouse and for Azure SQL Database Managed Instance. The assessment functionality and experience are similar to that of SQL… Read More
This article was co-authored by Dimitri Furman and Denzil Ribeiro
Reviewed by: Danimir Ljepava, Borko Novakovic, Jovan Popovic, Rajesh Setlem, Mike Weiner
Introduction
In our ongoing engagem… Read More
SQL Server 2017 and Azure SQL Database introduced native graph database capabilities used to model many-to-many relationships. The first implementation of SQL Graph introduced support for no… Read More
Comparing Azure Functions and AWS Lamba
Herve Roggero is recognized for his thought leadership and passion for providing accessibility to data in the tech space. Herve’s… Read More
Hello all,
While working with SQL Server, one of the common issue application teams encounter is timeouts. In this article, we are covering approach to troubleshoot SQL Command/Query timeou… Read More
What Is Optimizer Timeout?
SQL Server uses a cost-based query optimizer. Therefore, it selects a query plan with the lowest cost after it has built and examined multiple query plans. One of… Read More
How to connect with an existing VM to your Managed Instance Vnet
This guide assumes you already have a deployment of a Managed instance in your subscription
Problem summary:
Initially, you… Read More
Two weeks ago, I found one of my clients encountering an interesting issue where he found that the SQL server management studio (SSMS) works only when it is launched as an Administrator. But… Read More
How to create a native app registration
This guide assumes that you already own an Azure Subscription, an Azure Active Directory properly setup and your PowerShell environment properly set f… Read More
This tutorial assumes the Managed Instance is already created and that connections from the jumpbox also work.
If you have a Managed Instance and would like to connect directly from a place… Read More
When you are creating a new database you can change the collation in the portal
Or else using TSQL (https://docs.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-da… Read More
Consider that you have configured the LTR Backup for your Azure SQL Database and you are not able to view it on the Portal.
Figure 1: LTR configure policies pane
And when you click on avail… Read More
We are happy to announce General availability of Business Critical tier in Azure SQL Managed Instance - architectural model built for high-performance and IO demanding databases.
After 5 mo… Read More
I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article.
An example of the error: The application does… Read More
Overview
SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I… Read More
Hello,
Today I worked on a service request that our customer needs to know how the statistics are automatically updated by SQL Engine and what is the impact of this process in terms of consu… Read More
Changing database vendors is not an easy task, but a lot of people do it and for multiple reasons including better pricing or features. Microsoft provides a free tool called the SQL Server M… Read More
Hello Team,
Some days ago, I worked in a service request in this following scenario:
Using the portal, our customer, copied the database from one server to another.
After it, our customer wa… Read More
SQL Server 2017 introduced a small change to SQL Server’s default worker thread calculation, accounting for smaller environments. When running on smaller environments SQL S… Read More
If you are in the process of moving an existing .NET application to Azure, it’s likely you’ll have to migrate an existing, on-prem SQL database as well. There are a few different… Read More
SQL Server Migration Assistant 8.0 introduces support for Azure SQL Database Managed Instance as a target. Whether you were planning to migrate or already in the process of converting your d… Read More
Overview
SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schem… Read More
We find great pleasure in announcing the public CTP 2.3 of SQL Server 2019 Analysis Services. New features detailed here are planned to ship later in Power BI Premium and Azure Analysis Serv… Read More
We are excited to announce the public CTP 2.4 of SQL Server 2019 Analysis Services. This public preview includes the following enhancements for Analysis Services tabular models.
Many-to-many… Read More
BELLEVUE, Wash. – December 2019 – TimeXtender, a recognized global software company enabling instant access to any type of data in the organization to support advanced… Read More
In the spirit of my 2020 recap, I thought it’d be fun to look back at everything that happened on this blog in 2021.
Controversy Strikes
The year opened with my most controversia… Read More
12 Niche Blogger Series
12 Niche Blogger Series- Instantly Create Your Own Network of Niche Empire
Highly Improved Features
Here’s some of the great enhancements to make your blogging… Read More
A princípio, falar em dados é falar na nova cultura do trabalho. Não existe empresa hoje que queira sair na frente e não tenha orientação para dados… Read More
Blockchain is a charismatic technology, working wonders through its smart contracts and nodes. From finance, logistics, real estate, digital assets, you name it; blockchain is gaining popula… Read More
PHP is a popular programming language that is used to create dynamic websites. A PHP framework is a software application that provides a structure for developing web applications, and Larave… Read More
A princípio, uma das linguagens de programação mais usadas no mundo hoje, Python é um grande coringa no arsenal de qualquer programador. Com uma linguagem orienta… Read More
A princípio, o Google DataStudio tem ganhado lugar em entrevistas de emprego e em solicitações de empresas que buscam modernizar sua visualização de dados… Read More
A princípio, o Google Data Studio tem ganhado lugar em entrevistas de emprego e em solicitações de empresas que buscam modernizar sua visualização de dados… Read More
O curso de engenharia é um dos mais antigos e um dos que até hoje brilham os olhos de quem procura por melhores salários. Uma profissão tipicamente da área… Read More
Existem diversas engenharias no mercado, mas nenhuma chama mais atenção do que a engenharia de dados. Com um aumento nas ofertas de vagas e nos salários associados a ess… Read More
The greatest risk to the security of a web application is when it either accepts user input and processes it or renders data in a comprehensible format (HTML, JSON, etc.) to the user.
For… Read More
Founded in 2017 and regulated by the US MSB (Financial Crimes Enforcement Agency), Slyde Cryptocurrency Exchange is an innovative multi-currency digital asset trading platform for the world… Read More
It is noticeable that the labor market has been in disarray for some time, i.e. that there is not enough labor for certain industries, since COVID-19 was also a trigger for the so-called "Th… Read More
Blockchain app development is gaining momentum at a fast pace and this trend is here to stay. Blockchain solutions have proven their worth as game-changers in almost every industry vertical… Read More
Review
In this post we will aim at secucuring Apache and PHP on our Ubuntu Server 22.04 through various configuration directives. Let’s review what we did so far:
We installed an… Read More
The focus of this article is on showing how to configure your WordPress installation to improve speed using the AWS CloudFront CDN and enhance security using AWS WAF. This builds on the earl… Read More
This units of measurement guide provides a reference of the size of different types of quantities.
Units of measurement reference
Our table of contents lists a good set of tables for d… Read More