Category: Microsoft SQL Server

Feed: James Serra's Blog. Author: James Serra. A brand new product by Microsoft called Azure Data Share was recently announced. It is in public preview. To explain the product in short, any data which resides in Azure storage can be securely shared between a data provider and a data consumer. It does this by copying a snapshot of the data to the consumer’s subscription (called snapshot-based copying, and in the future there will be in-place sharing). It currently supports ADLS Gen1, ADLS Gen2, and Blob storage, and eventually will support Azure Data Explorer, SQL DB, and SQL DW. Check out ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . In the article Introduction to Running SQL Server 2019 on Kubernetes recently published on this forum, the core concepts and basic architecture of implementation of SQL Server 2019 Always On Availability Groups on a Kubernetes cluster are described. In this article, an implementation will be stepped through by leveraging Microsoft Azure-hosted managed Kubernetes service referred to as AKS. AKS considerably simplifies provisioning of Kubernetes clusters by automatically building all underlying infrastructure components, including compute, storage, and networking, as well as a set of highly available master nodes. It also automatically delivers monitoring ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Suppose you are a new DBA in an environment. You are tasked with restoring a database, but you don’t have a single clue as to what is in any of the database backup files. Maybe the backup file names might give you a clue, and then again maybe not. Possibly the names are so cryptic that they are meaningless as to the content of the backup.   The Microsoft SQL Server team has made it easy for you to retrieve the information in a backup file by using one of the following two ... Read More

Feed: James Serra's Blog. Author: James Serra. Below are the top 12 questions I am seeing from customers looking to migrate on-prem SQL Server to Azure, and the blogs that I have wrote that try to answer each question (I have updated most of these blogs): How does PaaS database high availability work? Azure SQL Database high availabilityHow does PaaS database disaster recovery work? Azure SQL Database disaster recoveryHow can I monitor a PaaS database? Monitoring Azure SQL Database, Azure SQL Database monitoringWhat is the difference between SQL Database and SQL Data Warehouse? Azure SQL Database vs SQL Data WarehouseHow do I handle multi-tenants in ... Read More

Feed: James Serra's Blog. Author: James Serra. Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that try to answer each question (I have updated most of these blogs): Do I need a data lake? Data lake detailsDo I need a relational data warehouse? Is the traditional data warehouse dead?Do I need a cube? The need for having both a DW and cubesWhere do I clean my data? Where should I clean my data?What is the Common Data Model (CDM)? Common ... Read More

Feed: Mr. Fox SQL. [read this post on Mr. Fox SQL blog] The “modern data platform” architecture is becoming more and more popular as organisations shift towards identifying, collecting and centralising their data assets and driving towards embracing a “data driven culture“. Microsoft Azure has a suite of best-of-breed PaaS based services which can be plugged together by organisations wishing to create large scale Data Lake / Data Warehouse type platforms to host their critical corporate data. When working with customers going down the Modern Data Platform path I often hear very similar questions; What is the most suitable and ... Read More

Feed: James Serra's Blog. Author: James Serra. A challenge I have with customers who want to get hands-on experience with the Azure products that are found in a modern data warehouse architecture is finding a workshop that covers many of those products. To the rescue is a workshop created by my Microsoft colleagues Fabio Braga and Rod Colledge, explained in their blog post Azure Data Platform End2End with the GitHub located here. This is an on-demand workshop with labs that you can run at any time. The idea of this workshop is to give experienced BI professionals (but new to ... Read More

Feed: James Serra's Blog. Author: James Serra. The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow. I find customers are confused on the use cases of these products and how they compare to other products (Azure Functions, Logic Apps, and Azure Data Factory). So I wanted to write a blog and describe at a high level what these products are, their primary use case, how they interact, and how they compare. Power BI – A self-service reporting tool that allows you to visually explore and analyze data to get better insights into your data so ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . In recent years, Microsoft has fully embraced the open source paradigm. One of the more prominent examples of this trend was providing the ability to host SQL Server 2017 instances on Linux, including running Docker-based SQL Server images (available directly from Microsoft Container Registry) on Kubernetes clusters. The release of SQL Server 2019 further extends the multi-platform capabilities by allowing for Kubernetes-based deployments of SQL Server Always On Availability Groups, delivering increased level of resiliency. In this article, the basic characteristics of these deployments are introduced. In order to better understand the ... Read More

Feed: Mr. Fox SQL. For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney… SQL Saturday 769 (Sat 30 Jun 2018) Melbourne.  SQL Saturday 771 (Sat 07 Jul 2017) Sydney.  For those looking for some great free local SQL / Azure / BI / etc learning, you simply cannot go past a SQL Saturday anywhere in the world!  And this one right here in Melbourne will again be no exception.  There is a lineup of fantastic local speakers including Microsoft and MVP’s as well as international speakers too. SQL Saturday Pre-Con Training (Fri 29 Jun 2018).  Melbourne.   Leading ... Read More