Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

AI Concerns

I hosted a webinar a few weeks ago about Artificial Intelligence and how it might affect data professionals. It was an interesting discussion with Kellyn Pot'Vin-Gorman and Brian Randell, with all of us having slightly different perspectives. Overall, we all agree AI is amazing and can be a useful tool for data professionals.

This week I've been in Redmond at the MVP Summit, and AI has been a topic among many MVPs. Lots of jokes have been told, no shortage of which dealt with getting rid of staff. Not that these MVPs want to see less staff, but they know that executives and managers might see all the AI hype about how GitHub CoPilot writes code and think they need less developers.

I don't know if that is really how executives will view the world, especially as most IT departments have more work than resources to complete their list of tasks. I can see AI helping get more done, which might mean less hiring (or slower hiring) in the future.

There was an article this week talking about ways to protect your job in the age of AI hype. It was interesting in that the suggestions all revolve around bringing more value to your job. The suggestions about working in specialized areas, complex areas, being a better employee with documentation, these are all things that I've done in my career. It's what I also see from many MVPs.

Maybe the most interesting item was to think about incorporating AI into your work now. It's not necessarily an expert on your work, but it is a tool. As the models absorb more information and become better trained, they can be a level to help you get more work done. They can assist you in tedious work, which is something many of us can benefit from.

I am looking forward to getting access to CoPilot and keeping an AI tool up on my desktop, learning how it might help me, and maybe more importantly, where it won't help me.

I can't stop this trend, but I can better understand it and learn how it might fit with my daily work. Knowing that helps me better understand how I might have an informed and rational discussion with management about the advantages or disadvantages of this new technology.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

Redgate opens the doors to cross-database DevOps Test Data Management

Redgate’s new DevOps test data management tool, Redgate Clone, provisions production-like data in seconds for SQL Server, PostgreSQL, MySQL and Oracle databases.

The Journey to Team-based Development with Flyway

This article explains why Flyway is fundamentally well-suited to the task of bringing control and automation to database development work and then the features of Flyway Teams edition that become necessary when a team of developers need to work concurrently on a database.

AI/Machine Learning/Cognitive Services

ChatGPT- Building Out Oracle with Templates and Ansible for a DataGuard Environment

From DBAKevlar

This is a continuation of the evolution of AI with ChatGPT and how much it can be leveraged, allowing me Tags:  AI in IT Del.icio.us Facebook TweetThis Digg ...

ChatGPT vs. Watson Assistant

From Past News - RSS Feeds

ChatGPT and Watson Assistant are two popular AI-based chatbots, and both are riding the immense wave of interest in generative AI. Advanced AI Chatbots – in essence, generative AI...

Can ChatGPT Write PowerShell Code?

From IT Pro - Microsoft Windows Information, Solutions, Tools

We put ChatGPT’s PowerShell scripting abilities to the test. See how the AI chatbot performed.

Generative AI risks concentrating Big Tech’s power. Here’s how to stop it.

From Technology Review Feed - Tech Review Top Stories

This story originally appeared in The Algorithm, our weekly newsletter on AI. To get stories like this in your inbox first, sign up here. If regulators don’t act now, the...

Administration of SQL Server

Trace flag 902 in SQL Server and Error 574

During a routine SQL Server patching process on SQL Server some error messages appeared in the SQL Server Error Logs. As a result SQL Server was not able to start up

How to migrate data from regular tables to ledger tables

From Azure SQL

This article will guide you through the steps to convert your existing data into tamper proof data by using the ledger feature.   To enable ledger for a specific table,...

What Does Setting the SQL Server Compatibility Level Do?

From Brent Ozar Unlimited

If you right-click on a database in SQL Server Management Studio, you get an option to set Compatibility Level at the database level: When you upgrade SQL Server or...

SQL Server DBCC Commands: DBCC SHOWCONTIG

From Steve Stedman

DBCC SHOWCONTIG is a has been announced to be depr...

New Job -> Week 5 -> Create Index Maintenance Scripts

From SQLServerCentral Blogs

This is part of a series of new job blog posts. You can find them all here. Week 5 goal: set up Ola index maintenance for all Azure SQL... The...

Video: Configuring a SQL Server Instance

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS We’ve installed SQL Server…but what next? Learn about important configuration options for that new SQL Server instance. LINKS AND ADDITIONAL INFORMATION All of these videos...

Azure Databricks, Spark and Snowflake

Mount Azure Blob Storage, Azure Data Lake Gen 2, Azure SQL and Azure Cosmos DB to Azure Databricks

From MSSQL Tips

In this article, we will walk through how to mount different types of Azure storage like Azure Blob Storage, Azure Data Lake Gen 2, Azure SQL, and Azure Cosmos...

What is the difference between map and mapValues functions in Spark?

In this post we will look at the differences between map and mapValues functions and when it is appropriate to use either one.

Azure DevOps

Azure DevOps YAML Pipelines – Building Database Projects

In previous blog posts, I explained how to automate the Database Project Build & Deployment process using Azure DevOps (Release) Pipelines. These blog posts focused on setting up as easily as possible using the Classic Editor.

Azure SQL

Add Azure SQL databases to existing auto-failover group

From MSSQL Tips

In this article, we walk through the steps of how to add an Azure SQL Database to an existing auto-failover group.

Career, Employment, and Certifications

5 Ways to Protect Your Programming Job Against AI

From IT Pro - Microsoft Windows Information, Solutions, Tools

If you're a software developer, thinking outside t...

Computing in the Cloud (Azure, Google, AWS)

Get your Query History in Redshift

Because my Windows machine apparently decides to install updates over night (and thus reboot my machine), it has happened that I lost the query that I was writing for Redshift in the tool DBeaver. When you work with SQL Server Management Studio (SSMS), you typically don’t have this issue as a temporary copy is always saved. Close down SSMS, restart it and the queries are still there.

What is AWS Amplify?

From Petri IT Knowledgebase

AWS Amplify is an Amazon Web Services (AWS) applic...

How to rename an S3 bucket?

From Hadoop in the Real World

There is no single command that can rename a S3 bucket. Mainly because S3 is not a filesystem and a bucket is not a typical folder […] The post How...

Google Cloud Resource Management and Monitoring - Part 3

From MSSQL Tips

This article continues the GCP series and we will learn how to manage and monitor Google Cloud resources and billing.

Conferences, Classes, Events, and Webinars

New PostgreSQL 101 Webinar: Why PostgreSQL in 2023?

Join Redgate Advocate, Ryan Booz, and find out about the history of PostgreSQL, the different PostgreSQL variants, and the reasons behind its increasing popularity.

SQL Saturday Haiti 2023 (#1050) - Virtual

SQL Saturday Haiti returns on April 29, as a virtual event in French. Register today and join us for free education and knowledge.

Atlanta MS BI and Power BI Group Meeting on May 1st (Getting started with Power BI Deployment Pipelines)

From Prologika (Teo Lachev's Weblog)

Please join us for the next meeting on Monday, May 1st, at 6:30 PM ET.  Akshata Revankar (Data Engineer, Specialist at McKinsey & Company) will show you how to...

Discover Building without Limits at AWS Developer Innovation Day

From AWS News Blog

We hope you can join us on Wednesday, April 26, for a free-to-attend online event, AWS Developer Innovation Day. AWS will stream the event simultaneously across multiple platforms, including...

DMO/SMO/Powershell

PowerShell: How to find Special Characters in a String

From Sid 500 PoSh

Sometimes special characters are a nuisance. If you are trying to create some user accounts in on-premise or cloud environments, you should avoid special characters in usernames. In this...

Use PowerShell Functions to Quickly Simplify Your Scripts

From Petri IT Knowledgebase

Are you creating PowerShell scripts for the first ...

Fun With PowerShell – StringBuilder

From Arcane Code

Fun With PowerShell - StringBuilder

Data Privacy, Compliance, and Governance

What Is Sensitive Data Exposure and How Can It Be Avoided?

From Dataversity

Organizations nowadays process tons of consumer data every day. This data ranges from the standard – names, email addresses, etc. – to personally identifiable information, like social security numbers...

4 Ways to Build a Culture of Accountability in Data Privacy

From IT Pro - Microsoft Windows Information, Solutions, Tools

Here are four ways your enterprise can develop an accountable data privacy culture.

Data Science

Should you use the Wald confidence interval for a binomial proportion?

From AllAnalytics

The "Teacher’s Corner" of The American Statistician enables statisticians to discuss topics that are relevant to teaching and learning statistics. Sometimes, the articles have practical relevance, too. Andersson (2023)...

The Woodbury matrix identity and some special cases

From Statistical Odds & Ends

The Woodbury matrix identity is a commonly used identity for inverting a matrix of a particular form. The identity states that where , , and are conformable matrices, i.e....

DevOps and Continuous Delivery (CI/CD)

GitLab DevSecOps Report Shows Growing Demand for Efficiency, AI/ML

From IT Pro - Microsoft Windows Information, Solutions, Tools

GitLab's research reveals software development trends: focus on security, AI in workflows, and DevSecOps adoption for improved efficiency.

Hardware

Seagate Ships First 30TB+ HAMR Hard Drives

From Tom's Hardware US

Seagate to recognize revenue shipments of 30TB+ HD...

Lenovo Slim Pro 7 Review: Zen 3+ Is Back

From Tom's Hardware US

The Lenovo Slim Pro 7 is pretty and thin for a lap...

New Asus Zenbook S13 Wedges 13th Gen Intel, OLED Screen Into Extremely Thin Chassis

From Tom's Hardware US

At 1 cm thick and approximately 1 kg in weight, Asus is cramming a lot of tech into a svelte chassis.

Crucial T700 SSD Preview: Fastest Consumer SSD Hits 12.4 GB/s

From Tom's Hardware US

The Crucial T700 looks to be the fastest PCIe 5.0 ...

Microsoft Building Its Own AI Chip on TSMC's 5nm Process

From Tom's Hardware US

Microsoft is reportedly working on an artificial intelligence chip based on TSMC's 5-nanometer process to better compete with Nvidia and other chip suppliers.

MDX/DAX

DAX Pareto Calculation

I always enjoy it when we get new DAX functions, especially so for the new set of WINDOW Functions recently added. As part of the April 2023 release of Power BI Desktop, we now have a RANK function and the ability to use a measure to control the order within the existing WINDOW function.

Oracle/PostgreSQL/MySQL/other RDBMS

Modifying MySQL data from within Python

The process of modifying MySQL data from within Python is, in many respects, similar to querying data. You must define a connection object that links to the database and define a cursor object based on that connection.

Accuracy of Geometry data in PostGIS

A common use case with PostGIS data is to calculate things, such as distances between points, lengths of lines, and the area of polygons. The topic of accuracy, or inaccuracy, with GEOMETRY data comes up often.

Performance Tuning SQL Server

YouTube Days: How Indexes Talk To Each Other In SQL Server

From Erik Darling Data

How Indexes Talk To Each Other In SQL Server I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and...

Which execution plan icons are relevant today?

From SQL Server Fast

Back in 2018, when I started working on the SQL Server Execution Plan Reference, I spent quite some time thinking about what icons to show for all operators. I...

YouTube Days: Improving The Parallel Query Processing Documentation For SQL Server

From Erik Darling Data

Improving The Parallel Query Processing Documentation For SQL Server I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and...

YouTube Days: Join Simplification In SQL Server

From Erik Darling Data

Join Simplification In SQL Server I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and publishing the results to...

PowerPivot/PowerQuery/PowerBI

Power Query – How to run a query only if data is returned

From FourMoo

I had a requirement where I wanted to only have th...

3 tips for the new On-Object editing of a Power BI visual

From Guy in a Cube

Have you started using the new on-object editing for Power BI visuals? Adam found some hidden gems that you may not be aware of when using it! You need...

Pro DevEx for Power BI

Developing Power BI reports can be a very manual process. After building a report, you (or someone else in your team) has to publish the report into the right workspace at the right time. You might have multiple workspaces featuring the same content, for example to allow stakeholders to perform user acceptance testing (UAT) before a report is released.

Disabling Filter Pane Aggregates In Power BI

From Chris Webb's BI Blog

Stop queries showing aggregates in the Power BI fi...

Product Reviews and Articles

Flyway and SSDT: Extracting a DACPAC from a Flyway-managed Database

From Product learning – Redgate Software

When you are integrating Flyway into an existing SQL Server SSDT development, you don't necessarily have to change everything at once. The development team might continue to use the...

Product Upgrades and Releases

SQL Server 2019 Cumulative Update 20

From Glenn Berry

On April 13, 2023, Microsoft released SQL Server 2...

General Availability: Support for Linux clients to use identity-based access to Azure file shares over SMB

From Azure Updates

Linux SMB clients can now use Azure Files identity based authentication and authorization. This capability is available to devices that are domain joined to either customer-managed Microsoft AD DS or Azure...

SQL Server News

Ordered Columnstore Indexes in SQL Server 2022

One of the more challenging technical details of columnstore indexes is the need for data to be ordered to allow for segment elimination. To assist with this challenge, SQL Server 2022 has added the ability to specify an ORDER clause when creating or rebuilding an index.

SQL Server Security and Auditing

Lesson Learned #344:Managed Instance needs permissions to access Azure Active Directory.

From Azure Database Support Blog

Today, we worked on a service request that our customer got the following error message : Managed Instance needs permissions to access Azure Active Directory. You need to be...

The Importance of TLS with SQL Server

From Azure SQL

Invariably, when I ask people what Transport Layer Security (TLS) does, they say something like, “it protects my credit card info when I buy things online.”   The response is not...

Security News and Issues

New Zero-Click Exploits Against iOS

From Schneier on Security

CitizenLab has identified three zero-click exploits against iOS 15 and 16. These were used by NSO Group’s Pegasus spyware in 2022, and deployed by Mexico against human rights defenders....

Google Issues Emergency Chrome Update for Zero-Day Bug

From Dark Reading: Dark Reading News Analysis

Because the security vulnerability is under active exploit, Google isn't releasing full details of the flaw while users could remain vulnerable.

T-SQL and Query Languages

Introduction to the SQL Standard Deviation function

From SQLShack

In this article, we will learn about one of the im...

REPLACE versus TRANSLATE for SQL Server Text Data Manipulation

From MSSQL Tips

Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.

One use case for NOT using schema prefixes

From Simple Talk

I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. In spite of what may be a controversial title to many of...

Azure Monitor: Use Dynamic Thresholds in Log Alerts

In this new blog post I am going to explain how to use dynamic threshold in log alerts. Think for a second, that you need to create an alert that must, at the same time, apply to more than one resource and react to different thresholds.

#This vs @That – Should I use a Table Variable or a Temporary Table?

From Purple Frog Systems

When working with SQL Server, it’s not uncommon to need to store data in a temporary table or table variable. While both options can be used to accomplish the...

Multiple Joins – Poster 

From Steve Stedman

SQL Server provides several join types to combine data from two or more tables based on a common column or set of columns. Among these are the essential join...

Tech News

Ryzen 7 7800X3D Benchmarks Show Advantages for Linux Over Windows 11

From Tom's Hardware US

AMD's Ryzen 7 7800X3D is 7% faster in Linux compar...

The Lighter Side

Hacking Pickleball

From Schneier on Security

My latest book, A Hacker’s Mind, has a lot of sp...

 
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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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