Lost your work because you forgot to back it up? Having your database developers do a mountain of work in a short time frame is not the best way to...
database-tools
Work with and support multiple database platforms
In the ever-changing world of technology, we sometimes inherit environments with multiple database platforms and must continue to manage them. This...
Test-Driving PowerShellGet Version 3
PowerShellGet is a module and contains important cmdlets such as Install-Module, so this module is really the prerequisite for downloading and...
Agile data modeling is not an option but essential
The time has passed when data models could hide in an ivory tower (IT) and locked behind bars only for the IT in‐crowd to be consulted. It is their...
How did the database administrator role change in 2022?
Organizations are experiencing the effects of rapid technological advancement across every sector and industry, causing them to rely on secure and...
SpeculationControl: Use PowerShell to Check for Risks
Microsoft released a module a couple of years ago (updated 3 weeks ago) that you can use to identify whether your hardware is vulnerable against...
Team Server REST API – Import into Google Sheets
In my previous post, we have seen how to obtain the authorization to use the API.
In this one, we create a new blank spreadsheet in Google Sheets which uses the Team Server REST API to directly import and refresh the objects we want.
Getting Parent Culture
Most of the time, localized resources are tagged with a culture name such as “en-us” or “de-de”. If you’d like to know what such an ID stands for,...
Design data intensive cloud native applications
The cloud is transforming the way modern-day applications are being designed. Data is at the center of multiple challenges while architecting...
Model data for MongoDB and JSON
Data modeling produces a set of structures for a relational database management system (RDBMS). First, we build the conceptual data model (CDM) to...
Dealing with the Complexities of Regulatory Compliance
Why is Data Privacy Important? An incredible amount of digital information is generated daily, with an estimated 1.7 MB of data being created every...
Invoke-RestMethod Cancellation Issues
Both Invoke-WebRequest and Invoke-RestMethod are simple-to-use cmdlets to download information from the web. For example, this simple code can query...
Team Server REST API – Getting Started
Team Server provides a REST based API to interact with it.
This blog post describes how we can connect to and use the Team Server REST API from an Excel workbook.
Key points to remember while using SQLyog
SQLyog is a powerful MySQL development and administration solution, trusted by 2.5 million users around the world. With SQLyog, organizations have a...
Two Type Casts (and one bug)
To explicitly convert one data type to another, PowerShell offers two ways: PS> [int]5.6 6 PS> 5.6 -as [int] 6 While both approaches yield identical...
Announcing General Availability of DB PowerStudio (DBPS) version 18.4
We are pleased to announce the general availability of DB PowerStudio version 18.4! IDERA’s DB PowerStudio provides a powerful cross-platform...
Fundamentals of database people and DevOps
DevOps is a software delivery philosophy that focuses on delivering quality faster. The environment of everyone is different. But we can translate...
Mounting ISO Files
In our previous tip we showed how you can easily turn local folders into ISO file images. Today, we look at how you can mount (and dismount) your...
Ensure a sustainable architecture for data analytics
Today, you cannot pick up a magazine, read a blog, or hear a webcast without the mention of big data. It has had a profound effect on our...
Monitor MySQL managed cloud databases with ease
Once upon a time, organizations hosted their database servers on-premises. Later, they moved to data centers, and now we often find the same servers...
Creating ISO Files
PowerShell can turn regular folders into ISO files. ISO files are binary files that can be mounted and then behave like a read-only CD-ROM drive. In...
Progress Bar Tricks (Part 4)
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...
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...
Setting up IDERA TeamServer Database inSQL Server Availability Groups! – Part 2
TeamServer Database in SQL Server Availability Groups! - Part 2 Howdy! As promised this is part 2 of the setup for IDERA TeamServer in a SQL...