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

What is the Cloud?

Last week we had a training session at Redgate Software on the Cloud. One of the first slides from John Q Martin asked the question, "what is the cloud?" The next slide had the answer: it's just someone else's computer.

I mean that's true, but it's not Grant's computer. He's got a creaky, 4 year old HP that I don't want running my workload.

The cloud is many things, it's hard to define, it does so much, and at the same time, can do so little for you. Except cost a lot. We certainly find no shortage of people spending a lot of money in the cloud and not necessarily happy about it.

John was trying to educate others on the IaaS v PaaS, the challenges of cloud migration, giving them a perspective on what the cloud changes, and how customers think about the cloud. Apart from the basic details of what the cloud entails, he said an interesting thing (I'm paraphrasing here): the cloud does things that 95% of organizations couldn't do themselves.

It's not just someone else's computer. It's a whole bunch of computers someone else owns and has put a lot of security, infrastructure, planning, tooling, and more to enable you to flexibly create systems at a pace you would struggle to match inside your organization.

For most people.

The cloud is amazing. It's is someone else's (large rack of) computers that you can rent. They will charge you for the flexibility, and they're not doing all your work for you, but they give you the ability to configure things the way you want them. Or you can ask one of your buddies, Claude or Copilot, to set up the configuration for you.

The cloud is a set of Lego bricks, some pre-built Lego models, a surface on which to place them, and a few rules to keep you from going too crazy, but you still have to do some work.

The cloud is a great enabler for many things. Not all, and not always for those things, but it's up to you to find where it works, where it doesn't, and where it's worth the money.

That's the cloud.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Index Fragmentation Explained: Page Splits, Logical Reads, and What to Do

Sanket Parmar from SQLServerCentral

Index fragmentation can silently degrade your query performance over time. Learn what happens at the page level, how to measure it, and how to fix it.

External Article

How to Deploy SQL Server on Kubernetes running on Windows

Additional Articles from MSSQLTips.com

Learn how to deploy SQL Server on Kubernetes using Docker Desktop on Windows. Unlock powerful capabilities for your database.

Blog Post

From the SQL Server Central Blogs - AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared

epivaral from SQL Guatemala

Both SQL Server and PostgreSQL are moving fast into AI territory — and if you manage either (or both), you've probably wondered how they compare when it comes to...

Blog Post

From the SQL Server Central Blogs - Monday Monitor Tips: AI Alert Analysis

Steve Jones - SSC Editor from The Voice of the DBA

We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check out this new feature we’ve added for alerts. This is a great addition to help...

Pro Encryption in SQL Server 2022

Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data

Additional Articles from SQLServerCentral

This in-depth look at the encryption tools available in SQL Server shows you how to protect data by encrypting it at rest with Transparent Data Encryption (TDE) and in transit with Transport Level Security (TLS). You will know how to add the highest levels of protection for sensitive data using Always Encrypted to encrypt data also in memory and be protected even from users with the highest levels of access to the database. The book demonstrates actions you can take today to start protecting your data without changing any code in your applications, and the steps you can subsequently take to modify your applications to support implementing a gold standard in data protection.

 

 Question of the Day

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

 

Changing the Schema

I set up a few users on my SQL Server 2022 instance. 
CREATE LOGIN User1 WITH PASSWORD = 'Demo12#1'
CREATE USER User1 FOR LOGIN User1
GO
CREATE LOGIN User2 WITH PASSWORD = 'Demo12#2'
CREATE USER User2 FOR LOGIN User2
GO
CREATE LOGIN User3 WITH PASSWORD = 'Demo12#3'
CREATE USER User3 FOR LOGIN User3
GO
I then created a schema that one of them owned. Under this schema, I added a table with some data. 
CREATE SCHEMA MySchema AUTHORIZATION User1
GO
CREATE TABLE Myschema.MyTable(myid INT)
GO
INSERT MySchema.MyTable
(
    myid
)
VALUES
(1), (2), (3)
GO
SELECT * FROM MySchema.MyTable
GO
I granted rights and verified that User2 could access this table. 
GRANT SELECT ON Myschema.MyTable TO User2
GO
SETUSER 'USER2'
GO
SELECT * FROM MySchema.MyTable
GO
This worked. Now, I move this schema to a new user. 
ALTER AUTHORIZATION ON SCHEMA::Myschema TO User3;
GO
What happens with this code? 
SETUSER 'USER2'
GO
SELECT * FROM MySchema.MyTable
GO

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)

BCP on Linux

When running bcp on Linux, what is the field terminator?

Answer: \t

Explanation: The field terminator is \t or a tab. Ref: Use bcp on Linux - https://learn.microsoft.com/en-us/sql/tools/bcp/bcp-utility?view=sql-server-ver17#use-bcp-on-linux-and-macos

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 2019 - Development
identity increments by 10,000 when it was supposed to be 1 - hi a peer of mine who ive never known to be wrong says a new table he created with pk identity(1,1) jumped by 10000 on one insert.   has anyone ever seen this anomaly?
Editorials
Follow Your Hunch - Comments posted to this topic are about the item Follow Your Hunch
The Slow Growing Problems - Comments posted to this topic are about the item The Slow Growing Problems
Liability for AI Errors - Comments posted to this topic are about the item Liability for AI Errors
Article Discussions by Author
What Happens When You Ask a Local AI to Query Your Database? - Comments posted to this topic are about the item What Happens When You Ask a Local AI to Query Your Database?
Detecting Characters - Comments posted to this topic are about the item Detecting Characters
Displaying Money - Comments posted to this topic are about the item Displaying Money
Calculating the Harmonic Mean in Power BI - Comments posted to this topic are about the item Calculating the Harmonic Mean in Power BI
Pro SQL Server Internals - Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry - Comments posted to this topic are about the item SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Running SQLCMD II - Comments posted to this topic are about the item Running SQLCMD II
SQL Server 2022 - Administration
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica - Hello , I would like to run a stored procedure on a secondary replica in an AlwaysOn Availability Group to offload read-only workload from the primary. However, this procedure currently suffers from parameter sniffing, and we sometimes need to recompile it to restore acceptable performance. I would like to know: What are the risks of […]
Backup Availability Group - Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022 Availability Group with 4 replica I am trying to make sure I am using the best method of backing up my databases. I cannot use the Ole Hollengren jobs because of my environment Currently I have all four nodes set up […]
SQL Server 2022 - Development
Alamat BCA KCU Mojokerto ??/Wa (0817)839777 - Kontak Cs: 0817839777 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto, Jawa Timur 61313
Increment a number in a SQL Query based on a value - I have an issue where I have a Bill of Material list of items where some of the item numbers are blank. I need to give them sequential numbers from a beginning number like 9000000. then the next blank would be 9000001 and so on. I thought I could create a table and store the […]
 

 

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

 

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