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

I Don't Want To Do XX

Every job is a job on some days.

I've said this to my kids and others I've mentored over the years. I've probably written that here, and I truly believe it. When you work at a job, some days are bad days. There are always days you don't want to do the work. There are also likely some days that you dread starting. Whether you work for someone else or run your own business, there will be times you aren't completely in control of the work and wonder how you ended up in this situation. Even if you're self-employed, you have clients that sometimes dictate your day.

I've worked for myself in the past, and I currently have an amazing job as an advocate/architect with Redgate Software. I get to travel all over and talk about AI readiness, DevOps / Database Change Management, Database Intelligence, and random SQL Server stuff. Usually it's a lot of fun, but at times it can be hard. If you see me not engaging at an event, it might be that I've been on the road a lot while still having lots of other work commitments to manage. I might be worn out and need a break. Those often are tough days. (FYI - We always need good people and have a few spots open.)

Lately I've been hearing people talk a bit about AI and how it sometimes takes the joy out of work. That might be because it's doing the stuff you enjoy doing. This conversation with Casey Muratori on using AI is revealing. He's not using AI because he loves programming. He doesn't want to have AI doing his coding.

That's interesting, and it got me thinking about daily tasks, the things we do and what we might send off to be handled by an assistant.

What things do you not want to do at your job?

That's the question today. Let me know what things you wish you could get someone else to do, or some robot to handle for you. I know lots of people wish they had a robot to do the laundry or dishes at home. What tasks at work would you want a trustworthy helper to handle?

Steve Jones - SSC Editor

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

 
 
 Featured Contents
SQLServerCentral Article

Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server

john.martin from SQLServerCentral

Learn how the bitwise functions SET_BIT() and GET_BIT() can be used to manage data stored inside a single column.

External Article

9 things I wish SQL Server had (and why they’d matter)

Additional Articles from SimpleTalk

Anyone who’s spent years writing T-SQL has a mental list of “why doesn’t SQL Server just do this already?” moments. Here are 9 of those from Louis Davidson’s perspective – a wish list of practical, coding-oriented feature requests drawn from real-world pain points.

Blog Post

From the SQL Server Central Blogs - Keeping Redshift System Table History Past 7 Days with S3 Tables

epivaral from SQL Guatemala

Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine until an auditor or an incident review asks for something older. Until now the usual...

Blog Post

From the SQL Server Central Blogs - Updating the Data API Builder

Steve Jones - SSC Editor from The Voice of the DBA

I was updating my session for the Data API Builder (DAB) recently, mostly to work with the MCP server capabilities. As I was trying to get this working, I...

Microsoft Power Platform Up and Running: Learn to Analyze Data, Create Solutions, Automate Processes, and Develop Virtual Agents with Low Code Programming

Site Owners from SQLServerCentral

The book begins with the basics, explaining what low-code and no-code are and showing how to maximize efficiency in creating business applications for one's organization. Next, the book describes the Microsoft Power Platform's foundation, as well as all its components and services. Readers will begin with practical exercises right away, beginning with provisioning a Power Platform environment. Next, the book delves deeper into the Power Platform components such as Power Apps, Power Automate, Power BI, and Power Virtual Agents. Towards the end, the book explains practical exercises for each feature or service where you will gradually build a small business solution for a fictitious organization, Project Wizards, Inc.

 

 Question of the Day

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

 

Squared Values

What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12')

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)

RegEx Functions II

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM

If I run this query, which row(s) are returned?

SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^d')
 AND BusinessEntityID IN (7,8)

Answer: 1 - ID 7

Explanation: This matches one row, as the function is case sensitive by default. Only row ID 7 matches. Ref: REGEXP_LIKE() - https://learn.microsoft.com/en-us/sql/t-sql/functions/regexp-like-transact-sql?view=sql-server-ver17

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 - Administration
How do I connect to a SQL Server database on my ISP? - I've got a web application for my side business. I've added a SQL Server 2019 database to it. Now, I'm trying to connect to it using SSMS 20.2 and also Visual Studio Code. I've been following the instructions they have here which seems straight forward to me. The error I'm getting from Visual Studio Code […]
SQL Server 2019 - Development
advice on ssrs version control - Hi we're a bit behind on versioning ssrs.  I think we have over 1600 reports, 65 data sources and over 700 folders on our main sql server.  And a smaller amount on a separate sql server in one of our plants.    for some reason we also keep xls (over 400) , pdf's (over 3,000) […]
Editorials
The Costs of Multiple Platforms - Comments posted to this topic are about the item The Costs of Multiple Platforms
Looking for New Blood - Comments posted to this topic are about the item Looking for New Blood
The End of Summer - Comments posted to this topic are about the item The End of Summer
Measuring Productivity - Comments posted to this topic are about the item Measuring Productivity
Article Discussions by Author
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform - Comments posted to this topic are about the item Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
RegEx Functions II - Comments posted to this topic are about the item RegEx Functions II
Adding new column with DEFAULT - Comments posted to this topic are about the item Adding new column with DEFAULT
Server-Level Row Counts for Tables and Views - Comments posted to this topic are about the item Server-Level Row Counts for Tables and Views
Hyperscale Replicas I - Comments posted to this topic are about the item Hyperscale Replicas I
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't - Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Importing Excel files into SQL Server using DuckDB and Python - Comments posted to this topic are about the item Importing Excel files into SQL Server using DuckDB and Python
Tracking All the Queries - Comments posted to this topic are about the item Tracking All the Queries
SQL Server 2022 - Administration
Performance Regression After Upgrading from SQL Server 2016 to 2022 - Bonjour à tous, La semaine dernière, nous avons effectué une mise à niveau de notre instance SQL Server, en passant de SQL Server 2016 à SQL Server 2022. Au début, tout s'est bien passé et nous avons défini le niveau de compatibilité de la base de données à 160 comme recommandé. Cependant, peu après la […]
 

 

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

 

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