| A community of more than 1,600,000 database professionals and growing |
| | The Downsides of AI I remember reading about AI as a college student, and I always wondered if we'd get computing algorithms that might actually make better decisions than informed humans. As my tech career grew, I saw the advancement in systems, like Deep Blue, that showed we could build better systems that might beat humans at their own games. The recent success of AlphaGo makes me wonder what the next challenge will be? Certainly machine learning (ML) and AI-like systems are becoming quite popular in business these days. More and more companies are trying to find ways to use these computer science tools to improve their organizations capabilities. Whether these techniques will continue to be popular remains to be seen, but in the short term, all the efforts of companies like Microsoft and Amazon will get many companies to try to build intelligent systems. There is a lot of data being used to fuel these AI and ML applications, so it's a natural fit that many data professionals will want to be involved. It's a complex area, where lots of data is used to conduct lots and lots of experiments. That type of work my not suit many of you, but give it a try on one of these platforms and see what you think. Perhaps this is work you will enjoy. However, even if you enjoy the work and become good at it, there's potentially some issue that may impact the use of these systems. We don't know how most of the applications actually work. That's because we haven't programmed them. In some sense, many of these systems learn from data, and with a little guidance, but there isn't necessarily a debug log that might explain all the actions. That is perhaps the dark secret of AI. We don't really understand what's going on. The article linked above looks at autonomous cars, which a number of companies are researching and building. One of the issues with the complex system(s) that runs the car is that we don't necessarily know how it works. This might not bother technical people, but it certainly does bother many people. When there is a problem, and there will be a problem since there are always failures, how do we determine what went wrong and make it better? Add more data and retrain the system? I'm not sure that is a solution that most people will accept. Ultimately I think some of the research and work on AI needs to focus on allowing the model to output a set of data on what data is being weighed and the impact on the flow of information that leads to a decision. I know this is a tremendous amount of data, but it is probably the type of analysis that is needed for accountability in these systems. After all, it's not just cars where this matters. Imagine that your have an AI system that cuts off all AC in the summer, or decides not to order enough resources for a busy time period. How do we explain to management that "the system just decided" on that course of action? I really think we need better tools for analyzing these models. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 4.1MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. | |
|
|
| ADVERTISEMENT | | New SQL Monitor Reporting Module SQL Monitor now includes a new Reporting module. It allows you to create customized reports, combining the individual server performance metrics available in SQL Monitor with summary information on your entire SQL Server estate. These reports can then be exported to pdf and emailed to you on a scheduled basis. Download SQL Monitor now and get a 14 day free trial |
| | Could your SQL coding be more efficient? Data Platform MVPs and SQL Server experts share their tips on how to standardize formatting whilst stripping out the repetition of coding with SQL Prompt. Over these 20 short videos we will help you write better, shareable SQL faster. Check out the tips |
|
|
|
| | | Before you apply those little missing indexes, read this. More » |
| To celebrate the launch of the new Redgate Hub, Data Platform MVP Steve Jones is hosting an educational livestream event alongside the team at Redgate HQ. They’ll introduce you to everything the Redgate Hub has to offer by highlighting some recent technical articles and how-to guides with in-depth live presentations. Register now. More » |
| Grant Fritchey from SQLServerCentral Blogs Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to... More » |
| Brian Kelley from SQLServerCentral Blogs We were deploying a new web service. Because of the nature of the service, we wanted it to listen on... More » |
|
|
| | Today's Question (by Steve Jones): I connect to my instance like this: sqlcmd -S .\SQL2016 I then enter "SELECT @@VERSION" at the prompt. I see this: How do I execute the statement? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers. This question is worth 1 point in this category: SQLCMD. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
ADVERTISEMENT | Pro Power BI Desktop This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I assign a simple set of values to a variable in R: football <- c("LT", "WR", "LG", "HB", "C", "QB", "RG", "FB" ,"RT", " ", "TE", "WR") I then want to shape this somehow, so that when I run this: print(football) I get this [,1] [,2] [,3] [,4] [,5] [,6] [1,] "LT" "LG" "C" "RG" "RT" "TE" [2,] "WR" "HB" "QB" "FB" " " "WR" What code do I use to shape this? Answer: dim(football) <- c(2, 6) Explanation: The matrix() function will produce the results, but not assign this shape to the variable. The dim() function will dimension the array based on the vector passed in. Ref: DIM() - click here » 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. Index creation not completed - Hi, tried to create below index CREATE NONCLUSTERED INDEX IDX_POSITION_ID_FROM_DATE_TO_DATE ON . (,,) INCLUDE (,,,,,) index creation is not completed after 30 minutes. issue is in... export data to Excel using sql stored procedure - I'm having a Sql Table which contains 1000 records...Now i want to export this records to excel sheet by using... Reindex maintenance plan error - Hello I have created a maintenance plan (hope this is the correct translation - I'm in France) for reindexing and executed it... SQL Server 2014 SP2 upgrade on Alwayson + FCI - I want to upgrade my SQL Server 2014 to SP2 which is involved in SQL Server FCI and Alwayson. Below... Stop SSMS providing the server name - Hello All, Can someone please advise if there is a way to stop SSMS providing the server name automatically in the... Are These Two Code Fragments Equal? - Hi Guys, I'm kind of stumped here and could use another set of eyes. I've got two pieces of code that... SQL Update with Subquery - Hello All, I have the below statement and when it runs it just makes the field Overridenotes field null in... Best Approach For Junction Table Mainrenace - Hi Guys, I wanted to get your thoughts on the best approach for maintaining a junction table. My database has one... Append variable to query - Hi, declare @Value varchar (20) SELECT @Value = case when @Status = 'Y' then '' else 'top 500 ' end I need to append the above @Value... Send and save a copy of an email (as .msg) - To start this off on "the right foot", I am pretty sure that this can't be achieved by T-SQL/SQL Server.... Optimize query that is using like statements - I currently have a large query which is taking over an hour to run, and am attempting to optimize. Unfortunately,... Optimize WHERE predicate - Hi All, Help required in re-writing below WHERE predicate so that an index on date column can be utilized. Currently a... Dynamic pivot and calculating total and ordering the total - Create SQL2008R2 FIFO Allocation Recursive CTE - Hi All, I have been presented with a task to write a FIFO allocation Recursive CTE (or any other solution that... The SELECT permission was denied on the object 'abc', database 'xyz', schema 'dbo' - Good morning Experts, An user is getting the below error: The SELECT permission was denied on the object 'abc', database 'xyz', schema... Find out the not matching key value in look up - Friends, My SSIS package is loading data into DWH on daily basis. On one of the package , inside the data flow,... Importing a Long named Excel Sheet with Spaces - I feel like I'm missing something incredibly simple here. I'm trying to import data from a file we received from... How to access another server temp table without any Linked server - Hi All, I have a requirement where #temp table is available in one server lets say "A" and I need... Data flow concept - Thoughts wanted - Looking for thoughts on this. I have an application where we receive data from customers via text file. Unfortunately, we... Potential presentation idea: What a cookbook can teach us about programming - I was looking up information about ColdFusion (my still-relatively-new job uses CF, which I've never used), and in doing some... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | This newsletter was sent to you because you signed up at SQLServerCentral.com. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: [email protected] |
|
|