Due to popular request, here is a code that illustrates how you can use nested progress bars and show a "real" progress indicator for each task your...
Progress Bar Tricks (Part 4)
read more
database-tools
Understand indexes to write better queries
It is easy to learn how to query a database for information. SQL is a declarative language, meaning we tell the engine what to get, not how to get...
Initialize Transactional Replication from your Backups
This blog provides guidance on the perceived limitations and restrictions on initializing transactional replication subscribers from backups. The...
Progress Bar Tricks (Part 3)
PowerShell's built-in progress bar can be nested, showing one progress bar per task. For this to work, assign distinct ID numbers to your progress...
Better manage MySQL and MariaDB databases
Database administration refers to managing the databases in an organization. Database administration for MySQL and MariaDB databases encompasses...
Progress Bar Tricks (Part 2)
Publishing on – Mon May 15 The built-in PowerShell progress bar supports a “real” progress indicator provided you submit a “percentCompleted” value...
Adapting to the Evolving Role of the DBA with SQL DM
Over the years, the job of a Database Administrator (DBA) has become more complex and strategic, from just managing databases to a much bigger...
Compare four leading database tools
Today, many roles within an organization work with the ever growing amounts of data in databases. No longer are databases the purview of just the...
Progress Bar Tricks (Part 1)
PowerShell comes with a built-in progress bar. It typically automatically disappears when your script is done: Write-Progress -Activity 'I am busy'...
Monitor the top metrics in MySQL databases
As tables increase in size and more and more users come online, it becomes necessary to fine tune the database server from time to time. The secret...
Listing Active Domain Controller
If your machine is connected to a domain, you can use PowerShell to identify the domain controller you are connected to. Either use this command:...
Listing All Domain Controllers
To get a quick list of all of your domain controllers, run this one-liner: Get-AdDomainController -Filter * | Select-Object -Property Name, Domain,...
Achieve more with fewer resources
The current uncertainty in the economy is causing many organizations to look for ways of making their operations more productive. These...
Permanently Deleting Hard Drive Content
When you delete files on storage media like hard drives or USB sticks, as you probably know, the data is not immediately deleted. Instead, the data...
Understanding Azure SQL Database Architecture
This blog will give you a glimpse into the internal architecture of SQL Database and brings to light some of the critical concepts that SQL Database...
What are the benefits of SQLyog’s Ultimate versus the Community edition?
SQLyog is a powerful graphical user interface tool to manage MySQL and MariaDB servers and databases in physical, virtual, and cloud environments....
Undeleting Office365 Mailboxes (Part 2)
Let’s assume someone left the company, and you deleted its Office365 user account. As it turns out, this also deletes the attached mailbox. If you...
How to select a database tool
Choosing a database development and management tool does not need to be a complicated process, but you should at least determine what features are...
Undeleting Office365 Mailboxes (Part 1)
If you have deleted a Office365 user account and then realize that you still need the data in its mailbox, you may be able to recover the mailbox....
What are the most important MySQL performance tuning checks?
MySQL is the most popular and powerful open-source database. As applications become more data-dependent, the database application resources are...
Renaming Properties (Simple)
Select-Object can not just select properties but also rename. Let’s assume you need a list of files in a folder with their size. This line would...
Announcing the General Availability of SQL Compliance Manager 6.0
We’re excited to announce the release of SQL Compliance Manager 6.0 SQL Compliance Manager is the industry leading SQL Server auditing solution that...
Common Pitfall and Strange Results: Comparison Operator
Can you spot what’s wrong in the code below? $result = 'NO' if ($result = 'YES') { 'Result: YES' } else { 'Result: NO' } It always returns “Result:...
Improve database development
Wherever data takes the organization, the database must follow. And wherever the database goes, database administrators and developers must take the...