Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

AI In the Nov 2023 Enterprise

AI is everywhere. I can't seem to get away from stories on the technology in 2023, and while I don't know that I've found it that helpful, I keep looking at it because it's becoming a pervasive technology that most enterprises will experiment with in some way. There is a look at generative AI in the Enterprise in the O'Reilly Radar, which tracks how technology is changing and influencing the world.

The report talks about most of the respondents to a survey using AI, which makes sense as the people responding likely have some interest in the technology. I always take these trends with a grain of salt as people who are busy and not interested might not respond. Only a small percentage of uninterested people will actually answer these things.

As I look at the numbers with that in mind, I find it interesting that about half of the users think AI will lead to greater productivity and a small number (4%) think this means less headcount. However, only a minority (41%) have been using this for over a year. That likely means in most cases that people are experimenting like I am. This isn't a pervasive technology in the enterprise, though I'd argue that while DevOps might be in use in most enterprises, I wonder if it's in use in most projects at most enterprises. Culture change is hard for most people and I still meet lots of people who aren't trying to get better at building software.

The big challenge in many companies is finding appropriate business cases. I think that's my struggle as well, in trying to think about how to use AI to write or build code, I struggle to think of how to prompt or what to prompt. Often by the time I define the problem, I can just write the code. If I were scaffolding out basic classes or tables, maybe I'd feel differently, but as our CTO put it, we spend most of our time figuring out the problem, not writing the code. There are legal concerns, but those are from a minority of respondents. I have a meeting with our legal department soon, which will help me iron out some of my concerns and get guidance.

Interestingly, 77% of people are using AI in programming, with about half of those using it for work. I don't know if we've done a good job understanding the IP/copyright issues here, so that's surprising. I would guess in many organizations that don't sell software, they don't care about this at all. If they get code from an AI that was copied from somewhere else, if it works, who cares?

I find that much of the code generated isn't great. It's junior developer level, which might not matter to many organizations. After all, they employ junior developers, and some employ senior developers with 6 months of experience 10-20 times over who write that level of code. If the AI does it faster, all the better.

I think AI is a technology that is going to impact our lives as technical and data professionals. Whether you use it to write code or use it as a glorified search engine, it's a tool that you want to understand and develop some skill with. Writing prompts and learning how to navigate an AI system is helpful. If it actually gives you something useful, even better. And if you learn more about building models and prompt engineering, you might find yourself with some interested opportunities in the future as I expect those jobs to grow in number across the next few years.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
SQLServerCentral Article

Why Don't You Upgrade in Place?

Andy Warren from SQLServerCentral

Is there a reason to upgrade your SQL Server in place instead of building a new instance? Andy Warren has a few thoughts today on why this might be the right choice.

External Article

Sending resource alerts on Managed Instance using db_mail

Additional Articles from Microsoft MSDN

One of the biggest issue that you might experience in Managed Instance is reaching storage limit or finding out that you don't have enough CPU. In this case you would need to get the bigger instance; however, this is not instant operation. In this post, you will see how you can monitor resource usage and send email alerts if there is a risk that you might reach the limits.

Blog Post

From the SQL Server Central Blogs - You should be running on SQL Server 2022

Randolph West from Born SQL with Randolph West

It’s me again with my apparently semi-annual blog post. This time we’re going to talk about which version of SQL Server you should be on, now that we’re at...

Blog Post

From the SQL Server Central Blogs - Extended Events in Azure Data Studio

hellosqlkitty from SQLKitty

I know I can use extended events (xevents) in Azure SQL DB when in SSMS, but I wanted to learn how to use them in Azure Data Studio (ADS)....

Expert Performance Indexing in Azure SQL and SQL Server 2022

Expert Performance Indexing in Azure SQL and SQL Server 2022

Site Owners from SQLServerCentral

Take a deep dive into perhaps the single most important facet of query performance―indexes―and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other […]

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Parameter Defaults

I have a T-SQL stored procedure that looks like this:
CREATE PROCEDURE dbo.AddTogether @a int
                                  , @b int = 1
AS
BEGIN
  -- Declare a variable to store the result
  DECLARE @result INT;
  -- Add the two parameters and assign to the variable
  SET @result = @a + @b;
  -- Return the result
  SELECT @result;
END;
Where can I query the DMVs to get the parameter defaults? (null for @a, 1 for @b)

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)

Statistics Sampling Options

I want to create statistics on a column that I know will be used for querying filtering. However, this is a large table and I don't want to sample the entire table. What are my options for setting a limit on how much data is examined to create statistics?

Answer: You can specify a percentage or number of rows

Explanation: The options for sampling are a percentage from 0 to 100, or a number of rows from 1 to the number in the table. Ref: CREATE STATISTICS - https://learn.microsoft.com/en-us/sql/t-sql/statements/create-statistics-transact-sql?view=sql-server-ver16

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
Arctic Wolf flooding SQL error log - Hello experts, I am not sure if anyone uses Arctic Wolf for a security tool, but we recently implemented it and one thing it does is penetration testing and vulnerability scanning on our SQL Servers. Our IT team has this turned this feature on as they want to make sure things are secure, but it […]
SQL Server 2017 - Development
Query - ServerName DatabaseName DatabaseSize(MB) Date Server DBName Size Date A DB 110 6/1/2023 A DB 113 7/1/2023 A DB 118 8/1/2023 A DB 130 9/1/2023 A DB 120 10/1/2023 A DB 140 11/1/2023 A DB 143 12/1/2023 A DB2 1110 6/1/2023 A DB2 1113 7/1/2023 A DB2 1118 8/1/2023 A DB2 1130 9/1/2023 A DB2 1120 […]
SQL Server 2016 - Administration
emergency!!! RecoveryPending how to fix it? - How to fix Recovery Pending State in SQL Server Database,please help
SQL Server 2016 - Development and T-SQL
housekeeping of millions of records on everyday basis - Hello!! We are building our system that will be up and running for 24x7 365 days. the data will be generated in millions each day. Kindly help with the best practices material where in we can implement smooth house keeping processes on each table so as to not to load the tables as well as […]
send csv file or txt file to sftp server - Hello Can someone help me with code to send file to sftp server please: Here is my code: # SQL Server query $Query = "SELECT  name from tblName" $SqlConnection = New-Object System.Data.SqlClient.SqlConnection $SqlConnection.ConnectionString = "Server=CWR-PP02;Database=testdb;Integrated Security=True" $SqlCmd = New-Object System.Data.SqlClient.SqlCommand $SqlCmd.CommandText = $Query $SqlCmd.Connection = $SqlConnection $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter $SqlAdapter.SelectCommand = $SqlCmd $DataSet = […]
SQL Server 2019 - Development
Validation of special char and replace for the good one - Hello I need help on how to do this more efficient. I will need to write a store procedure to validate an address which contains special characters Address is like : Street : Las Ñipas 4264 So i need to remove the Ñ and replace it for N I was reading to use collate SQL_Latin1_General_CP1253_CI_AI […]
Query to get the previous row from the row selected - Hi I have payroll detail table in which I have payroll details id and an employee id (foreign key from employee table). My requirement is, when a row is selected for a particular employee, I want to get the value from a the previous row. For example if I have 3 employees and each have […]
How to write to a file from SQL Server running on Docker Container on Linux - So we have a SQL Server database running in a Docker Container on Linux There is a stored procedure which will take in JSON as a parameter and extracts data out into a table called dbo.BCPOutput Now I can run this from SQL Server Management Studio (in SQLCMD mode) :connect 217CAS -U sa -P xxxxxxx […]
SQL Server 2008 - General
Merge Replication SQL 2008 (10.0.6556) - downloads slow and behind - Merge Replication SQL 2008 (10.0.6556) - downloads slow and behind I am working on newly virtualized sql cluster with sql 2008 and merge replication with replication of many tables on a large database (multiple TB data file).  Recently, the merge replication of one of two pubs for it started to appear to only perform uploads […]
SSRS 2012
SSRS Open link in new tab - Hello! I have a report that lists all reports in folders on the report server, if you click on the report name I want it to open a new tab with that report. So I am not sure where I am going wrong. I am building my URL link to other reports on the server […]
Analysis Services
Calculated Time Periods Hierarchy - Please help me understand why I am getting the following error: "A set has been detected that can't contain calculated members." I have Attributes "Dates" and Hierarchies  "Calendar" (YearID/QuarterId/MonthId/dtDate). I've created  Calculated Member a "Current Month" for the parent hierarchy «Dates.Calendar.[all]». CREATE MEMBER CURRENTCUBE.[Dates].[Calendar].[All].[Current Month] AS StrToMember("[Dates].[Calendar].[Month Id].&[" + Format(now(), "yyyyMM") + "]"), VISIBLE = […]
Calculated Time Periods Hierarchy - please help me figure out why I'm getting the following error: I need to create Calculated Member for "yesterday", "current month", "current year", but but I keep getting an error message please help me figure out why I'm getting the following error: "A set has been encountered that cannot contain calculated members." I have Attributes […]
SQL Server 2022 - Administration
Moving database servers - IP address change - listeners - Hi, We will be moving our physical database servers to a new location. Prior to the move, new IP address for all the SQL servers will be changed/updated.     Are the IP address listed above for the cluster server? After the servers are moved will I need to change the IP address for the […]
how to install smo in an offline machine - hi,   how do I install smo in a offline machine https://www.nuget.org/packages/Microsoft.SqlServer.SqlManagementObjects#usedby-body-tab Install-Package Microsoft.SqlServer.SqlManagementObjects -Version 170.18.0   PS C:\Users\Administrator> Find-Module -Repository smo WARNING: The file extension 'C:\Packages\nuget.exe' is not valid. The required file extension is '.nupkg'. Version Name Repository Description ------- ---- ---------- ----------- 21.0.17224 SqlServer SMO This module allows SQL Server developers, admin   […]
SQL Server 2022 - Development
Replication for archive server with longer retention period - I want to set up SQL Server transactional replication from a main SQL Server to an archive SQL Server. The archive will contain historical data and have a retention period much longer than the main server. Data will be purged by application code on both the main and archive servers, and the archive will be […]
 

 

RSS FeedTwitter

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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -