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

Daily Coping Tip

Make a meal using a recipe or ingredient you’ve not tried before

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

A Strange AI Achievement

We are seeing AI and ML becoming used in more and more industries, but one that seems to be a place where it is embraced with some success. From speech recognition and transcription to analyzing imaging, computers have helped medical professionals improve the care they give to patients.

Just as CAD has helped manufacturers, AI systems are being used in medical research, trying to model and screen medications to try and determine which ones are potentially useful in treating various diseases. We also have used them to better tailor treatments for certain diseases, like some cancers. It seems that applying computing against vast troves of data is proving itself beneficial.

What if an AI were able to develop something new and it were awarded the Nobel Prize? That's the premise in a scenario published in the Economist. The article opens with the controversy of how the guidelines for the prize are interpreted, paving the way to award the prize to the AI. Perhaps even more interesting in the scenario is that the effort is the result of a poor software upgrade that allowed the AI to read more medical papers that it was previous given access to examine.

It's an interesting idea. Who gets the credit? Certainly, the humans that help train the model and put it to work deserve some credit, but they are really the assistants. If they were to use the prize for more research, do we think they could replicate the innovation? Maybe it doesn't matter. Not many people win the Nobel prize twice. Perhaps using the prize to continue allowing the AI to conduct research would make the most sense, though I don't know if the humans around the system would accept that.

I don't think AI systems are more intelligent than humans, but they can consider and try more possibilities than humans, given enough data. They might notice something that we'd miss, and they can remain more focused on a problem than we can. After all, we need to rest and care for our bodies.

I don't know if this will happen in the 2030s, as the scenario imagines, but I do think this is a possibility as we start to use computing to search for new innovations in research. I just hope that as these discoveries take place, they are used to better the entire world, and not just enrich a few humans.

Steve Jones - SSC Editor

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

 
 Featured Contents
Stairway to SQL Server Extended Events

Stairway to SQL Server Extended Events Level 2: Creating Basic Event Sessions in the UI

Erin Stellato from SQLServerCentral.com

In this Level, we'll walk through the basics of using the New Session dialog in the UI to create a new event session, define its events, actions and predicates, and establish a target for the session in which to collect the event data.

External Article

Tracking SQL Server Configuration Across All Your Servers Using SQL Monitor

Additional Articles from Redgate

The Estate Configuration reports SQL Server configuration across all your servers, so you can quickly investigate ad-hoc or unauthorized changes to any settings that might affect their performance, stability, or security.

External Article

Using Power Apps Patch Function with SQL Server

Additional Articles from MSSQLTips.com

In this article we look at how to create a basic Power App that allows saving data to a database table.

Blog Post

From the SQL Server Central Blogs - SQL Bits is Looking for 20 Minute Sessions

Steve Jones - SSC Editor from The Voice of the DBA

As Simon Sabin (SQL Bits co-founder) pointed out recently, the 2022 SQL Bits conference is looking to get 40% of their sessions to be 20 minute talks. He did...

Blog Post

From the SQL Server Central Blogs - Quiz & answers for my “Auditing your data and data access” session.

Kenneth.Fisher from SQLStudies

I was honored to speak at Pass Summit last week (Thanks again Redgate), and if you’ve ever been to one ... Continue reading

 

 Question of the Day

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

 

System Variables in ADF

How do I access a system variable, say the Pipeline variable, in Azure Data Factory (ADF)?

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)

The Row-Level Security Function

What type of function is used in Row-Level Security?

Answer: a table-valued function

Explanation: A table-valued function is what RLS needs. Ref: Row-Level Security - https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15

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 - Administration
Turning Clustered index into PK without creating additional index? -   Adding PK to existing table like in the below example with existing Clustered index automatically creates an index on PK column. But I already have a CI index there, we don't want another one. is Turning Clustered index into PK without creating additional index possible via T-SQL? create table Z1 (id int not null, […]
SQL Server 2016 - Development and T-SQL
Error handling/notification with a sql agent job - I have a stored procedure that is returning a set of data from a table and then is populating a summary table with that data. if sussful I am deleting all the data from the first table. if there is an error I do not want to delete the data and notify me if it […]
find which field and table blank or null field - I'm trying to turn this query into something that is more dynamic. I would like it to be able to grab a set of tables(example like sales%), and be able to tell me which table and field meets my criteria. then dump that record into some sort of generic error table. Thanks.   DECLARE @tb […]
Find the multiple records by max date - I have a table with multiple rows for a "Shelf Location" with the same date. example shelf 0095 has 10 records for 11/12/21 13:50:31.012 shelf 0095 has 15 records for 11/15/21 17:50:31.012 shelf 0145 has 5 records for 11/12/21 13:50:31.012 shelf 0145 has 3 records for 11/19/21 17:50:31.012 I want to select max date for […]
SQL 2012 - General
How to add top 1 row as header on SQL server as extra row ? - I work on SQL server 2014 I face issue but I don't know how to solve it I need to add columns header as first row on table I Try as below but i get error Msg 213, Level 16, State 1, Line 1 Column name or number of supplied values does not match table […]
SQL Server 2019 - Development
How to use a single stored procedure with one to 10 parameters - I would like to create one stored procedure that can handle from one to 10 parameters.  Using the sledge hammer approach, I created 10  stored procedures;  each one handles the number of parameters requested.    For example, if I wanted to look at the values for 1 tank, I would call the stored procedure that […]
Splitting one wide column into serveral different ones - Ahoi, i have a request to deal with that is in my opinion total bullshit, but thats besides the point. The data source provides me with a variable layout that depends on the column length (changing the type or structure of this column is out of question). This leads to the following issue: I have […]
SQL Server 2008 - General
Sql 2008 export table csv with headers and data ... - Hi guys, I'm really a newbie in SQL, I hope you can help me with this. I need to export a table in SQL 2008 with headers and data delimited with | ( pipes ), but some information inside of this table have , ( comma ) and CR or LR, it's possible to put […]
SQL Server 2008 Administration
system runs slowly, but SQL server can't use the RAM over 74GB? - My OS is windows server 2008 R2 Enterprise, SQL Serer is 2008 R2 Standard edition, the installed is 128GB, and RAM identified by windows is 128GB, there are about 100 users using system at the same time every day, many functions of system are running slowly, I set SQL Server maximum RAM 120GB, I observed […]
SQL Azure - Development
Are there any read-made example databases I can use for a new Azure SQL Database? - (This post might be in the wrong place. Please forgive me if this is the wrong forum to ask this question.) I'm about to start writing a new application, to prototype some ideas. We want to have a database in Azure, so Azure SQL Database seemed the right choice, in this case. At this point […]
Reporting Services
Report Viewer Paging Problem - Hiya, I'm using PowerBI on Premise Report Server and Visual Studio 2019. In development I can create reports that preview fine on separate pages. When they are promoted to live,  the Report Viewer gets stuck on 0 pages and I cannot navigate them. After a while (several minutes) the Report Viewer sometimes comes to life […]
Is it possible to assign a random color to a font? - Hello, I am working on a report for which one of its requirements is that at the beginning of each year, the font color in one of its sections changes automatically. I am not sure if this is possible, I have search, found and read a few examples and they all have the colors to […]
Integration Services
Can an SSIS package run without Integration Services being installed? - First off, its been over 12 years since being asked to deploy an SSIS package.  I remember that we used to run them using dtexec.  However, I'm not having much success. I've reviewed this article referenced in another thread. That's only 9 years old.  I was optimistic that switching from the project deployment model to […]
Unicode data in sql server - Hi, I have a csv file which we export from Salesforce and flows to downstream sql server. So, the data flow is as follows: Salesforce --> csv --> Sql server The issue is that  we have some unicode data in Name column  ex; "Zuivelcoöperatie FrieslandCampina U.A. - NL" but while exporting to csv it comes […]
Design Ideas and Questions
Help with star Schema - Hello I am just starting to learn about database designing, so as a start I am trying to create a fulfilling Star Schema. I work for a utility company, so some of the values or going to be MWH, Gj, m3 etc. I've made a description trying to describe my thoughts behind the grains and […]
 

 

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

 

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