Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

Show an active interest by asking questions about others when talking with them.

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

The Cloud as a Foundation

The cloud for computing is a fascinating structure. I know there are plenty of jokes about the cloud just being someone else's computer, and there are good reasons not to use the cloud. However, there are also lots of good reasons to use the cloud. Whether you choose to embrace it or avoid it, cloud computing is going to be a part of our careers for a long time. The use is growing, and more and more companies are shifting workloads to cloud services.

How that will evolve, especially for data-intensive systems, will be fascinating. One of the interesting changes that seems to be taking places is the growth of database and data stores that fulfill specialized roles for customers. Snowflake might be one of the most well-known, but there are plenty more. The number of offerings is growing, and perhaps this is another evolution of how the cloud will integrate into more businesses.

To date, most of the large cloud providers (Azure, AWS, GCP) are offering a full stack of different systems that you use to deploy code and run applications. These cobbled-together services and platforms often lock customers into a particular cloud, though that isn't what many organizations would like. Especially in some regulated industries that mandate multiple clouds be used for redundancy. This article talks about the cloud as a foundation on which other customers can build services or platforms, especially data platforms.

This is something I would like to see. Snowflake is something that a company can run on AWS, Amazon, or GCP.  CockroachDB is another that allows customers to work with the platform on the provider of their choice. I like the idea of a wider set of platforms built upon cloud providers, but in a way that allows customers to move if need be, and also pressures cloud providers to keep pricing in line with each other.

In my mind, the more we find innovative companies building cloud-native data stores and other products, the more pressure on existing companies to improve their offerings. Competition is good, and it brings us new tools, while also forcing existing companies to update their offerings. It's not perfect, as sometimes we get new features without quality improvements in the base product, but without competition, we might not get that anyway.

I am fascinated and pleased by the cloud. The more I learn and work with it, the more I appreciate this as a truly new way of approaching the building and operating of software.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 1: Intro to Advanced T-SQL Using a CROSS JOIN

Greg Larsen from SQLServerCentral.com

The first installment of this new stairway series will be discuss the CROSS JOIN operator. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.

External Article

Transformations by the Oracle Optimizer

Additional Articles from SimpleTalk

To troubleshoot poorly performing SQL in Oracle, you must understand which transformations the optimizer has made. Jonathan Lewis demonstrates several possible optimizations for one query.

External Article

Share your insights and help shape the Summit 2022 program

Additional Articles from Redgate

We want to hear from you! Tell us what's important to you by sharing your insights and preferences for PASS Data Community Summit 2022. Community feedback is at the heart of everything we do for Summit and your insights will help guide our planning for this year's conference, taking place online and in-person in Seattle, November 15 - 18, 2022.

Blog Post

From the SQL Server Central Blogs - Batch, Streaming, and Relational Data

Steve Jones - SSC Editor from The Voice of the DBA

This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...

Blog Post

From the SQL Server Central Blogs - SSAS getting message: “Unable to convert one or multiple M partitions into native source queries.”

Joyful Craftsmen from Joyful Craftsmen Blog

The Issue Recently one of our team members faced the following issue: We have SSAS Tabular model deployed in DirectQuery mode taking data from MSSQL server database. Suddenly SSAS...

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Removing Deleted Pages

I delete a lot of rows from a large table. This appears to happen quickly, but I find the space is not able to be re-used right away. What background process in SQL Server actually removes the records?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Azure SQL Database Purchasing Models

What purchasing models are available for Azure SQL Database (as of Jan 2022)?

Answer: vCore and DTU

Explanation: The purchasing models are vCore and DTU. In the vCore model, there are different tiers, such as business critical or hyperscale. Ref: Azure SQL Database Cost Management - https://docs.microsoft.com/en-us/azure/azure-sql/database/cost-management#prerequisites

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2017 - Development
Saving changes is not permitted - I would like to create a data model a excel . I have no problem moving the data from source to target and also apply appropriate data types. I am having this problem as seen below. Even when i just import the table and leave data types as is, i am getting this problem. Also,  […]
SQL Server 2016 - Development and T-SQL
Comparing nvarchar with string has started generating weird conversion error - Hi, We are running SQLSERVER 2016. We have a process that has been running fine for years that this month has run into an issue. There is a simple select statement that links 3 tables. SELECT count(*) FROM TABLE_A A INNER JOIN TABLE_B A ON A.X = B.X INNER JOIN TABLE_C ON B.Y = C.Y […]
SQL Server 2012 - T-SQL
Is there any better optimised way for insert in multiple tables using JSON - Hello Everyone, I just started a developing a new application for hospitals (for maintaining hospital staff, patient, appointments etc.). I started with the database part first. I will use APIs as back-end. So I just thought why not I should take all data in one go in JSON and try to insert it. So here […]
SQL Server 2019 - Administration
Connection to the different domain from SSMS - Hi , I installed SSMS in my local machine. In the company they do create admin account to connect to the sql server instances. My local windows login (normal windows account) is different from admin account. How to connect to SQL server from your local installed ssms. Thanks, Ramana
AlwaysON Availability Group Wizrd Replica empty - Anyone seen this when setting up an AlwaysON. Going thru the Wizard and the replicas are missing. I've done this multiple times but somehow this seems to be an issue now. 2012, 2014, 2016 don't seem to have a problem. This is on 2019 only. Cluster is good. The screenshot from this is from a […]
SQL Server 2019 - Development
Refactoring an Entity Attribute Value schema - Apologies in advance, as I know this has been discussed a million times already but I think our requirement is slightly different from the norm in that we have a well-defined, static set of attributes up front and our values are rows in a table. But feel free to ignore if you've had enough of […]
SSIS package to select a button on a windows app - Hi everyone I am creating an SSIS package where I run an windows program to download data.  The data provider doesn't allow people to make direct connections to their DB so the only way to get the data is from their windows app.  I am writing a script that accesses that program and downloads the […]
Does a while loop read all the records in a table? - I hope this isn't too long, but I wanted you to understand why I am doing what I am doing/ I have a group of oil tanks numbered 1 through 30 that are linked to a master tank via hoses. When 10 tanks fill up, their valves open and send the oil to the master […]
SQL Azure - Development
Receive email from Azure - Is there a way to receive email from Azure, I would like to catch and receive failed error via powershell runbook.  for example process SSAS model.
General Cloud Computing Questions
Career advancement in cloud - I am a SQL server administrator with 5 years of pure DBA experience. I am planning to get trained into cloud like Azure or AWS or any other cloud technology where there is a future growth. Can someone guide me which patch to take, is it Azure or AWS. Since i am an administrator i […]
Azure Data Factory
Copy empty folders in ADF - I am using ADF to copy folders from On-premise to Azure Blob storage. All the folders are getting copied except the ones which don't have any files, but customer requirement is to copy the empty folders as well . Microsoft documentation says that if we select 'recursive' option in Copy activity , empty folders are […]
Powershell
Store invoke-sqlcmd result in PowerShell variable and use it for comparison - Hello, I was trying to store invoke-sqlcmd result in a PowerShell variable but it seems that I am doing something wrong because $dbsize variable in the below code does not store the value from the invoke-sqlcmd. I would appreciate if I can get some help with it. param ( [string]$ServerName, [string[]]$databaseName ) $date = Get-Date […]
Integration Services
Upgraded DLL reference - I have an SSIS package which uses dotConnect for MySQL - currently using the 130 DLL. We're migrating our packages to SQL2019 and that requires the 150 DLL. However I cannot find (remember?) a way to change the reference to the DLL in my package. Can anyone advise? I tried changing it manually in the […]
Accessing variables dynamically - I have an SSIS package which updates a number of tables and sets a variable upon success. I'd need to review these variables and set an error message accordingly. I'd like to avoid having to change the Script Task every time I add a new table, so is there a way to step through the […]
Design Ideas and Questions
Conceptual design and When to define schemas - we are in the conceptual phase of our project.  UI design just finished and front and backend development is just starting. We are defining entities and attributes.  And trying to get more specifications from the design and development groups so that we can most accurately define all the entities.   I was thinking to propose […]
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -