Data in Columnstore index is stored as columns, each column is stored and accessed independently of other columns unlike rowstore where all columns in a table are stored together. This allow… Read More
We recently released a DIXF Application Hotfix for AX 2012 R3 that you may want to take a look at if you are running a Clustered configuration / AlwaysOn configuration:
The changes in the ho… Read More
SQL product team has made significant implements in columnstore index functionality, supportability and performance during SQL Server 2016 based on the feedback from customers. This blo… Read More
Now, Python and R are the commonly used languages for the statistical computing, but these are not easy to learn and use for the business users.
Several months ago we introduced R visuals fo… Read More
Clustered column store indexes (CCI) in SQL Server vNext and Azure SQL Database support LOB types like NVARCHAR(MAX), which allows you to store strings with any size, including JSON document… Read More
One of the most common BizTalk architectures I have seen across customers is as follows:
With this configuration, BizTalk server is deployed using a high availability configuration that wil… Read More
Authored by Rakesh Patil (AzureCAT). Edited by Nanette Ray and RoAnn Corbisier.
Introduction
Recently, the Azure team worked with a customer to set up GlusterFS, a free, scalable, open sourc… Read More
As discussed in my previous blog post, one of the primary scenario for DBCC CLONEDATABASE is to assist dbas, developers and support teams in troubleshooting sub-optimal query plans by creati… Read More
Working with Hive, I regularly find myself staring at a csv/tsv/json files wondering where to start….
Hive View 2.0 is a new Web Experience in HDInsight 3.6 that greatly simplifies ma… Read More
Working with Hive, I regularly find myself staring at a csv/tsv/json files wondering where to start….
Hive View 2.0 is a new Web Experience in HDInsight 3.6 that greatly simplifies ma… Read More
After patrolling some of the installations out there, our Ghostbusters team has decided it is about the time to bust the myth of a few ghosts out there, and the first on the list is our Smar… Read More
Having the right nutrition is essential to cure Hidradenitis Suppurativa, the persistent auto-immune, inflammatory skin disease. This condition is often responsible for drastically reducing… Read More
A few months ago we released a new SAP BW statement generator, which increases BW query performance for complex queries containing FEMS filters, see https://blogs.msdn.microsoft.com/saponsql… Read More
This step involves deploying an Azure SQL Server Database that can be used to host the Entity Store Database. This is will be the data source for the Power BI Embedded Service created… Read More
This step involves deploying an Entity Store database onto your Azure SQL Server created in the previous step.
Before you proceed, be sure to process the Aggregate Measurements using the Dyn… Read More
One of the design goals of SQL Server 2016 was to improve performance and scalability of the engine out of the box to make it run faster without the need of any knobs or trace flags for cust… Read More
The United States is a Republic. The Constitution spells out how one of our Country’s most fundamental Acts of Representative Government is undertaken, choosing the “Times, Place… Read More
A couple of days back, when I was troubleshooting an issue related to SQL Fail-over cluster instance upgrade I encountered this strange issue of not able to get the newly added SQL server an… Read More
We are excited to announce general availability of clustering of an SAP (A)SCS instance on Windows Server Failover Cluster (WSFC) with file server, e.g. Scale Out File Server (SOFS) and Stor… Read More
Cross post with http://aka.ms/sqlserverteam
A similar question about statistics came to the team twice this week: why does updating with fullscan result in fewer histogram steps than when do… Read More
Brian Harry’s recent blogpost about a twitter sentiment analysis as a release gate impressed me a lot and I wanted to find out how complicated it is to do an analysis for my own stuff… 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
It's that time of year again and Imagine Cup is about to start. Today we want to give you a short heads-up on what's coming up during the next couple of months.
Microsoft’s Imagine Cup… Read More
Guest blog by Ellen Pasternack, DPhil candidate at the University of OxfordAbout me
Hi! I'm Ellen Pasternack, a DPhil candidate in the University of Oxford's Interdisciplinary Bioscien… Read More
We have a database here that stores information about Azure SQLDB health issues; it was chugging along fine for months, then earlier this week it started to struggle. You can see the large i… Read More
It's been another rough day in Babylon as Ras would say. I say rough, but rough depends on how you look it at. Always a lot going on, but I guess it is how you look at it. How yo… Read More
Many gurus will tell you that as soon as you write for humans you will be fine. This is in part true. In fact, although the LinkedIn algorithm will pick up content based on quality and relev… 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
What is LinkedIn’s knowledge graph?
As LinkedIn engineering team put it:
LinkedIn’s knowledge graph is a large knowledge base built upon “entities” on LinkedIn, such… Read More
The Racist Origin of State Laws on Juries is encouraging Change. Split-Jury Verdicts are permitted to allow Ethnic Minorities to be Ignored.
Two Jurors who sat in Judgment at Willie Dunn Ju… Read More
These last days, I have been working in several service requests with same behavior.
Customer has an application that that is searching a value per execution.
The parameter value that is usi… 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
Pearl Abyss is a Korea based game development studio established in 2009. Black Desert Online, a PC-massively multiplayer online role-playing game (MMORPG), is their main title in prod… 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
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
Black Haven
– Poetry by Patricia Rossi – November 16, 2018
The Shadow Box
Displayed within, life’s moments extrapolated, tangible anguish, remnants of sorrow.
With haphazar… Read More
Hello Team,
Today, I worked on a performance case that our customer claimed about a performance issue with a copied database from other one. The source database was working as they expected… Read More
Over the years, we have been asked about what some of the Failover Cluster resources/resource types are and what they do. There are several resources that have been asked about on multiple o… 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
Finally, the Right Size
– Non-Fiction by Jody Forrester –
Already 5’9” at twelve years old, I never knew where my hands were until I bumped into a doorway or where m… Read More
The Burning Times
– Fierce Fiction by Caroline Misner –
Adele had known the man whose body was found nestled among the bags of expired bread behind the 7-11. H… Read More
For many years now, people with Fibromyalgia have been left in the dark when it comes to having a definitive test for the disease. The only reliable way to make a diagnosis currently is by l… Read More
Artist's conception of solar islands in the open ocean.
Millions of Solar Panels clustered together to Form an Island could Convert Carbon Dioxide in Seawater into Methanol, which can Fuel… Read More
By now, most attorneys and law offices are well aware of the need to market themselves online. But knowing you should do something and actually understanding the processes involved are two v… Read More
Nearly a month into opening the city after a 76-day lockdown, Wuhan, the epicenter of the pandemic COVID-19 has reported new cases. The new cluster of infections has now led the province to… Read More
A Black Hole is already terrifying as a concept. The idea of an inescapable well of gravity sucking everything in is something right out of our darkest nightmares. Despite this, the public i… Read More
Old Faithful is a famous cone geyser in Yellowstone National Park in Wyoming, United States. It erupts with such captivating punctuality that they named the whole gushing spring af… Read More
An analysis of the glaciers found on Mars revealed to the astronauts that the planet went through 6 to 20 ice ages in the past 300 to 800 million years. 20,000 years ago, during the ice age… Read More
New Jersey Landlord Sues to End Lease with Private Prison Company that holds Immigrants at the Property, at the Elizabeth Detention Center (EDC). The Crowded, Windowless Warehouse is Lesed t… Read More
Xiamen, China – TimesNewswire – On the west coast of the Pacific Ocean, Xiamen, a small island city that was once closed and backward, has miraculously emerged in the east of the… Read More
A State Panel, Friday, Approved Pennsylvania’s New Legislative District Maps, which could substantially Alter the Balance-of-Power in the General Assembly, for the next Decade, but are… Read More
Amotekun arrest 23 suspected kidnappers in Ondo
Men of the Ones State Security Network otherwise known as Operation Amotekun have arrested no fewer than 23 suspected kidnappers in the stat… Read More
The Biden Administration Overturned a Controversial Trump Policy that would have Opened New swathes of Arctic Alaska to Oil Development.
The Bureau of Land Management ( BLM), part of the D… Read More
We are surrounded everywhere by buildings that incorporate loads of stories. At first, they were nothing but well or poorly-designed chunks of concrete. Yet, as they continued to host people… Read More