SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

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.com

Join 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. feed

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
SQL Source Control

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.

Foundry

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.

Featured Contents

 

Nuance of datetime data type in SQL Server

Leo Peysakhovich from SQLServerCentral.com

One of the most confusing data types in SQL Server is the datetime datatype. More »


 

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

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 »


 

Harmful, Pervasive SQL Server Performance Myths

Additional Articles from SQLPerformance.com

Aaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance. More »


 

From the SQLServerCentral Blogs - Who Left Those Old Components in My New Database???

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 »


 

From the SQLServerCentral Blogs - Testing SQL Server Access to a share with PowerShell using dbatools

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 »

Question of the Day

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

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

Featured Script

Remove SQL Comments

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.

SQL Server 2016 : SQL Server 2016 - Administration

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...


SQL Server 2016 : SQL Server 2016 - Development and T-SQL

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...


SQL Server 2014 : Administration - SQL Server 2014

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...


SQL Server 2014 : Development - SQL Server 2014

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...


SQL Server 2012 : SQL 2012 - General

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...


SQL Server 2012 : SQL Server 2012 - T-SQL

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...


SQL Server 2008 : SQL Server 2008 - General

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


SQL Server 2008 : Working with Oracle

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...


Reporting Services : Reporting Services

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)...


Programming : Powershell

'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....


Data Warehousing : Integration Services

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]