| A community of more than 1,600,000 database professionals and growing |
| | Automation at Work I do worry about the future of work for large sections of people. When I read pieces like this one in the Atlantic on automation, there are two things that come to mind. First, we are mindlessly sticking with 19th century models of work in many cases. Second, there are opportunities that could dramatically utilize the leverage of computing power to reduce our need for humans in many cases. Far too often I've seen processes and procedures in place that exist strictly because of historical precedence. We developed some way of working, likely because of expediency. We needed something done, so we found a way for a human to do it. We continue to do it that way, often because of a factory mentality. We don't trust workers, who come and go, to handle the process correctly, so we specify a way of doing things that we know works. Even if it doesn't work well. What's amazing to me is that many of us still do this in technological jobs. I find lots of DBAs and infrastructure people that still do an amazing amount of manual work to check logs, jobs, backups, etc. They avoid automation for a variety of reasons, but often because of laziness and fear. They don't want to think and put time into changing a process, both avoiding coding as well as asking permission. They also fear for their jobs, as shown in the article. Automate too much and maybe the company will replace you with a less skilled, far cheaper worker. Perhaps I'm an outlier, but this has never been something I've seen in my career. When I automate things and free up time at work, I don't sit and browse Reddit play chess, as a few profiles from the article show. Instead, I'm more like Gary. I look for, and find, ways to improve other aspects of the company. I help others. I provide more "value" for my salary. This has worked well, even in companies that had a culture of "just do your job.". There are always a few managers that want thinkers and doers, not just people that mindlessly move through each day. Automation is coming, more and more every day. As I look at the evolution of the data platform from Microsoft, the growth and capabilities of cloud services, and even the amazing third party products that free up our time, I know that the bar is constantly raising for the skills we require. What we might have expected only senior level people to do in 1999, we expect juniors to know now. Not everywhere, and certainly plenty of older management is stuck with their historical views of "just do this job," but times are changing if you seek a new employer. I want to see more scripting, more PowerShell, more Bash scripts, more DevOps pipelines, more systems doing tedious work. That's because many of our scripts and our flows are still rudimentary. They're basic, expecting the happy paths to work, with limited testing and error handling. Instead, I'd like to automate myself out of work, but then find ways to better script more robust processes, with ways that double check my code is working, and alert me when it's not. With new responses that are more intelligent than a simple IF..THEN statement. We have lots of room to improve in how we structure systems and code, whether in application development or infrastructure management. Hopefully we'll all start to embrace more automation, and look for new opportunities rather than being fearful of change. 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.8MB) 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 | | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
| | Database DevOps Demo Webinar Learn how to automate your database deployments alongside your app code in this free demo webinar. Register now |
|
|
|
| | | Mike Hinds from SQLServerCentral.com Learn a few possible solutions to a frustrating issue when you attempt to patch a SQL Server installation. More » |
| In order to get the best out of SQL Provision, it’s a good idea to think about how it would best fit into your workflows and network architecture. We’ve put together a set of guidelines which can help you to optimize efficiency, performance, security, and reliability, and recommend that you consider these when planning a proof-of concept or rollout of SQL Provision in your organization. Read the How To Guide. More » |
| Additional Articles from Brent Ozar Unlimited Blog When I look at a SQL Server, one of the first things I check is, “How much memory does this thing have relative to the amount of data we’re hosting on here?” I’ve long used some seat-of-the-pants numbers, but armed with data from SQL ConstantCare® users who opted into public data sharing, let’s do a little deeper analysis. More » |
| Andy Warren from SQLServerCentral Blogs Part of the decision of setting up a non profit is committing to a bit more than minimal effort when... More » |
| taboggiano@gmail.com from SQLServerCentral Blogs In the past 5 months I have started two different jobs, so that leaves it up in the air as... More » |
|
|
| | Today's Question (by Kendra.Little): How can you start perfmon.exe in a way that it remembers the counters that you select, and will display them the next time you open perfmon.exe in the same way? |
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: PerfMon. 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 | Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have some code that runs in various client databases. For the OrderLine table, I want to ensure I know which client database I'm running in. In the context of the Acme database, I run this: SELECT PARSENAME('dbo.OrderLine', 3) What is returned? Note: the 3 represents the database name. Answer: NULL Explanation: PARSENAME() returns the value of the string that is passed in as the object name. Ref: PARSENAME() - 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. blocking for same query on user DB - Hello Gurus, In Production I noticed one issue and need your help. On the web page when we click on a... Fragmentation - Is fragmentation is there on a table where it does not have any index if yes what are the reasons... In Place migration - Hi, in my enviornment active passive cluster is running with SQL server 2014 sp2 and now we are planning to upgrade... Request code review for UDF: ContainsControlChar and CleanString - Hi, I have a lot of dirty data in my upstream data sources. I've written two UDFs to assist in my... Restoring with multiple BAK-files (with multiple CPU-cores) - Hi all, I do have a question about restoring databases: SQL server uses just on CPU-core when performing a regular backup to... Where clause on a bit column - Hi Experts, I want results based on a where clause , all columns in the where clause is bit.I want the query... Is Mirror upto date - Hi there, Is there a script that will tell you how up to date (or not) a Mirror is with the... Case when inside of partition by? - Hi, I have the following situation: CREATE TABLE #TAB1( ID INT ,MY_STATE VARCHAR(10) ,EVENT_TS DATETIME ) INSERT INTO #TAB1(ID, MY_STATE, EVENT_TS) VALUES (1, 'STATE_1', GETDATE()) ... Application authentication issue - Hi All. I am facing a strange situation or common I don't know. Issue : The sql server agent was running in... Data Source Integration Server - Hello Guys, I am trying to configure a data source on integration service to connect on a SAP Hana database. I installed... Standard deviation over current day and previous 3 days? - Is there a way to get the STDEVP in column 3 (the Price standard deviation of the current and previous... delete records in batches?? and recursive for tables - I have number of tables , I want to purge record based 3 month timeline. eg: select * from sys.tables where name like 'abc%' I... Need sql help - i have two columns ID, Val with ID Clustered Index Scan vs Seek - Hi, I have a table with an Id field. It is NOT auto increment. Every time we insert the new rows,... Does actual occur? - Hi, I am researching about prefetching in Nested loops and can find some articles talk about that. Most of them mentions... Using SQL to fill DataTable - Hi, I am using below SQL statement to load data into table which I will be using for my report. SELECT ... SSIS Exporting to CSV and Opening File in CSV - Hi , In SQL DB- We do have a column ID, which is more than 12 digits length (EX: 854597754782). Created... Off-site backups - I've recently started in a new organisation and found that 2 local SQL Servers Backups are not going off-site at... MERGE - Could someone try this to see what happens I am using SS2K8 - Compatibilty Level 9.0 and am getting the following error... Database team structure - Hi all, Currently part of a large global organisation with A DBA team of around 20 members spread throughout the globe.... |
|
| This email has been sent to newsletter@newslettercollector.com. 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. 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com |
|
|