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

The Next Great Thing

At SQL Bits, I was chatting with Brent about a few things, including AI, which we think is changing the world. I've got my set of AI experiments going, and I do believe we will fundamentally alter work and how we use computers in the future.

Not sure if it's for the better or worse, but things are changing and will change more.

Brent mentioned he was thinking about how a few years ago the "next great thing" was blockchain, which was going to change databases and storage, but never really caught on. I never thought it would as it seemed too niche-y for me.

What other great waves of tech have you seen over the years? I saw a prediction that data engineering will be dead in 5 years. I'll take that bet. I've been hearing the DBA (or other data related positions) will be gone soon for over 25 years. I remember friends asking me if I was worried about my position after SQL Server v7 was released in 1998. I wasn't then, and I'm not now. It seems there is more work than ever, though certainly the bar is higher for people doing the work.

You need to learn to be better at your job if you want some job security. That's one reason I constantly push people to learn, improve, and show off ( consider #SQLNewBlogger posts) their skills. Employers want to know you're providing value if they're paying you $$ (or € or £ or ¥ or whatever).

There have been plenty of tech flops. Virtual/Extended/Augmented reality and various headsets haven't quite taken off, though there is no shortage of new "AI powered" eyeglass products. Quantum computing still seems to be only slightly less fantastic than fusion energy. Voice control or gestures were supposed to make keyboards obsolete, but we still type a lot.

There are also some amazing things. Touch computing, especially on mobile, dominates. More and more digital payments are changing our commerce functions. Smartphones are essential devices for most people with apps available for anything and everything.

I do think GenAI will continue to change the world and how many of us work. This was an interesting talk on how AI changes work, not from a technologist per se, but from a writer. The GenAI models continue to improve, and I find them most useful in saving me minutes, not doing all my work. They are becoming more helpful, though slightly untrustworthy assistants. They are eager teenagers that can help, but need supervision and guidance.

And sometimes need to be abandoned for the current task and you need to do the rest of (or all of) the work.

What memories do you have of past "next great things? or maybe of what you see for the future?

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Building a Database Dashboard with SSRS

Nisarg Upadhyay from SQLServerCentral

Learn how to create a dynamic database dashboard that tracks key metrics using SQL Server Reporting Services. From setting up to deploying your report.

External Article

Split strings by Regular Expressions in SQL Server 2025

Additional Articles from MSSQLTips.com

SQL Server users have been asking for native regular expression support for over two decades. There are third-party Common Language Runtime (CLR) modules that offer this functionality, but these can be complicated to install and simply aren’t possible in some environments. I want to split a string using a regular expression instead of a static string. Will that be possible in SQL Server 2025, without CLR?

From the SQL Server Central Blogs - Empowering Technical Teams: Leading with Vision, Not Micromanagement

Chris Yates from The SQL Professor

Let’s be honest; technical teams don’t thrive under a microscope. They thrive under a mission. In a world where innovation moves at the speed of thought, the difference between...

Blog Post

From the SQL Server Central Blogs - Resource: Security Auditing for Databases

K. Brian Kelley from Databases – Infrastructure – Security

If you are responsible for securing databases, SQL Servers and others, I would strongly urge you to read the following post by Andreas Wolter, former data security PM for...

SQL Cookbook: Query Solutions and Techniques for All SQL Users

Steve Jones - SSC Editor from SQLServerCentral

You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in several flavors of SQL, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL.

 

 Question of the Day

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

 

Enabling Change Tracking

If I want to set up Change Tracking in a database, what should I do first in SQL Server 2022?

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)

Getting the SQL

If I run this code, what is returned?

SELECT *
 FROM sys.fn_get_sql(0x0500FF7F149270E460F3E0ADD701000001000000000000000000000000000000000000000000000000000000) AS fgs

Answer: This returns the SQL executed for the handle passed in as a binary value

Explanation: This only returns the text of the SQL statement for the plan handle. Ref: sys.fn_get_sql - https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-get-sql-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 2019 - Development
Replace with like join - I am trying to create and Update query based on a like join.  Is that possible?  This is what I have: UPDATE claim SET incident_desc = CASE WHEN incident_desc like '%' + NAC.Glyph + '%' THEN REPLACE(claim.incident_desc, NAC.Glyph, NAC.Replacement) ELSE incident_desc END FROM claim INNER JOIN NonASCIICharacters  NAC ON claim.incident_desc LIKE '%' + NAC.Glyph + […]
built in deadlock information capture - Hi, i cannot recall the object or even if it comes off the shelf but i once saw a tool in sql server where the competing tables etc involved in a deadlock are recorded.   I think you had to know a bit about the complicated looking test it provided but it was sweet.   my recollection […]
why do my advanced i/o column lengths on city keep changing - hi , every time i go back to an ssis pkg that is under construction, at least one column in a tsv needs to be reset in the advanced properties of the oledb source from 50 bytes to 256.  Even though last time i edited it,  i saved the pkg. why is that happening?   Today […]
Anything that is NOT about SQL!
NKTg Law on Varying Inertia – A Different Way to Think About Motion - Hi everyone, I’d like to share something from the science side of life rather than the SQL side. It’s called the NKTg Law on Varying Inertia. In classical mechanics, Newton’s laws describe how objects move under the influence of forces. But the NKTg Law takes a different angle: instead of focusing only on forces, it […]
Editorials
Carrots and Sticks - Comments posted to this topic are about the item Carrots and Sticks
Storage Enhancements - Comments posted to this topic are about the item Storage Enhancements
Everyone Wants a Piece of the AI Pie - Comments posted to this topic are about the item Everyone Wants a Piece of the AI Pie
Article Discussions by Author
How to create your custom GPT SQL Expert - Comments posted to this topic are about the item How to create your custom GPT SQL Expert
MongoDB and NodeJS in action - Comments posted to this topic are about the item MongoDB and NodeJS in action
SQL Server 2022 - Administration
CDC job running for 17 days? - Good morning, I've noticed my CDC job running for 17 days.  I've noticed it before, but wasn't sure it was an issue.  I've checked sys.databases to check the log_reuse_wait_desc to see if it said "replication". It says nothing. The Database is 8 TB and the log file is 23 GB. I queried :  SELECT job_id, […]
Database growth events for unidentified databases - We have recently upgraded from SQL Server 2016 to 2022 Standard Edition. Our nightly reports have started showing regular growth events for the following database files (see attached). model_replicatedmaster (both the replicatedmaster and replicatedmasterlog files) model_msdb (both the MSDBData and MSDBLog files) Firstly, what databases are these? I'm familiar with model, master, msdb and tempdb […]
distributed availability group query - Not sure if this is my misunderstanding or an error in my process: Create AG1 on server 1 & 2.  (2019).  Add DB1.  Replica are joined, DB1 is synchronised. Create AG2 on server 3 & 4.  (2022). Add DB2.  Replica are joined, DB2 is synchronised. Remove DB2 from AG & drop on both. Create DAG […]
Can a Database be in an AG and do log shipping at the same time? - Hello, I have a large database about 8 GB.  It is in an AG. I have three replicas (Replica1, Replica2 and Replica3) Replica1 is Primary and healthy Replica2 is Secondary and heathy Replica3 is Secondary and not healthy.   I need get Replica3 healthy again.  My thought was to wait until after the normal backup […]
SQL CAL based Licensing - Hi Folks, I am about to purchase SQL server licences and need your advice on the Device CAL model. I understand we have to pay for the server license and then as per device count. SO if we have  2 application servers , with each routing 5 client connections, do I have to pay for […]
SQL Server 2022 - Development
azure vm has to be rebooted more often than we'd like - Hi we're noticing this 2022 server gets into a funk now and then.   Specifically, i notice when i script existing tables to the clipboard etc it just hangs with that circle continuing to spin.    i notice that if i reboot, the problem goes away for a while.  does the community have a similar experience?  […]
 

 

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

 

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