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

Changing the Paradigm of Work

I saw an article on AI usage that is based on an upcoming book that suggests redesigning the world around new tech, not adding it to existing things. The first example is how electricity was introduced to existing factories, but it only provided some incremental gains until new factories were redesigned around electric motors. There's also an example given about reworking hotels to remove the front desk since that feature isn't needed. Instead, people could walk in, and an employee with a tablet could find them to check them in.

I'm all for rethinking and redesigning processes. I do think we have a huge glut of software in many organizations that exists because processes have evolved across time, but not everything and we keep our old software. When we have a new need or want a new capability, we add new software (or add features), but we don't necessarily throw out all the old software, processes, or habits. That wouldn't be practical, often because when we implement something new, it might not meet all our needs. Or at least we don't know it meets our needs at first.

I don't love the examples, especially as I see organizations where Teams/Slack are heavily in use (not just in tech companies), and these tools have changed how people work. Not everyone has moved, and there is a lot of document sharing and legacy systems, but that's also because not everyone wants to or can change at the same pace. However, lots of people have changed how they create, share, collaborate, communicate, and more because of these tools.

I also think the hotel example is silly (read the article to see more). I don't need a desk, and often I check in and get my key without ever visiting a desk. However, I do like the desk because when I need something, I want to be able to find someone, not wander around looking for an employee or waiting for them to respond to some page. When there's a desk I can see someone is there. I certainly don't want a kiosk with an AI there to queue at to request a person help me.

GenAI LLMs are going to change work for a lot of people, especially those in tech. I don't know that we can redesign the way we work now, as the technology is still advancing, and I'm not sure how we will want to integrate agents with GenAI to do work. We have to experiment and find ways to use this tech before we build too much. We also have to see it mature.

When we do, I bet many more people will start to use AI to generate code, change settings, deploy things, and more. I'm also sure that they will make many mistakes, at scale, and we'll be using a GenAI agent to undo things, or perhaps we'll have humans scrambling to fix systems. I wouldn't be surprised to see the humans commonly fixing things as we might not trust the AI Agent (or our prompting) to fix our mistake.

If you could redesign work, what would you want out of an AI? Assume that it is at least as competent as someone you work with. Is there a way that a GenAI system would make your work smoother?

Steve Jones - SSC Editor

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

 
  Featured Contents
Stairway to Transaction Log Management

Stairway to Transaction Log Management in SQL Server, Level 3: Transaction Logs, Backup and Recovery

Tony Davis from SQLServerCentral.com

This article discusses the different types of backup and recovery models and gives the essential facts that will guide you to being able to achieve a recovery of a database to a point in time.

Technical Article

How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?

Additional Articles from SearchSQLServer

With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal to write SQL more efficiently. One of those features is macros, which we’ll introduce in this article

Blog Post

From the SQL Server Central Blogs - SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries

Tracy McKibben from RealSQLGuy - Helping You To Become A SQL Hero

If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't just handy—it's crucial. Whether you’re making different data types play nice together or boosting query...

Blog Post

From the SQL Server Central Blogs - Deciphering Data Architectures: When to Use a Warehouse, Fabric, Lakehouse, or Mesh

James Serra from James Serra's Blog

As discussed in my blog and book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” (Amazon), organizations are often challenged with...

Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Site Owners from SQLServerCentral

Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations.

 

  Question of the Day

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

 

Removing a File

I attempted to use ALTER DATABASE to remove a file from my filegroup in SQL Server 2022. There are 4 files in this filegroup, but I don't need them all. However, I received a message that the file was not empty. How do I empty this file so it can be removed?

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

 

 

  Yesterday's Question of the Day (by Tobias Kiehl [KS.CEUS])

CONCAT_WS

What output do the queries produce?

SET CONCAT_NULL_YIELDS_NULL ON; SELECT CONCAT_WS ('-', NULL, NULL); SET CONCAT_NULL_YIELDS_NULL OFF; SELECT CONCAT_WS ('-', NULL, NULL); 

Answer: '' and ''

Explanation: The SET CONCAT_NULL_YIELDS_NULL setting does not actually affect how the CONCAT_WS command behaves in concatenations, because CONCAT_WS ignores the SET CONCAT_NULL_YIELDS_NULL { ON | OFF } setting. When all arguments provided to CONCAT_WS are NULL, it returns an empty string with the data type varchar(1). Ref:

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 2016 - Development and T-SQL
Question on SQL Query with NOT condition - I have a record, in those the three columns where firstname / last name and full name is empty. ID = 198765 FirstName = empty LastName = empty FullName = empty Flag = 0 I am trying to pull the record with ID 198765 out from select query where first and last or full name […]
SQL Server 2019 - Administration
Deadlocks and Backups - Need help - Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL for years, but as someone pulling and manipulating data, but not much in the realm of administration or in this case troubleshooting deadlocks. I've tried to get my higher ups to get a db expert but it seems this task has […]
Building Flame Diagram for MSSQL stored procedures - I wanted to share with you tools from my personal toolbox. If your code has many nested executions of stored procedures, you can benefit from building popular "flame diagram" of the execution time which is de facto standard for performance profiling. Here is step-by-step guide. Creation of a trace Start SQL profiler and select the […]
SQL Server 2019 - Development
Find Duplicate Rows - What’s the best way to find duplicate rows in a sql query? I heard there is a way where RC is used and it gives RC 1 for the first row and RC 2 for the duplicate row. But would like to know the syntax for it. I tried: select itemnumber , count (itemnumber ) […]
Is there an ISERROR equivalent in SS? - Hi everyone I have a SP that just failed.  Format of SP is: Select symbol, date, calc1, calc2 from sub-query It is due to bad data so I need to update the SP so it handles the scenario better.  I am proposing the following logic: CASE WHEN "calc1 has error" THEN NULL ELSE calc1 END […]
isnull, coalesce overhead - hi, one of our sister division's erp extract view is going thru at least one mod to do the equivalent of a coalesce on a column that if null brings down our dw load job. since they were doing that i asked if they could do the same on all columns that had never be […]
is there an elegant way for agent notification to show failure if any step fails - hi our corp dw load sqlagent job goes to the next step on the 14+ erp loads if they fail.  but quits notifying of failure on any cube step at the end.  most of the loads are ssis but there is some t-sql too. without making the job really ugly, is there an elegant  way […]
Merge spans with Dates Logic - --for a given member if the startdate and endate is continous we need to keep in single record and if start date and end date is not continous i need to keep in separate record for a given member.   drop table #test create table #test (ID int, startdate datetime, enddate datetime ) insert into […]
Analysis Services
Connect tabular model to excel via Power BI semantic model - I have a tabular cube, with myself included in one of the roles. I can connect to this tabular model via Excel successfully, and would now like to connect to a Power BI semantic model rather instead. However I get the attached error. I suspect there additional security needed to be defined, but unsure where. […]
Administration
Article for posting - Hello I sent you an article for posting: "Building the future with a react development company: an in-depth guide" Please reply to this email [email protected] regarding this article
SQL Server 2022 - Administration
Isolation Level in Azure SQL Database - Hello, Can you please clarify the following: In Azure SQL DB both ALLOW_SNAPSHOT_ISOLATION/READ_COMMITTED_SNAPSHOT are set to ON: ALTER DATABASE MyDatabase  SET ALLOW_SNAPSHOT_ISOLATION ON  ALTER DATABASE MyDatabase SET READ_COMMITTED_SNAPSHOT ON Is it sufficient to implement RCSI or I still need to add either to connection string or right to the top of the query: SET TRANSACTION  ISOLATION LEVEL  […]
SQL 2022 upgrade issues - We're about to upgrade our SQL 2017 Standard to 2022 standard.  We have 1 customer who takes a backup and restores it to their 2019 instance (so they can run Power BI reports).  We cannot postpone it, and they have asked if we could consider a BACPAC from our new 2022 to their 2019 version.  […]
SQL Server 2022 - Development
Remove ISNULL FROM left join to make SARGAble - Hi, I'm trying to make the below query SARGable by removing the ISNULL function part of the join. (Part of join in italic) Any suggestions? SELECT ..... FROM dbo.historicsummary hs LEFT JOIN dbo.Status fs ON hs.ID = fs.ID AND hs.TimeStamp >= fs.ValidFrom AND hs.TimeStamp < ISNULL(fs.ValidTo, DATEADD(d, 1, SYSDATETIME()))
New lightweight pure‑T‑SQL unit‑testing framework (T‑TEST) — feedback welcome -   Hi all, I’ve just open‑sourced T‑TEST, a tiny alternative to tSQLt that lives 100 % in T‑SQL—no CLR, no extra binaries. Why you might care one install.sql, < 10 KB of objects every proc in the tests schema is a test (auto‑discover by name convention) inline assertion functions (not SPs!) (test.assert_equals, test.fail, …) one-row recordset assertion (using […]
CAST(VARCHAR(n)) resolved performance issue? - Hi, I would love to hear if anyone can tell me why a CAST in a query can "resolve" this performance issue. Same symptom on test server with a copy of the database. weblab_reportlog = 207 850 195 rows Requisitions = 30 143 466 rows DBCC FREEPROCCACHE SELECT [LID], [Datestamp], [logmessage], [Reporttype], [UserID] FROM [dbo].[weblab_reportlog] […]
 

 

RSS FeedTwitter

This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. 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.
[email protected]

 

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