Anyone Can Click Through Once
Using some sort of scripting or automation is important for your career.
2021-02-10
116 reads
Automation
Great Power(Shell)...Great Responsibility
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,345 reads
Automation is a Key Skill for the Modern DBA
This month's T-SQL Tuesday had lots of posts that look at automation from the DBA perspective, rather than the software developer.
2020-09-12
201 reads
Simple Steps in SQL Change Automation Scripting
Phil Factor demonstrates the bare essentials of SCA PowerShell scripts that can form the basis for an automated process for database delivery or help improve your current process.
2019-07-10
What is Automation?
Kendra Little looks for a meaningful definition of automation as it applies to the software development process.
2019-05-30
4 steps to standardize your database development processes
Adopting standardized processes in database development can free up the time of development teams for innovation and value adding work. Find out the 4 steps you can take to lay the foundations for standardized development in your team and pave the way for full automation.
2019-05-13
Robotics Process Automation: The New Digital Assistant
When most of us think of robotics used in enterprises, automating manufacturing processes comes to mind. Robotics Process Automation (RPA), however, deals with automating mundane office tasks. In this article, Arvind Kumar explains the benefits of RPA and presents a case study.
2019-02-04
2,164 reads
The Enterprise DBA Mindset as a Practical Problem-solving Approach
In order to keep the demands of the job under control, any DBA needs to automate as many as possible of the suitable tasks that their role demands. What makes a task suitable? How do you judge whether it is worthwhile? Can we take a 'managed', consistent, decision? Joshua Feierman explains the practicalities with a real example.
2016-06-02
6,359 reads
Automating Day-to-Day PowerShell Admin Tasks - Jobs and Workflow
If you are aiming to optimise the use of your time by doing as much as possible via scripting, you will soon want to run scripts in parallel to save time. PowerShell does not demand that you run jobs one after the other; It has the means to launch actions whenever you wish and to obtain the results when you want them.
2015-05-15
9,082 reads
Database Build Automation – The First Step to Continuous Integration
So you're keen to take the first steps to the continuous integration of your database. You have to start by getting your database into source control. You can then begin to automate your build processes in order to generate and test a database. By doing this regularly, you'll be much better prepared for the deployment process because you'll have solved integration issues when they happen, and facilitated the broader testing process.
2014-12-30
9,861 reads
Blogs
Everyone Run a SQL Saturday in 2021
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
Modern Data Warehouse & Reverse ETL
By James-Serra
An extension to the Modern Data Warehouse (MDW) that I have heard a bit...
Daily Coping 12 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Linked server to Access accdb database
Hi all We've got a linked server from SQL 2016 to an accdb...
performance tuning
Hi everyone, Any good suggestion to tune below query: --CREATE NONCLUSTERED INDEX nonclust_code...
Understanding the Internals of a Data Page
Comments posted to this topic are about the item Understanding the Internals of a...
Ask SSC