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
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
Using some sort of scripting or automation is important for your career.
2021-02-10
148 reads
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,728 reads
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
302 reads
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
Kendra Little looks for a meaningful definition of automation as it applies to the software development process.
2019-05-30
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
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
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
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
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
Hello I need to get txt files from directory and send email, when I...
Hello, I have a question regarding Availability group server architecture. A little background: We...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers