| A community of more than 1,600,000 database professionals and growing |
| | AI Helpers or Replacements It's interesting to look at the data business and how companies view DBAs, database developers, BI developers, data scientists, and more. There are some companies that really see value in our services, and I'm grateful for that. I've been gainfully employed for well over two decades to work with data. There isn't much standardization in our jobs or what we're expected to do, but I've grown comfortable with that. That's one of the reasons the people working with me, my coworkers, are more important than the work. The work is the work. As our systems become more advanced, there is concern over how much less some of our skills might be needed with new AI type systems. Will the move to smarter systems mean there will be more opportunity for us? Or less? Certainly in the long term there might be less jobs if systems become really capable, but in the short term I don't think so. As much as Microsoft has improved SQL Server, and they've done great things with easier HA configs, the Query Store, Adaptive Query Processing (coming) and more, they aren't replacing many of us. Maybe a few, but I think there's still lots of technical work. Darmesh Shah wrote a nice piece on AI and how it will help many of us in our jobs, providing the easy information and guidance for us to focus our skills. He sees bots as helpers, which to me presents new opportunities to interact with and work with customers and data. We will find ourselves more capable with help from AI, not replaced. As we get better machine learning or other adaptive algorithms, we'll actually find new ways to work with data. This should provide us with new opportunities and new types of jobs that we might grow into. Plenty of people want to dismiss the data science jobs as a popular area where anyone can claim those skills if they know a statistical function and can query data in R, but there are real jobs in those areas, and there are opportunities in new companies that might not have existed in years past. There are going to be some amazing new ways that data and more intelligent algorithms will help us see our world in the future. There will also be scary ones, and many we don't know if we can trust. Somewhere in there, the world will become very, very interesting for those of us that work with data on a daily basis, looking for new ways to extract information from all the bits and bytes that we store. Once again, this is something I do look forward to as a data professional. 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.6MB) 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 | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more. |
| | Could you help with some research? The Foundry team at Redgate want to hear about your experience with audit and compliance. Fill in this short survey to help out, and also to enter their prize draw for a $100 Amazon gift card. Complete survey. |
|
|
|
| | | To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage. More » |
| Additional Articles from SQLPerformance.com Aaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance. More » |
| Andy Galbraith from SQLServerCentral Blogs Recently a client requested some new transactional replication publications on a relatively new pre-production server. The client has plenty of... More » |
| Rob Sewell from SQLServerCentral Blogs A good security practice is to backup our SQL Servers to a network share but not allow users to be... More » |
|
|
| | Today's Question (by Steve Jones): When I start SQL Server with a minimal configuration, which of these things are true? (choose 3) |
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: Administration. 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 | SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): What two ways can I assign the boolean value true to a variable in R? Assume I'm doing so with the variable x. Answer: x <- TRUE x <- T Explanation: You can assign the value TRUE to a variable in a few ways. The keywords "TRUE" and "T" are both valid ways, with the <- assignment. Note, that this also returns true: Ref: tryr.codeschool.com - click here » Discuss this question and answer on the forums |
|
|
| | Jordan Ryder from SQLServerCentral.com This script removes comments and handles complex nesting. A sql string can be passed in and the function will return the code but with comments removed. Example of complex scenarios that this function correctly handles: -- /* multi-line ignored /* --*/ this text is not a comment More » |
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums. XCOPY failing via xp_cmdshell - I am trying to copy files from our hosting site server to pur local server with XCOPY. If I log... Multi-Site Cluster SQL Server 2016 AlwaysON Infrastructure - Hello, I have two production site. I want to design a new SQL Server 2016 AlwaysOn Cluster for two production... Calculate business hours (working hours) between two dates (Old topic... Sorry in advance) - Hi All, I know this is old topic and there are thousand of discussions on this topics already. What I want to... Copy-Only backups in backup chain. - Hi All, I have recently migrated some SQL 2008 R2 databases to SQL 2014, one of the features I use quite... Tempdb allocation and Tempdb filling up - Hi, I have an odd situation. We have hosted our SQL servers on AWS (Amazon Cloud), and we have some overnight jobs... Auto Update Statistics - Hi I would like to understand when Statistics will automatically update? From what I read, it is based on modification of the... Improving performance using partitioning - Hi All, I have a few related tables that are becoming big in size and row count. The Header table has a... Driving me nuts: selecting valid timelines from several lines in a table - Hi all, I've been looking like crazy for answers, and although sometimes I think I might have found something, it just... Import Exports Wizard wont connect to database - Hi all I have a SQL2012 express on Win10 The SQL browser service is running The hidden flag is not set The firewall is... SQL Help - How do I get a list of all the DB names in the server and a list of SCHEMAS that belong to each DB - Team: The following SQL gives a list of DB names across the SERVER that I have access to . Works well.. This... There is insufficient system memory in resource pool 'default' to run this query. - Dear MVPs I am trying to run a script containing 500000 update statements similar to the one below: UPDATE dbo.MEMOPOOL_DATA SET... Parse numbers from Column - I have a sql table that stores weight in one column. How would I go about extracting lbs and ozs... Removing Reverse Duplicates - Hi all, I've been racking my brain all afternoon with this one. In their wisdom, the developers of this database many... Table size and indexes - How many rows does a table need to have before you start thinking about adding an index? Import from File - Hello, I've searched, and while there is some info, I've been unsuccessful as of yet. I'm able to do this in... how to limit table row and display remaining data in next column in sql - My table data. id clientname contactperson addr1 addr2 1 Jhon Mujeeb alld alld 2 J Anyway to connect to Oracle on the fly without tnsnames entry? - As the title indicates, I'm curious if anyone knows of a way to connect to an Oracle database from SQL... Is there a way to bring parameter back in a drop down selection? - Just curious, how many people here would need this function ? Like a drop down you can select which parameter (profile)... 'invoke-sqlcmd' is not recognized as the name of a cmdlet - Good day - I have been writing Powershell scripts to use Invoke-sqlcmd to complete some data tasks I need to do.... EXCEL HELL!!! - Please see the attached spreadsheet and please understand that when it comes to SSIS, I don't even qualify as an... |
|
| 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] |
|
|