(Manoj) Azure Databricks is an Apache Spark-based analytics platform optimized for the Microsoft Azure cloud services platform (PaaS).
Tag: sql server
Why does my Azure Function sometimes stop being triggered
(benjaminperkins) Azure is so awesome because the features it provides are so very dynamic and flexible. The platform provides a starting point for the fruition of ideas, ideas only limited by ones imagination.
Automating a SQL Server Database Refresh
(Joe Gavin) You need to automate refreshing a SQL Server database to refresh test or dev, test backups, etc. In this tip we show how this can be done.
Using Process Monitor To Troubleshoot Power Query Performance Issues With File Data Sources
(Chris Webb) Troubleshooting Power Query performance issues in Power BI and Excel can be difficult because it’s a bit of a black box: there’s nothing in the UI to tell you what’s going on inside the Power Query engine and the diagnostic logs are very difficult to interpret.
SQL Server Spatial: STFlipVectors
(Simon Greener) In the past I have found use for the ability to “flip” vectors in a polygon in order to provide an independent check on the topological integrity of planar enforced polygons.
SQL SERVER – Event ID:7034 – MSSQLSERVER Service Terminated Unexpectedly. It has Done this 6 time(s)
(Pinal Dave) Recently, I came across a strange issue. I noticed that the SQL Server service terminates and restarts automatically and sometimes doesn’t restart and I must manually start it again. In this blog we would learn about Event ID:7034, MSSQLSERVER Service Terminated Unexpectedly.
SQL SERVER – Backup to URL – Script to Generate the Create Credential and Backup Command using Access Keys
(Pinal Dave) Backup to URL is one of the common methods used in SQL Server perform backup to Azure Blob Storage. In this blog, I am going to share a script to generate the create credential and backup command using access keys.
Steps to Migrate Oracle Database to Azure SQL Database
(Anoop Kumar) In the world of paradigm shifts, many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business for the future.
A quick tutorial on SQL Server maintenance plans
(Robert Sheldon) SQL Server maintenance plans get a bad rap, but for DBAs who need a simple way to maintain databases, Microsoft’s built-in tools are a good place to start.
SQL Server on Linux: How is Delete-On-Close Handled
(RDORR) Windows provides an option for CreateFile to delete a file when the file is closed (FILE_FLAG_DELETE_ON_CLOSE.)
