ChatGPT in Visual Studio tutorial (2023-05-01)

SQLServerCentral Newsletter for May 1, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [ChatGPT in Visual Studio tutorial]( - [How to Slice Data by Week in a Calendar Table using DAX]( - [Working with Flyway And Entity Framework Code First: An Overview]( - [From the SQL Server Central Blogs - New Job -> Week 6 -> Ozar sp_BlitzIndex]( - [From the SQL Server Central Blogs - How to use the new dynamic format strings for measures in Power BI]( - [Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen]( Question of the Day - [Convert Dates for XML]( The Voice of the DBA  Design Lessons for Software I play guitar as a hobby. Not great, but I enjoy it and find it relaxing. It's a good break from my day periodically, killing a few minutes before a meeting. It's also a nice way to unwind at night. I find it better than playing games or my phone or streaming more Netflix shows. I enjoy those as well, but there is something different about music. I tend to use acoustic guitars, meaning no electronics. However, I have had electric guitars in the past, and have even used pedals to alter sounds. When I saw this article about [design lessons from guitar pedals]( I was intrigued. It has 5 lessons from these devices, which are for other digital gear. However, I think they could apply to software as well. The first one is that these pedals are rugged. While I'm not stomping on pedals with my feed, I do think that we could ensure software is more robust and not susceptible to small mistakes by users, especially in the order of their touches/clicks that might cause problems. The second is about using more than our hands, which I hope doesn't apply. You can add voice or gestures, but don't require those. I HATE those features. The fourth is about physical UIs, including physical buttons, which [I think is important for cars]( but not necessarily for all software. However, if you can give someone a button or knob instead of a touch, it can be helpful. The third is to have bold, visual cues. I had a designer once say we ought to build more Fisher-Price software, meaning something [obvious and usable by a child](. I know some of our processes are complex, but we ought to work to keep things as simple as we can. For databases, I think clear, consistent names help here, especially for indexes, FKs, and triggers. The last one is to make things beautiful. I have to admit I didn't think about this much before coming to work for Redgate Software. Across the last 15 years I've learned to appreciate the value of design, UX, and the people that make things look good. I can't do that; I have no skill in this area, but I know that having someone come behind me to do this is worth the effort. Of course, on top of all this, your software has to work and perform well. If the software doesn't work, or is very slow, none of your clients are happy. Learn to write better code, improve your skills, and these design lessons will make sure all your efforts shine through. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [ChatGPT in Visual Studio tutorial]( Daniel Calbimonte from SQLServerCentral In this article, you will see how ChatGPT works with a database project. [External Article]( [How to Slice Data by Week in a Calendar Table using DAX]( Additional Articles from MSSQLTips.com Judging from my experience working with business stakeholders across several organizations, slicing data by current week, previous week, two weeks ago, and so on has become a requirement for reporting. I will demonstrate a simple approach to achieve this requirement. [External Article]( [Working with Flyway And Entity Framework Code First: An Overview]( Additional Articles from Redgate This article presents an approach to database development and deployment that combines the strengths of Entry Framework Code First for .NET-driven development with the control and database versioning provided by Flyway's SQL migrations. It allows every database change to be reviewed and tested for integrity, performance, and stability in the same way as any application change. It should make a Database CI process much easier to sustain. [Blog Post]( From the SQL Server Central Blogs - [New Job -> Week 6 -> Ozar sp_BlitzIndex]( hellosqlkitty from SQLKitty This is part of a series of new job blog posts. You can find them all here. Week 6 goal: Analyze all Azure SQL Database indexes. Last week, I... [Blog Post]( From the SQL Server Central Blogs - [How to use the new dynamic format strings for measures in Power BI]( Meagan Longoria from Data Savvy The April 2023 release of Power BI desktop introduced a new preview feature called dynamic format strings for measures. This allows us to return values with different formats from... [Transact-SQL: The Building Blocks to SQL Server Programming eBook by Gregory A. Larsen]( [Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen]( Greg Larsen from SQLServerCentral Transact SQL (TSQL) is the languaged used to query and update data stored in a SQL Server. This book, written by SQL Server Central and Simple Talk author Greg Larsen, will give developers an understanding of the basics of the TSQL language. Programmers will have the building blocks necessary to quickly and easily build applications that use SQL Server.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Convert Dates for XML I have a date value stored and I want to convert this with SELECT CONVERT() to a format that works well with XML. What should I use? 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) DOP Feedback and QDS In order to use DOP feedback in my query processing, what are the Query Data Store (QDS) requirements? Answer: QDS must be enabled, but must be read/write Explanation: The QDS must be enabled and in read/write mode. Ref: DOP Feedback - [ [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 [Alternate SQL]( - In my sql result, I want to create a column called RCount. Condition: For each RecNo, AccNo * If the field Reason is "Accepted", it doesn't matter what other records contain for a specific RecNo, AccNo. It should return 1 for the very first instance of Accepted and ignore the rest. * If more than […] [How do I script the creation of a job to use environments?]( - I have been googling and googling and I have yet to find a way to check the environment box when configuring an SQL Job using an SSIS package. Specifically, when you configure a step of a job, there is a checkbox to use an Environment as shown in the image attached  I have been […] [Update a row based on MaxDate]( - Morning all Does anyone know how I can update a table (one row) based on the maxdate of the row? The problem being the id is different for the same item just used multiple times, so all the other rows for the item need to stay the same but the maxdate row needs to change […] SQL Server 2019 - Administration [Permissions to view SSIS SQL Agent job step]( - I have a requirement for specific users to view SQL Agent jobs through SSMS. They've been granted the SQLAgentOperatorRole and that works up to a point. However for jobs owned by another login, if the job step is a "SQL Server Integration Services Package" type, when clicking on the "Configuration" tab, the "Connection Managers" and […] [sql server replication Mointoring alert]( - Hi How to monitor sql server replication i mean there is replication monitor but i wanted to check lag between publisher and subscriber. I mean in log shipping we know how many log files are pending to be applied on dr. In always on its redo and undo logs which can helps to estimate how […] [SQL SERVER 2019 ... ERROR TO CONNECT WITH A NEW LAPTOP]( - If I try to connect with a new laptop I receive this error ... (ARCA EVOLUTION SOFTWARE) This error compare also if I try to connect to database with MsExcel please help me to solve ... thks and rgds [Always on Secondary Database]( - I want tp create a scenario when I perform failover from Node1 to Node2, I want the database to get stuck in Reverting/In Recovery state on Node1 for longer time so that I can control it until I am done with testing. I know this can be done as index maintenance or big chunks of […] [Integrated Authentication showing in ErrorLogs]( - Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only  Server info Below: Authentication Mode: Windows and SQL Server Authentication SPN is correct  Azure Data Factory [Question: Adding set variable activity output to copy data]( - In azure data factory I created a lookup for getting the id, place. After that in a foreach I used a webactivity to run the an api to get the formatted_address. I extracted the formated_address through a set variable activity. I want to make a new sql table with the id and the formatted_address. I […] Reporting Services 2008 Development [Export SSRS Report Data into Multiple Excel Worksheets Not Working]( - I am trying to Achieve below task Export SQL Server Reporting Services Report Data into Multiple Excel Worksheets I doing all the Steps as Specified in URL Still i am not getting the Sheet Names As expected. Could you Please let me know the Reason.  Connecting [unable to connect to SQL2005 Cluster via instance name with Microsoft Intune pc]( - We are currently testing a pc deployed and managed using Microsoft Intune. We notice we cannot connect to a clustered SQL Server 2005 instance using the instance name. IMO the problem is that with SQL 2005 the SQLBrowser service always replies using the ip address of the node that hosts the instance. When using the […] Integration Services [SSIS Package to csv and i have some phantom CRLF]( - I have a script in the SSIS package that goes to a flat file destination. When I run the script in management studio it runs fine no blank rows. When I use the script in the data flow of my SSIS package it randomly puts a CRLF at the end of a 60 rows and […] Editorials [Article review timeline]( - Hi, I have been frequenting this site for a while and I would like to contribute an article regarding a recent project of securing RDS that I helped with. I have submitted an article for review couple of weeks back and I am curious on the timeline when I can get some feedback on it. […] SQL Server 2022 - Administration [In Place Upgrade of OS and SQL Server]( - I'm being asked to do an in-place upgrade of both the OS and SQL Server on a physical server. Currently running - Windows Server 2016 Standard SQL Server 2017 Standard Edition (64-bit) Wanting to upgrade to - Windows Server 2022 Standard SQL Server 2022 Standard  Is it recommended to update the OS first or […] SQL Server 2022 - Development [Export SQL Data Classification Recommendations]( - Is there a way export Data Classification recommendations as a pdf or text file? Thanks you.    [RSS Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -