What is Change Management?
Change manage is a process to prepare an organization to implement change. In this article, Rohan Kapoor explains the five components of change management.
2022-03-23
Automation
Anyone Can Click Through Once
Using some sort of scripting or automation is important for your career.
2021-02-10
131 reads
Great Power(Shell)...Great Responsibility
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,553 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
234 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
Blogs
Daily Coping 3 Oct 2022
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
Scary Scalar Functions - Part Four: Your Environment
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant...
Forums
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue.
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the...
Referencing a SQLCMD variable in a Post Deployment script using SqlPackage
Ive got a Database project running in JetBrains Rider. The project publishes a DACPAC...
Calling stored procedure to bulk import from SSIS causes access denied
Hi, I'm working on building a data validation engine, which is supposed to check...
Ask SSC