There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in elastic pool is essentially just Azure SQL Databases grouped into an…Read More >
Over the past month, I organized #DataSessions for the Singapore SQLPASS group. Singapore SQLPASS is the data platform user group community in Singapore. In June, we held free live webinars every Tuesday and live-streamed it on Facebook and YouTube. I…Read More >
Let’s revisit our options when moving your SQL Server workloads to Azure and check out ways to migrate on each of them. Let’s break them down into sections in case you want to jump to specific ones. Deployment Options SQL…Read More >
Your mission: Gather a list of servers in a specific collection on System Center Configuration Manager (SCCM) so you or your client can verify the servers in the collection. How will you do it? First, a disclaimer. I’m a data…Read More >
During this COVID-19 time, business is no longer as usual. Recently I have had a few contacts asking me for tips on how to work remotely. Why? Well, I have been working from home for ten years now. Working remotely, …Read More >
I wrote a blog post on this subject last year when Azure SQL Database Serverless was first introduced. This year I was excited to present it for Microsoft Ignite: The Tour Singapore before it was canceled because of the growing…Read More >
Problem: You are trying to add a new subscriber to a SQL Server Publication using the SQL Server Management Studio and you receive an error similar to the one below: “The selected Subscriber does not satisfy the minimum version compatibility…Read More >
Last May, the Microsoft Build 2019 conference took place in Seattle. A number of new features and capabilities were announced and demonstrated. This week, communities in the Asia Pacific held their own version of Build, bringing the best and the…Read More >
Problem: You created a linked server on SQL Server to a PostgreSQL database. You can open and navigate the linked server on SSMS up to listing the tables, but can not perform select to certain tables, returning the below errors:…Read More >
Problem: You are trying to take a native SQL Backup to URL and you receive the error below: Msg 3271, Level 16, State 1, Line 1 A nonrecoverable I/O error occurred on file “https://MyStorageAccount.file.core.windows.net/MyContainer/Adventureworks_full_20190420.bak:” Backup to URL received an exception…Read More >
© Copyright 2020 Pythian Group Inc. ® ALL RIGHTS RESERVED.
PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.