Stairway to SQL Server Extended Events Level 2: Creating Basic Event Sessions in the UI (2021-11-24)

SQLServerCentral Newsletter for November 24, 2021 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Stairway to SQL Server Extended Events Level 2: Creating Basic Event Sessions in the UI]( - [Tracking SQL Server Configuration Across All Your Servers Using SQL Monitor]( - [Using Power Apps Patch Function with SQL Server]( - [From the SQL Server Central Blogs - SQL Bits is Looking for 20 Minute Sessions]( - [From the SQL Server Central Blogs - Quiz & answers for my “Auditing your data and data access” session.]( Question of the Day - [System Variables in ADF]( 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 - [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 Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -