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

Daily Coping Tip

Start the week with some movement. Exercise in some way today

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.

Seriously Real Time Data Processing

There are many of us that work with systems where data is processed in real-time and then used to make decisions. These might be humans viewing reports and then taking action, or some automated system that might react based on a value changing. In many cases, however, the amount of data, timing in which to react with a decision, and the implications for mistakes aren't that critical. We have some leeway for the processing not being perfect.

For vehicles traveling at 180mph, the tolerance for mistakes is low, with the chance of a catastrophic crash looming constantly. That is what is happening with a competition at the Indianapolis Motor Speedway, where university students are competing to develop race cars that can move around that track at these speeds. This would be quite a challenge for vehicles moving around the track by themselves, but in this case, it's a race with multiple cars.

This might seem silly, but it's a step towards understanding just how much data needs to be processed and how the results can deal with the chaos in the real world. Each car is independent, so has to react to the other vehicles and make decisions on how to adjust its own operation in real-time, with a sub-second response to prevent accidents. This isn't different from the decisions human drivers have to make in a race, and there are plenty of mistakes that result in crashes. However, humans can think in new situations and react. They don't need to have every possible response programmed in.

These AI-driven race cars will be similar, but how well they perform remains to be seen. This is the type of test environment that will help us move forward in using technology and AI models in less constrained environments, like a public highway. Lots of technology was tried on race tracks before it became available to consumers, and I think this will make its way to retail cars as well at some point.

There are already some companies trying to build this into cars. Tesla famously has Full Self Driving, although this has been in beta for a long time, and its results are less than stellar in some cases. Waymo has been working on the problem, and I actually had the chance to ride in a self-driving Uber in Las Vegas, though that experience was less than thrilling. The driver had to take control a number of times, so this wasn't quite self-driving.

There is a lot of work still to be done here, and I don't know how quickly this will become safe enough for general driving. I suspect that we'll see this in very limited areas first, like a zone in a city that only allows these types of cars, or maybe specific highways, like HOV lanes. Somewhere the problem domain is simpler, with less decisions that need to be made.

There are already lots of safety features in modern cars that help prevent mistakes and accidents, but most of these are simple systems that aren't making decisions in many ways. Moving to more complex driving operations will require some heavy data gathering, processing, and analysis, something that should be of interest to data professionals. This is a problem domain that will be fascinating to watch in the next few years.

Steve Jones - SSC Editor

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

 
 Featured Contents

GoTo Looping

joseph.m.bonomo from SQLServerCentral

While not recommended, GOTO can be used to loop in some situations.

SQL Server Database Mirroring Inventory

Additional Articles from MSSQLTips.com

In this article we look at a PowerShell script that can quickly retrieve information about all databases from all servers that are configured to use database mirroring.

What is Redgate Deploy?

Additional Articles from Redgate

How Redgate Deploy will help you ensure that databases and applications can grow and develop in step, and to implement a workflow for delivery of database changes that is resilient, repeatable, fast and visible.

From the SQL Server Central Blogs - How to Fix SQL Database Error 8961?

nelsonaloor from PracticalSQLDba

Running DBCC CHECKDB or DBCC CHECKTABLE on a database may report error 8961. Such a situation could occur while changing the data type of a table column from “ntext...

From the SQL Server Central Blogs - Add DBCC INPUTBUFFER to Your Performance Tuning Toolbox

SQLEspresso from SQLEspresso

A command I like to use when performance tuning is DBCC INPUTBUFFER. If you have ever run sp_whoisactive or sp_who2 to find out what sessions are executing when CPU...

 

 Question of the Day

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

 

The FTS Catalog

I want to create a full text index on a table in my database. There are no FTS (full text search) indexes in this database. I think I need a catalog, but I am not sure. What should I do?

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)

Azure Data Factory Pipelines

How many pipelines can an Azure Data Factory have?

Answer: 1 or more

Explanation: There is no limit listed on pipelines in Azure Data Factory, but a data factory is listed as one or more pipelines. Ref: Pipelines and Activities in Azure Data Factory - https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities

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 - Development
Split column values to multiple rows - Hi, My requirement is to split columns [Owner],[PersonAttending],[Type] into multiple rows if more than one value is there for the column. Attached is the code snippet. Please help! Thanks, PSB CREATE TABLE #SplitColumnsToRows ( ID INT, Title nvarchar(1000), [Owner] nvarchar(1000), [PersonAttending] nvarchar(1000), [Type] nvarchar(500) ) Insert INTO #SplitColumnsToRows ( ID,Title,[Owner],[PersonAttending],[Type]) SELECT 1,'Title 1','Neil;Jennifer','Ronaldo;Ashok','End to End;BIN' […]
SQL Server 2016 - Administration
Disable Non SSL connection in SQL server - Hi, I have configured SSL certificate in SQL server and enabled Force encryption=yes. Still SQL server is allowing non SSl connection from Application. How to configure like SQL server should not accept non-SSL connections.
Error SPN GMSA compte - hello , I am checking the SQL log error of my server and I found this error for info I use a GMSA account to start the SQL service account SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN […]
How to tell if an SSL certificate is already bound - Hello experts, I want to see if an SSL certificate is already bound to SQL Server in order to know whether or not I need to restart the SQL Server service. I did the following: In SQL Server Configuration Manager, right-click on "Protocols for MSSQLSERVER" and select Properties. Click on the Certificate tab. Click the […]
Administration - SQL Server 2014
How can I check that SP3 is really installed? - A systems works with Windows Server 2012 R2 Standard On this system MS SQL-server 2014 (x86) Express version 12.0.2000.8 is installed. The service pack SP3 had to be installed. Now SQLServer2014SP3-KB4022619-x86-ENU.exe is installed without errors. But after this upgrade the version number is still 12.0.2000.8 I expect version number 12.0.6024.0 When I try to install […]
SQL 2012 - General
Let SQL profiler and Extended event can't capture the sql statement. - is it possible to Let SQL profiler and Extended event can't capture the sql statement? if not , is there any better  trick let user uneasily capture  the sql statements you execute? ( aside from encryption SQL scripts) thanks so much!  
SQL Server 2012 - T-SQL
Split String into columns - Can someone help me figure out how to turn this string: ' ;T41,Vending,9000011;T42,Laundry,9000012;T43,Car Wash,9000013;T44,Amusement,9000014;T45,Promotion,9000015;T46,Transit,9000016;T47,Other,9000017;T73,?,9000011' into a set of results like this?
SQL Server 2019 - Administration
Configure DBMail to send the email to a local folder? - Is there a way to configure DBMail to send the email to a local folder?
Availability Groups - Object Sync - Hi, I'm in the process of doing a comparison of all the options available: Scripts Integration Services 3rd Party Tools We will have hundreds of instances and thousands of databases so need something scalable! Thanks
Adding a surrogate key to a view - Hi there I need to add a surrogate key/unique identifier column to an exisiting view. I have tried using "Select ROW_NUMBER() OVER (ORDER BY CustomerId) as SurrogateKey From ..." as well as "Select CONCAT(CustomerId, ActivityId, CreateDate) As SurrogateKey From ..." as an alternative but both of these result in 152 rows being added to my […]
Login failed for user with failure to write agent job history to sysjobhistory - Good afternoon, Odd issue started happening a couple weeks ago where a server stopped logging job history and the the SQL Server Agent log is full of these two errors.  Jobs run and do what they are supposed to do, I am simply not getting a history log created. I have stopped and restarted the […]
SQL Server 2019 - Development
Create a View with Index - I am using a large Manufacturing Database and would like to create a number of Indexed Views in another Database that reference my manufacturing Database. I use a common table expression to produce a list of bill of materials but this slows down due to lack of an index - can this be done? Roberto
SQL Server 2008 - General
? on XML Data Parsing.... - Hi I ran into an issue parsing xml, Here is a sample Great Books Jon Smith 2001-12-28 23.39 This is a great book! Sad Emo Jones 15.25 This music is so sad!North America Joey Bagadonuts 2013-02-02 102.95 Trail […]
Integration Services
text column in date format in excel to datetime column in sql server via SSIS - Hi, I am trying to import an excel with a date column in it ( format - dd.mm.yyyy hh:mm:ss) . The column does not have any date specific custom formatting. It is general format only. The sql destination column is datetime. I have tried using data conversion as well as derived column to convert STR […]
SQLServerCentral.com Website Issues
Briefcase no working? - Hello, if  I add a forum's topic to my briefcase and then open my briefcase the page https://www.sqlservercentral.com/briefcase is loading and the items in briefcase showed for 1ms then hide and an empty Briefcase is displayed. It shows the text: "No items in briefcase". But when I view the page source I can find the links […]
 

 

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

 

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