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

The Invisible Disk

I saw a post recently about the incredible shrinking computer, where a software consultant had written down his predictions for the future. In this case, he writes about a computer shrinking smaller than today, essentially to one chip, with docking stations wherever you need them. We're already at the place where many of us have an extremely powerful computer in our pockets in the form of a mobile phone. I'm still amazed that I bought a phone recently with half a terabyte of storage.

A few years ago I gave a keynote where I looked at the changes in disk storage, starting with an IBM hard drive being loaded onto a plane. The capacity was 5MB. I remember working with KB floppy disks and MB hard drives, and lots of different connection technologies: IDE, ESDI, SCSI, and more. I've seen disks shrink from a 5 1/4" form factor to mere wafers with today's NVMe drives.

However, what might be even more interesting is that I don't even think about drives anymore as being a physical thing. Certainly, my mobile, my laptop, and my desktop have physical drives, but they're all connected together, essentially giving me invisible disks. I can take a picture on my phone and it shows up on my laptop or desktop in seconds. The disk might as well be invisible.

As I left full-time Operations work, we were  starting to see this in our servers, which were essentially invisible VMs stored in some location, on storage that we never laid eyes on. We never saw disks fail because the storage arrays had redundant disks. There were people replacing failed drives every week to ensure that service wasn't interrupted.

These days we rent storage in the cloud without ever working with the hardware. Most of us who specify the configuration in the cloud don't think about disks. We think about the total capacity and the IOPs that we need for our system. We care about the results, not the hardware.

Most of us. Some of us care and worry about it, but a lot of the people I know in data work, even as operational DBAs, don't worry about hardware. They need a high level of service and low latency to ensure clients can retrieve data. Even when requesting more hardware, most of us are asking for more capacity or throughput, not specific models of hardware.

I find myself rarely caring about disks anymore, though recently I was glad I had a flash drive in my bag. I needed to transfer a file to some air-gapped computers, and a quick copy on an old 2019 PASS Summit recording flash drive worked well. That drive was certainly visible, and full of memories.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

GitHub Desktop Tutorial

Daniel Calbimonte from SQLServerCentral

Learn the basics of using Git and Github with the desktop application.

External Article

Effective Strategies for Storing and Parsing JSON in SQL Server

Additional Articles from SimpleTalk

Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because of its heavy usage in applications today, it inevitably will make its way into databases where it will need to be stored, compressed, modified, searched, and retrieved.

Blog Post

From the SQL Server Central Blogs - What Are the Most Common Blockers to Adopting SQL Server Extended Events?

Grant Fritchey from The Scary DBA

Yeah, stupid long title. It’s a question I put to several different AI engines. I’m curious what the aggregated knowledge of the internet has to say on the topic...

Blog Post

From the SQL Server Central Blogs - T-SQL Tuesday 177 roundup: Managing database code

Diligentdba 46159 from Mala's Data Blog

I was privileged to host yet another T-SQL Tuesday, for the month of August, 2024. My topic was on Managing database code. I was worried about getting responses, given...

The Unicorn Project

Site Owners from SQLServerCentral

In The Unicorn Project, we follow Maxine, a senior lead developer and architect, as she is exiled to the Phoenix Project, to the horror of her friends and colleagues, as punishment for contributing to a payroll outage. She tries to survive in what feels like a heartless and uncaring bureaucracy and to work within a system where no one can get anything done without endless committees, paperwork, and approvals.

 

 Question of the Day

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

 

Adding Features During a SQL Server 2022 Upgrade

I have a SQL Server 2016 SP3 instance that I want to upgrade to SQL Server 2022. I don't have replication installed, but I want to enable this on SQL Server 2022. Can I add replication during the in-place upgrade?

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)

Am I on Synapse?

How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?

Answer: Use Serverproperty() with the Edition property

Explanation: @@version returns the same information as Azure SQL Database. While your hostname might help, this could be aliased in some way. ServerProperty with the EngineEdition. Ref: Serverproperty - https://learn.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql?view=sql-server-ver16

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 - Administration
Does a Query Lock to the Table_Name or Table_ID - SQL 2017 ENT SCENARIO: Table_1 has a Sch-M lock on during an intended updating process. A QUERY is executed against Table_1 and is queued up, waiting for the Sch-M lock to release. While the QUERY is queued up on Table_1, Table_1 is renamed to Table_1_OLD A newly designed Table_2 is then renamed to Table_1 QUESTION: […]
SQL Server 2017 - Development
update field on a select query - I have a sql query that runs on demand to generate a report. I want to update a field REPORTSENT to a Y on the selected results. So the next time the report is requested only the Records with a REPORTSENT = N will be returned. Normally would run the query for the records and […]
SQL Server 2019 - Administration
Cluster Timeout Settings to handle transient network outages - I have an Availability group with 2 replicas on the same subnet.  We've been experiencing short network outages that last a few seconds and cause connections to timeout.  This causes the AG to fail completely (not failover automatically) and we have to manually bring it back online since the DBs are marked "not synchronizing" on […]
Question about SQL Certs and DNS aliases - About 15 years ago we started creating DNS aliases for each database. This allowed us to move databases without needing to change client connections. We now use these aliases in all applications, reporting, ETLs, etc... When we upgrade SQL we create new servers and migrate the databases, using the aliases made this simple. We also […]
SQL Server 2019 - Development
SSIS Package runs on one server but getting an assembly component error on anoth - I posted this over on Stack Overflow and got bupkis and was hoping someone over here would be able to help me. I have an SSIS package that has been tested, and ran in Visual Studio 2019. It was originally created, tested, and ran in VS 2017 but when I started having the issue I […]
ssis dashboard suddenly missing from reports option under catalog/ssisdb - hi i rt clicked ssisdb today under integration services catalog , chose reports and didnt see the dashboard option under my regular id.  my id has sa.  so i connected with my admin which also has sa and did see it. losing permissions would have occurred in the last 24 hrs.  i saw in one […]
SQL Azure - Development
Hybrid Cloud Server Integration with SQLServerCentral’s SQL Server 2022 - Hello everyone, I’m currently exploring the use of hybrid cloud servers and am focusing on integrating them with SQLServerCentral’s SQL Server 2022. While hybrid cloud environments offer flexibility, managing and optimizing them with SQL Server 2022 presents several challenges. Here are some specific areas where I’m seeking advice: Integration Best Practices: What are the best […]
SQL Azure - Administration
SQL Server 2022 on Azure VM - I was provisioned  this DB on an Azure VM. I needed to uninstall and reinstall it in order to set the proper collation. I dont know how it was originally setup or if it  goes by another namelike "Managed SQL Instance" as another department handles setting these up. When they learned of my uninstall/reinstall they […]
General
Performance of Derived table in large data(12 crores and more) - Using Derived Table in query on large data (12 crores and more) results in CPU utilization greater than 90% resulting in performance degradation. Why Using Derived Table in query utilizes high CPU when it is created in memory
Powershell
dump to csv -- image column - If there is an Image Column in mssql table and I wanted to use export-csv to dump this info to file how do you handle that column to be able to import that csv to another DB. Thanks.
SQLServerCentral.com Website Issues
Future Post - This post is from the future! How did that happen? https://www.sqlservercentral.com/forums/topic/git-configuration-and-automated-release-for-azure-data-factory#post-4451220
SQL Server 2022 - Administration
How to connect to Developer Server Edition - Hi, I am attempting to connect to a local instance of sql developer installed today. When attempting to connect to the Server Name: EHL5CD4254Q4G with Windows Authentication ( its a domain joined laptop btw), I get an error: TITLE: Connect to Server ------------------------------ Cannot connect to EHL5CD4254Q4G. ------------------------------ ADDITIONAL INFORMATION: Login failed for user 'mydomain\myaccount'. […]
SQL Server 2022 - Development
Text column is taking More time while Querying, Need to Replace DATALENGTH - select * from dbo.resolutions r where R.documentid = 828222222 and DATALENGTH(r.resolution_text) > 0 resolution_text Text column is taking More time while Querying, Need to Replace DATALENGTH, when  i replace datalength condition as  "r.resolution_text is not null" the above query is returning data
SSIS package project connections don't work on upgrade - We're upgrading from SQL Server 2016 to 2022.  The SSIS package project level connections don't work as expected.  One queries the server as an anonymous logon instead of the domain account associated with the SQL Server Agent.  One even affects both the original server and the new one to which it is pointed.  I have […]
2022 azure vm cant run same ssis pkg we run on prem - Hi, we set up an environment on our new azure 2022 vm with a cloned  "prod target warehouse", ssis project clone from prod, cloned sql agent etc etc.  amongst other things the ssis points at a new erp's sales data we are testing with in just one agent step/ssis project execution for that 2019 std […]
 

 

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

 

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