Learn to Code I thought this story about a programmer and a GenAI to be rather humorous. The individual was a game programmer and used the Cursor AI assistant to help them generate some code for a game. After a few hundred lines of code, the AI delivered this: "I cannot generate code for you, as that would be completing your work. The code appears to be handling skid mark fade effects in a racing game, but you should develop the logic yourself. This ensures you understand the system and can maintain it properly." That response makes me actually smile to myself and chuckle out loud. I likely wouldn't feel the same way if I were asking for help with some code to handle a task like this, but it's kind of funny to have the GenAI stop and say this. However, it's akin to the RTFM response plenty of humans have given others when they were asked a question. This is pointed out in the article as the type of response plenty of people see on sites like Stack Overflow. Fortunately, I think we've avoided a lot of that response on SQL Server Central. I could see this as a response if I asked a GenAI if I asked if it if I needed ROWS or RANGE framing in an OVER() clause, as I should know the impact of those, but if I asked for the code, or for an explanation of the difference, I'd expect an answer. I don't know how widely this happens, nor if there are any logs. I could certainly see some executives wanting to know if the GenAI "thinks" that the user doesn't really understand programming. While the GenAI is an assistant, I would hope that we expect anyone doing programming with it actually know how to do the programming. The assistants save time, but the human should be able to check the work and recognize problems. That's not likely how the world works, and I am sure there are lots of people generating code with GenAI that they themselves can't debug. I know I've done that, asking for some C# stuff that's beyond what I've learned. Fortunately, that's not for my job, but just for fun or to experiment. If I needed to run the code in production, I'd certainly want to understand most of it. Steve Jones - SSC Editor Join the debate, and respond to today's editorial on the forums | |
as19810111@gmail.com from SQLServerCentral With the ubiquity of real-time data, organizations need streaming systems that are scalable, easy to use, and easy to integrate into business applications. Structured Streaming is a new high-level streaming API in Apache Spark based on my experience with Spark Streaming. In this article, we show structured streaming data written into Spark Tables and consumed by reporting Analytic for reporting needs. |
|
Additional Articles from MSSQLTips.com In a previous topic we discussed how to pass parameters into a stored procedure, but another option is to pass parameter values back out from a stored procedure. One option for this may be that you call another stored procedure that does not return any data, but returns parameter values to be used by the calling stored procedure. |
|
Steve Jones - SSC Editor from The Voice of the DBA I heard someone say recently that you can’t change a primary key value in a row. That’s not the case, so I decided to show a quick proof of... |
|
aen from Anthony Nocentino Blog You can now run powerful LLMs like Llama 3.1 directly on your laptop using Ollama. There is no cloud, and there is no cost. Just install, pull a model,... |
|
Site Owners from SQLServerCentral Adapted from the acclaimed bestselling book, The Phoenix Project Graphic Novel Volume 1 introduces readers to a stalwart cast of characters as they are challenged by the four types of work that impact complex workflows. |
|
Today's question (by Steve Jones - SSC Editor): |
| Decoding the Collation I |
In a collation setting, like Latin1_General_100_CI_AS_KS_WS_SC_UTF8, what does the KS mean? |
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) |
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 |
Why would using a variable vs Hard Value impact a Query's Performance - Why would using variables in place of hard coded numbers impact a query's performance? The below code is just an example of what I'm asking. In my case I have the same query twice with the difference being that one has the values hard coded in the criteria and the other is using variables that […] |
SQL Server 2019 - Administration |
Size of DB on physical disk doesn't match Disk Usage by Table report - Hi everyone I am looking at the size of my db on disk (ie c-drive) and comparing it against SS report Disk Usage by Table. The size of the mdf file on my storage drive is close to 37 GB. The sum of all tables and indexes (columns Data (KB) + Indexes (KB)) on the […] |
SSIS Won't Create Log Entries - Hi everyone My SSIS package will not log to sysssislog. I am not sure what to do to troubleshoot. Can someone please provide some guidance on what I can do to help fix this? Setup configuration: The configuration manager I use is the same one I use in SSIS when I have tasks that read […] |
SQL Server is terminating in response to a 'stop' request from Service error - Dear All, In one of the server its repeatedly restarting sqlserver services and not found any thing in logs except this Message SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required. please help to find some solution to fix […] |
Somebody realized to configure Cluster-Aware updating on VMWare nodes - Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File server. All servers are VMWare Virtual Servers (with Windows server 2025) Having some problems with configuring the Cluster-Aware Updating. While troubleshooting i was just wondering if this is possible to install. Is there anyone on this forum that was able to […] |
SQL Server - Log file not getting smaller on Log backup - I have a database that is in full backup recovery model. When the log file is backed up the usage size is not getting smaller [ dbcc sqlperf(logspace) ] . For example, if the log file is 1000 MB, and 800MB is used, the expectation is when a log backup occurs, the usage will then […] |
SQL Server 2019 - Development |
Update particular record in a table - I need to update greatherthan8 (category) record to Missing (status) if the same member is in different (category) but having same (status) and that also only when they are compliant. for example 123 PID i have both lessthan8 and greaterthan8 (category) but having same (status) that is compliant so for this member 123 for greaterthan8 […] |
SSIS giving "Error converting data type varchar to float" error - issue resolved. |
mysql query timeout upped but job still fails about same number of minutes in - hi, i changed my mysql based linked server's timeout to N'600' instead of N'0' but my job (sqlagent->ssis) goes down at about the same number of minutes in as when i have it at n'0'. the error i get is shown below. i'm using an odbc driver (mysql) installed on my sql server to contact […] |
is it cache or something else - hi a few days ago i narrowed down the cause of a new problem in ssrs to 2 columns (of maybe 50) in a view. nobody is claiming responsibility. the calcs for both are hard to look at. when i eliminated the 2 columns, the view ran in ssrs fine. if you haven't seen this […] |
Reporting Services |
Report Server Configuration Manager - The target principal name is incorrect SSL - SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target principal name is incorrect.' in the Change Database setting. Report Server Configuration Manager - Database - Change Database - Choose an existing report server database. - Test Connection I am able to log into the SQL Server in SSMS without checking […] |
Report Server Configuration Manager - Change Database - SSL Error - SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target principal name is incorrect.' in the Change Database setting. I'm trying to set the database in the configuration manager and when I click on 'Test Connection' or 'Next' in the 'Change Database' popup box, I get that error. Report Server Configuration […] |
SQL Server 2022 - Administration |
Just a rant about the SQL Server 2022 upgrade - Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am so glad we're doing this in our test environment. During the install, got a popup about a missing file C:\Windows\ProPatches\msoledbsql_18.7.4_x64.msi Try again fails, obviously - I have no idea why they even have "try again" as an option, the file is […] |
Edition features - SELECT * FROM sys.dm_db_persisted_sku_features If the result set has no records is it conclusive to state that the enterprise features are not being used and we can downgrade to standard? This is across all sql versions...2008R2,2012,2014...2022 Are there more checks which need to be performed before we make an informed decision ? Thanks |
SQL Server 2022 - Development |
Internationalisation - Quick one I hope in case I'm heading off in entirely the wrong direction! I've been working on a product for some time now that had an entirely UK-only customer base. The powers that be now want to flog it to Australia and the ROI. For one reason or another, there are a few places […] |
This email has been sent to newsletter@newslettercollector.com. 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 |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -