ChatGPT vs. Watson Assistant (2023-04-22 DBW)

Database Weekly for April 22, 2023 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 Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -