Evolving Role of Data Professionals in Artificial Intelligence Era (2024-03-04)

SQLServerCentral Newsletter for March 4, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Evolving Role of Data Professionals in Artificial Intelligence Era]( - [Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities]( - [From the SQL Server Central Blogs - Know Thy Platform]( - [From the SQL Server Central Blogs - Adding Git LFS Support – #SQLNewBlogger]( - [Microsoft Power Platform Up and Running: Learn to Analyze Data, Create Solutions, Automate Processes, and Develop Virtual Agents with Low Code Programming]( Question of the Day - [Logical Operators]( The Voice of the DBA  Creating Candidate Interest It can be hard to find candidates for positions these days. I know there are a lot of people looking for jobs, but are they the ones you want? Are they a good fit for your team? Those are hard questions to answer when culling through resumes, conducting phone screens, and sitting in interview rooms asking questions from a template. What can be even harder is to compare different candidates when multiple people may interview the candidates. Even if you do all the work yourself, you're busy. Can you make good comparisons of different individuals that you've spoken to across a few weeks, in between all the real work you're trying to get done? I know I've struggled to do this, no matter how many notes I take or how long the discussions are with other team members. I have had a very mixed bag of success in hiring. What if you had more qualified, more talented candidates applying who were interested in the work your organization does? What if you gave candidates a chance to impress you with actual work that's related to what you do? It's an interesting idea, and I saw this in action from an organization recently. [Verizon has built a repo]( that has a bunch of docker files to show how they build, test, and deploy database changes. They make this available to anyone, but certainly to candidates who are looking for work. A candidate can experiment with this, play around, and make some decisions about if this is the type of environment in which they want to work. This repo is limited to database changes, with testing, linting, and more, but I could certainly see some sample challenging query problems added in here, perhaps just as tests (similar to [exercism.org]( with the opportunity for candidates to solve them. I would even take these from internal teachings/learnings that current employees use. Surely, you're leveling up and teaching your staff how to write better code. I don't know if this is hugely scalable as candidates might not have time to work through 10 repos from 10 companies, but I do think that asking those who pass a phone screen to look through here makes some sense. Walking them through some of this in an interview and having them ask questions or explain something could help you better understand how someone works. They might even suggest improvements. This should give you a better idea of whether a candidate is someone who fits in your environment, can do (some of) the work, and works in a way that meshes with your team. I know some companies have tried some of this in the past, often with a standard test or code quiz, but having a repo gives more time for someone to delve in and learn a bit in advance. It also gives you the chance to showcase some tech that your org uses, which might get a higher caliber of candidates applying because they want to work the way you do. Maybe you'll even get some experts who want to leave their current job to work with your org. There is no perfect way to find and hire successful candidates, but I think this is an approach that has some merit and could potentially help create interest from candidates that might not otherwise apply. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Evolving Role of Data Professionals in Artificial Intelligence Era]( Amit Rai from SQLServerCentral Generative Al tools like Gemini and GPT promise to automate and augment knowledge-based work. Data professionals must adapt to this transformation by acquiring new skills and playing a central role in their organization's AI-driven future. Data preparation, curation, ethical sourcing and labeling, and collecting user feedback become crucial as high-quality data is essential for effective LLM based application. [External Article]( [Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities]( Additional Articles from MSSQLTips.com Learn how to use Azure Data Factory to dynamically move bulk data from multiple sources to a new destination using the ForEach and Lookup activities. [Blog Post]( From the SQL Server Central Blogs - [Know Thy Platform]( kleegeek from Technobabble by Klee from @kleegeek IT and data professionals, I implore you – know thy platform. All of it. Not just the layer your job is tasked with. Modern public cloud (or any infrastructure... [Blog Post]( From the SQL Server Central Blogs - [Adding Git LFS Support – #SQLNewBlogger]( Steve Jones - SSC Editor from The Voice of the DBA I got this message recently while committing some changes: This post shows my work in adding Git LFS support to GitHub. Another post for me that is simple and... [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):  Logical Operators  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) Writing to Clones I run this code on SQL Server 2019: DBCC CLONEDATABASE(imdb, imdb_dev) I then change to the cloned database, imdb_dev, and run some queries. I then run this code while testing: INSERT dbo.Title (TitleID, Title, DateReleased) VALUES (3234, 'Maestro', '2023') GO What happens? Answer: This doesn't work because the database is in read only mode. Explanation: When a database is cloned, the clone is set as read-only by default. This can be changed, but in this case, the command fails as the database is read-only. Ref: DBCC CLONEDATABASE - [ [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 - Administration [Estimated rollback completion: 0%. Estimated time remaining: 0 seconds]( - Greetings! I have a process that has been running for over a day (normally it runs about 30 minutes), tried "Kill SPID", it shows "Commands completed successfully." but it is still running. tried "Kill Spid with StatusOnly", it shows "transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds."  The sql […] [Troubleshooting sql issue where multiple sessions are involved]( - Hi All, We have an application that spawns multiple spid's, runs multiple multiple batches , multiple txns. While troubleshooting a BLOCKING, initially thought to trace one spid and collect the sql statements for that session. But eventually, dev team and we saw multiple spid's are spawned as part of that process and even multiple databases […] SQL Server 2019 - Administration [SSMS - Consistency in Scripting Options Across Team]( - Hi, We use SSMS' "generate scripts" feature to script out all DB objects for source control. We have our scripting options dialed in the way that we like them under Tools -> Options -> SQL Server Object Explorer -> Scripting. Historically it had been a small handful of people that go through the process of […] [Filestream Filegroups on state RESTORING]( - Hello All, I have a question. My SQL Servers are running SQL Server 2019 CU23. I have a setup where i have a logship copy of a production database available on a secondary server. This copy is Standby/Read-Only. This database uses FileStream to store BLOB data. There are several filegroups for the FileStream Data. So […] SQL Server 2019 - Development [TSQL Pivot Crosstab]( - Hi, I am doing a crosstab but I am unsure if its a pivot or is there a simpler way of doing it. Create Table TblPerson (ID Int, Name Varchar(50), Child Varchar(50)); SELECT * FROM TblPerson ID, Name, Child  The output should look like this, not everyone has equal number of items so some […] [Find dependencies on a table]( - I am in the process of doing a re-write for my project so I need to find all SP that use a particular table. SS has a tool that lets me do this. How reliable is it? I tried sp_depends and compared the output from it and the above approach...they don't give me the same […] [what does this error mean?]( - I was running a SP and I got this. This is the first time I have ever received this. What does it mean? How do I fix it so it doesn't happen again? Msg 9002, Level 17, State 4, Procedure dbo.Query, Line 223 [Batch Start Line 2] The transaction log for database 'myDB' is full […] [how to properly index?]( - I am not sure how to decide on how I should index my tables so the query is able to run as fast as possible. I am fairly new to SS. My queries are all SELECT. Some use GROUP BY but others do not. There are no DELETE/UPDATE. How do I decide which type of […] [Need help read JSON file]( - Hello, I've JSON file format as following, { "acc_div": [ { "level1_code" : 1104, "level2_code" : "01", "gl_code" : "0900", "description" : "Finance Department - Estate Account ", "short_name" : "FINANCE " }, { "level1_code" : 1106, "level2_code" : "01", "gl_code" : "0933", "description" : "Marketing Department - SGRK ", "short_name" : "MKTG-KKSR " }, […] [when peers maintain a job rdp'd in they corrupt the job]( - Hi, one of my peers prefers to maintain one specific sql agent job after rdp'ing into that server. I think its probably because he usually wants to then restart the job knowing it will continue running even if he has to shut down his own pc. I'm not sure but i think if you restart […] [import json file]( - Any idea on how to import a json file into sql server? I've never done one before. I saw some example like below but the file I have had columns report for different sections.  SELECT import_data.* FROM OPENROWSET (BULK 'C:\Files\import_data\small_json.json', SINGLE_CLOB) as j CROSS APPLY OPENJSON(BulkColumn) WITH( name varchar (255), object_id varchar (255) , […] Reporting Services [Upgrading the SQL version]( - Hi we have an old sql server 2012 box that (among other things) hosts SSRS (front and back end). I need to upgrade the version of SQL. When I do this will SSRS take care of itself or are there other things I need to be mindful of? I have vague memories of doing this […] General [Career Advice]( - hello folks, I am posting this question with heavy heart. I have been a SQL server developer through out my career. I love it from all my heart. I love designing efficient database designs based on the business requirement of an existing/new application. I love playing with the data. Problem solving, bug fixing, performance tuning […] SQL Server 2022 - Administration [Sql 2022 Alway ON]( - Hi i need to setup a sql server 2022 onprem replicated with sql always on availability group on azure. On prem do I need to setup a cluster or can it be a single vm? then replicate it to azure? canI use ASR to orchestrate recovery? I found some articlesthat says SQL AwaysOn (Recovery Plan […] [Best Practice for full backup and transaction log truncation]( - I am new to SQL Server DB. Could someone please let me know what would be the best practice to do a full backup and truncate the transaction log. If you could please let me know the strategy you are using in your company, that would give me some idea and help me learn from […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -