Recent years have seen many organizations migrate part or all of their SQL Server environments to public cloud providers. Moving databases to the...
Improving Query Performance in Your Azure SQL Databases
read more
database-tools
Cloud Day 2—Understanding Your Options in Platform as a Service Databases
If you have spent any time reading marketing material from cloud vendors, you will know that there is a big push to move your workloads to platform...
Geek Sync | How to Select the Appropriate Approach to Data Governance
There are three distinct approaches organizations can follow to implement Data Governance. There is the command-and-control approach, the...
How to migrate SQL Server databases and data files
Do you need to: Move databases from one instance to another (for example, to move a performance-intensive database to a faster hard drive to speed...
Reading Event Logs (Part 2)
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Do You Know the Real Costs of Regulatory Noncompliance?
Compliance or noncompliance, that is the question. Is it an economically sound strategy to spend the necessary resources to remain compliant with...
The Challenge of Variable Seasonal Database Usage
If the past year has taught us anything, it is that we can never know what’s coming next. Just to survive, we may need to reevaluate our...
Reading Event Logs (Part 1)
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
How to ensure that SQL Server databases do not have fragmented indexes
Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes. View the fragmentation...
Oracle 19.8 Patch for AIX is now supported by Precise 10.2
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Protect Your SQL Servers with Always Encrypted
The information stored in corporate databases needs to be protected in multiple ways. Database backups are necessary to recover from a physical or...
Reading Last Logged-On User and Other Registry Values
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
How to monitor the health of SQL Server database instances
Determine the health of instances by collecting real-time statistics. Such statistics include backup devices, databases, error logs, locks, logins,...
Geek Sync | Practical PowerShell For The Busy DBA
Many DBAs don't have time to learn PowerShell. Thankfully, there is an excellent PowerShell library already created specifically for handling...
Cloud Day 2—What Do You Need to Know About Cloud Security?
Cloud security is complex and has several layers to it—first and most important is access to the control plane. The control plane is your...
You Need to Plan a Strategy for SQL Server Backups
Backups are an indispensable component of all computing environments. Creating data backups regularly is considered best practice for everyone from...
Constant Functions
In PowerShell, you can write-protect functions. When you do, a function cannot be changed, overwritten or removed anymore during a running...
How can you tune the performance of SQL Server by analyzing the past to predict the future?
The history of mankind says that we have learned a lot from our past mistakes and improved our future. Similarly, SQL Server performance tuning is...
Suppressing Errors
With cmdlets, suppressing errors seems easy: simply add the –ErrorAction Ignore parameter. However, it turns out that this doesn’t...
How to Create a Plan for Regulatory Compliance
Many reasons may make it important for an organization that collects and stores digital information to be concerned with regulatory compliance. Data...
How do you start with performance tuning for Azure SQL Database?
Have you been interested to see how you can baseline performance and improve performance with an Azure SQL Database? Do you want to grasp the secret...
Announcing the Release of SQL Safe Backup 8.7
We’re excited to announce the release of SQL Safe Backup 8.7 SQL Safe Backup is the industry leading mission-critical backup and recovery solution...
Announcing the Release of SQL Defrag Manager 3.6
We’re excited to announce the release of SQL Defrag Manager 3.6 SQL Defrag Manager is an industry leading automated performance solution that...
Finding PowerShell Host Arguments and Executable
PowerShell hosts may be launched with arguments, i.e. you may run powershell.exe or pwsh.exe with arguments like –NoProfile, or submit paths...