Leveraging AI Tools for SQL Queries (2024-01-19)

SQLServerCentral Newsletter for January 19, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Leveraging AI Tools for SQL Queries]( - [Buy on-demand access for Summit 2023 today]( - [Introducing the MongoDB Document]( - [From the SQL Server Central Blogs - Prompt EAP AI Experiments: Creating a History Table]( - [From the SQL Server Central Blogs - Building a Docker image from a Github repository]( - [SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability]( Question of the Day - [What is the rounded result?]( The Voice of the DBA  Top of Your Profession Today we have a guest editorial Last year I delivered a presentation, titled Climbing to the Top of Your Profession, at the Google DevFest in Orlando. It was a new presentation and a new audience for me, though it would be fair to say it was a variation of a topic I’ve covered a few times about learning and growing. My target audience was those who had made it on to the first or second rung of the IT career journey and I intended to encourage them to look beyond their immediate work or workplace and think about what it would take to be really good at what they did. The talk went well and as is so often the case I think I learned as much as the attendees did. What does it mean to be at the top of your profession? That is the question! We might define it as earning a title (Senior DBA, Principal Engineer, etc.). We might instead define it as salary. Or we might define it by name recognition, or perhaps by accomplishments such as presenting at an event or being hired by a well-known company. Or by those who consider you a worthy peer. You could picture it as a ranking of everyone with your job title. You start out at the bottom of the ladder as the latest person to acquire the title and you try to climb to the top. Then you get promoted and you’re at the bottom of the next ladder, going again, until you run out of ladders to climb or energy to climb them. A different, maybe more useful context is how you explain your skills and experience to your family. It’s a big moment when you get that first job in your career field and another big moment when you get to the senior level. For family, that means you’ve figured it out. I asked the attendees at the presentation about what they saw as being at the top of their profession and the answer that got the most nods from the other attendees was “to be trusted to do important work independently”. That’s a wonderful answer. One that will probably change as they grow, but certainly a valid and useful view of building a career. Reflecting on that discussion afterward, I was reminded of my early days in IT. First job as a DBA, first DBA for the company, and a performance problem I couldn’t figure out. I asked for help, we found a consultant, he helped us find and fix the problem, and that seemed to me like a view of the top – to be paid big bucks for having the deep knowledge to solve a problem quickly. Thinking about what the top looks like is a useful exercise because you are here and you know there must be a path to there. That drives learning and ambition and I think that’s the key, because we rarely are given (or can easily find) a checklist of all the skills we need to acquire to be good, much less great. Having a destination in mind can help us figure out at least some of the things we need to learn. Yet, after giving the presentation and writing this editorial I’m still unsure if it’s the most useful framing. Ideally, it’s aspirational, but it can also be overwhelming and unrealistic for many. I look forward to your thoughts in the comments. Andy Warren [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Leveraging AI Tools for SQL Queries]( dmamtora from SQLServerCentral This article covers the basics of how different AI tools can be used to write SQL. [External Article]( [Buy on-demand access for Summit 2023 today]( Press Release from Redgate Buy your on-demand ticket today to get access to hundreds of high-quality sessions across all 5 tracks at PASS Data Community Summit 2023. It’s a great way of learning at your leisure if you weren’t able to join us in person last year. On-demand access is available for non-attendees to purchase for $1295. This will grant you access to all session recordings until November 17, 2024. Click here to buy. [External Article]( [Introducing the MongoDB Document]( Additional Articles from SimpleTalk MongoDB is a document database. As such, the data is stored as individual documents. A document is a data structure made up of one or more field/value pairs. [Blog Post]( From the SQL Server Central Blogs - [Prompt EAP AI Experiments: Creating a History Table]( Steve Jones - SSC Editor from The Voice of the DBA SQL Prompt has an EAP using an AI model to help write code. I’ve been lightly experimenting with it, since I think AI is an interesting tech and it’s... [Blog Post]( From the SQL Server Central Blogs - [Building a Docker image from a Github repository]( dbafromthecold@gmail.com from The DBA Who Came In From The Cold To build a custom Docker image we create a docker file with instructions in it. For example, a really simple custom SQL Server 2019 Docker image can be built... [SQL Server 2022 Revealed]( [SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability]( Additional Articles from SQLServerCentral Know how to use the new capabilities and cloud integrations in SQL Server 2022. This book covers the many innovative integrations with the Azure Cloud that make SQL Server 2022 the most cloud-connected edition ever. The book covers cutting-edge features such as the blockchain-based Ledger for creating a tamper-evident record of changes to data over time that you can rely on to be correct and reliable.   Question of the Day Today's question (by Steve Jones - SSC Editor):  What is the rounded result? What is the result from this code on SQL Server 2019? SET NUMERIC_ROUNDABORT OFF; SET ARITHABORT ON; GO DECLARE @result DECIMAL(5, 2), @value_1 DECIMAL(5, 4), @value_2 DECIMAL(5, 4); SET @value_1 = 1.1234; SET @value_2 = 1.1234 ; SELECT @result = @value_1 + @value_2; SELECT @result; GO 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) Adding a PK - II I run this code on SQL Server 2019. What happens? CREATE TABLE SalesTracking ( SalesDate DATETIME , SalesPersonID INT , CustomerID INT NOT null , PONumber VARCHAR(80) , paid bit ) GO CREATE CLUSTERED INDEX SalesTrackingCDX ON dbo.SalesTracking (SalesDate) GO ALTER TABLE dbo.SalesTracking ADD CONSTRAINT SalesTrackingPK PRIMARY KEY (CustomerID, SalesPersonID) GO Answer: The alter table add constraint statement errors out since one of the columns is nullable Explanation: All the columns included in a PK must not be nullable. Ref: Create Primary Keys - [ [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 2017 - Development [Error handling with SSIS and stored procedure execution]( - Hello SSC! Happy New Year and I hope everyone had a safe and healthy holiday! I have this ETL process that executes over 50 stored procedures and several data flow tasks. The error handling in the ETL itself is decent, but if a stored procedure fails, no errors are thrown. My idea was to create […] [Grouping based on chronological periods]( - Hello, I have a table Customers that contains the current value and another table Customers_History contains the history values. The customers have more that 10 fields AS Bellow a sample of data : CREATE TABLE #CUSTOMERS( ID int primary key identity, First_Name varchar(255), Last_Name varchar(255), Nick_name varchar(255), Email varchar(255), Date_Bithday date, Gender varchar(1), Is_Married int, […] Administration - SQL Server 2014 [FTS Catalogs Set to Case Sensitive True/False]( - I understand what the setting means for Collation Sequences and the impact it has on Indexes and in Search. We have a number of FTS catalogs with some set to TRUE and some set to False. What I am looking for is a way to query the Indexed Table Columns in the catalogs to see […] SQL Server 2012 - T-SQL [The data types xml and varchar are incompatible in the equal to operator.]( - Hi I'm trying to return all rows where the field DocumentXML equals 'Document' The data in the field starts like this. The field has other XML data that starts with  [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. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -