(Shreyas R Gowda) 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 and SQL agent resources online.
Tag: sql server
Network Configuration of SQL Server Always On Availability Groups in Azure
(Marcin Policht) As we pointed out in our article recently published on this forum, implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and n
#0408 – SQL Server – Msg 1750: Could not create constraint or index
(Nakul Vachhrajani) An trivial problem came to my desk recently. We were having some issues in creating a table. The script was quite simple, and yet we were facing errors as shown below.
Obscure MDX Month: Optimising The Performance Of Total-To-Date Calculations In SSAS Multidimensional
(Chris Webb) Here’s a SSAS Multidimensional MDX tip that I picked up at the PASS Summit back in 2008 at Mosha’s excellent “MDX Deep Dive” precon (incidentally the slides and supporting material are still available here, although a lot of the material is out of date).
SQL Server Data Access Using R – Part 2
(Derek Colley) R is a popular data modelling, analysis and plotting framework that can be used to work with data from a variety of sources. In this tip, we will follow on from SQL Server Data Access using R – Part 1 and show how to perform further data analysis and refinements, demonstrate more R f
Querying Multi-Structured JSON Files with U-SQL in Azure Data Lake
(Melissa Coates) A while back I posted about this same topic using CosmosDB, for handling situations when the data structure varies from file to file.
SQL SERVER – Difference Between spid, kpid and ecid in sysprocesses
(Pinal Dave) Question: What is the difference between spid, kpid and ecid in sysprocesses?
REST API Sample for exporting a database
(Holger Linke) While working on an Azure SQL Database support case, I needed to provide a REST API sample for exporting a database. I struggled a bit to get it to work, as the syntax is not really intuitive and requires creating an Azure AD application.
Understanding Azure Data Factory – A Cloud Based Integration Service
(Anoop Kumar) Azure Data Factory is a cloud based integration service that allows you to transfer data from disparate cloud and on premise data sources to various data storage destinations. This is similar to another on premise ETL tool, SQL Server Integration Service (SSIS), provided by Microsoft.
MS SQL 2016 Management Studio Silent Install
(Jack Vamvas) As part of SQL Server 2016 installation SQL Server Management Studio (SSMS) is no longer available by default. It is necessary to manage SSMS as part of a separate installation.