Blue Screen Error happen whenever your computer is encountered with something it doesn’t know how to process, so it shuts itself down to prevent any damage with showing a Error code li… Read More
When client makes an HTTP request to IIS, there are many layers of drivers and services it travels through. In this blog, I wanted to give a high level overview of the major layers showing h… Read More
A couple of times now I have faced this issue with my clients where SQL Server session is blocked by another session that has a negative SPID value. When we ran sp_who2 the SPID value that w… Read More
Workloads that rely on auto-commit (each operation like an INSERT has an implied, corresponding begin and commit transaction) and perform a large number of small transactions may take signif… Read More
As we start to see more and more ASP.net Core applications being used in production, our customers are coming to us with problems that are specific to these types of deployment scenarios. Th… Read More
This blog details a recent customer deployment by Cognizant SAP Cloud team on HANA Large Instances. From an architecture perspective of HANA Large Instances, the usage of HANA System R… Read More
Guest Post.
Caltex is looking for the next gen of disruptive businesses for its Spark Accelerator Program
February 2017: Caltex Australia, the nation’s leading transport and fuel s… Read More
Azure SQL Data Warehouse manages query workload through a combination of concurrent query execution slots and resources classes. The SQL Data Warehouse workload manager enables you to manage… Read More
Azure SQL Data Warehouse allows you to manage your workload using resource classes and concurrency slots for query execution. In the previous blog, Checking for Queued Queries, we showed you… Read More
Inside Distribution Cleanup Watermark
The Distribution database is a cache of undistributed commands that the Distribution SQL Agent jobs are responsible to deliver to their subscribers.&nbs… Read More
We noticed a few requests come to our support queue asking for a feasibility to export Azure SQL Database to local path directly, so following steps below to build PowerShell script th… Read More
Writer: Simon SuTechnical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah
Scheduling and Yielding Knowledge Recap
We all know that SQL server is a multi-threads and multi… Read More
SAP systems moved onto Azure cloud now commonly include large multinational "single global instance" systems and are many times larger than the first customer systems deployed when the Azure… Read More
IIS and HTTP.sys logs contain incredible source of information to help in identifying potential issues.
When I first started troubleshooting IIS/Websites issues, LogParser (and LogParser Stu… Read More
A few days ago, I came across an issue where we had to change the SQL server instance collation and we were just asking the clients to rebuild the system databases to do so in the previous c… Read More
Reviewed By: Ajay Kalhan, Borko Novakovic, Drazen Sumic, Branislav Uzelac
In the current Azure SQL Database Managed Instance (MI) preview, when customers create a new instance, they can allo… Read More
Overview
In this blog, I will show how you can use Application Insights to monitor your web application written in Python using the Flask framework. The sample code can be found here… Read More
Reviewed by: Dimitri Furman, Xiaochen Wu
Apache Spark is a distributed processing framework commonly found in big data environments. Spark is often used to transform, manipulate, and aggrega… Read More
I have been asked several times about how to get a Performance Monitor like view on Linux. There are lots of Linux tools available (top, iotop, Grafana, and SQL Sentry just scrat… Read More
At the event of SQLSaturday Dallas 2018, it was a great honor to present this new feature that allows you to put Distribution database in AlwaysOn AG. The slide deck for the session can be… Read More
Authored by Philip Froese [MSFT]
In the next release of the HLK, the UCSI tests have been updated to run against the new Type-C SuperMUTT device instead of a partner system. This means the t… Read More
Microsoft announced user-defined restore point on Azure SQL Data Warehouse.
This feature enables you to manually trigger snapshots to create restore points of your data warehouse before and… Read More
Did you know that you can execute R and Python code remotely in SQL Server from any IDE? This eliminates the need to move data around. Instead of transferring large and sensitive… Read More
Hello all,
Recently I had worked on an interesting issue with rapid growth of Tempdb on AlwaysOn secondary replica. In this article, we will cover the approach and the queries used to isola… 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
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
Today, coinciding with the .NET Conf 2018, we're announcing the release of ML.NET 0.5. It’s been a few months already since we released ML.NET 0.1 at //Build 2018, a cross-platform, op… Read More
Over the years you have read a number of blogs advocating for or against trace flags that influence SQL Server’s query execution model. You can see a number of query execution related… Read More
Run From Package deployment has many advantages and makes DevOPs life much easier. No more live editing, no more file in use error, better cold start performance, same version gets deployed… 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
Today we’re announcing our latest monthly release: ML.NET 0.6! ML.NET is a cross-platform, open source machine learning framework for .NET developers. We want to enable every .NET deve… Read More
This post was written by Varun Venkatesan, Li Tian, Denis Pravdin, who are engineers at Intel. They are excited to share .NET Core-specific enhancements that Intel has made to VTun… Read More
Quite simply, to speed up the recovery time of your IaaS Linux Virtual Machine most recovery options will be possible if GRUB is configured.
Recovering Linux Virtual Machines in Azure
You wi… 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
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
Azure Security Kit aka AzSK is a framework that is used internally by Microsoft to control & govern their Azure Subscriptions. While some features are overlapping with Azure Securi… Read More
I was doing backups and clean-ups and ran across a couple of sample projects for XEvent and event_sequence processing I thought others might find helpful. – Enjoy!
The sample code is… Read More
A distributed availability group (DAG) is a special type of availability group that spans two availability groups. This blog will clarify some issues regarding failover in a DAG.
A simple DA… Read More
One of the many great features of Azure SQL Database is the ability to scale up or down depending on the amount of workload an instance is processing, which means there is greater control of… 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
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
A quick lesson learned from the field when dealing with TDE (Transparent Data Encryption).
After running something like
ALTER DATABASE [AdventureWorks] SET ENCRYPTION OFF
One quick spot wher… Read More
CGMagazineLiam Ferguson
Granblue Fantasy owner Cygames announced that Arc System Works’ fighting game adaptation Granblue Fantasy Versus is receiving a closed beta on May 31st.
The… Read More
Having bagged many a Miss World’s and Miss Universes, India has established its brand in raising The Most Beautiful and the prettiest women in the World. The fine upbringing and divers… Read More
Human inquisitiveness knows no bounds. Who will not like to know about about the hottest female models from India and that too when Indian models are a rage across the world. N4M brings you… Read More
Brunch is, without question, the best meal of the day. Nothing quite compares to rolling out of bed at 11:30 on a Sunday morning only to tuck into a giant serving of eggs benedict with potat… Read More
The great thing about Arch Linux is that you may customize everything, making your system as heavy or lightweight as you wish. This can also be a pain point for maintenance. Some things requ… Read More
September 22, 2022 – Fluidra, the global leader in pool and wellness equipment and connected solutions, today announced the appointment of Lennie Rhoades as the next President of Fluid… Read More