Years after years we are creating new models. Maybe we save all the different projects to the same folder. After a while, we can have many projects in this directory.
This blog post shares a PowerShell Script which copy|move the project files to subfolders created by using the Copyright Year of the projects.
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...
In the ever-changing world of technology, we sometimes inherit environments with multiple database platforms and must continue to manage them. This...
PowerShellGet is a module and contains important cmdlets such as Install-Module, so this module is really the prerequisite for downloading and...
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...
Organizations are experiencing the effects of rapid technological advancement across every sector and industry, causing them to rely on secure and...
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...
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.
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,...
The cloud is transforming the way modern-day applications are being designed. Data is at the center of multiple challenges while architecting...
Data modeling produces a set of structures for a relational database management system (RDBMS). First, we build the conceptual data model (CDM) to...
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...
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 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.
SQLyog is a powerful MySQL development and administration solution, trusted by 2.5 million users around the world. With SQLyog, organizations have a...
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...
We are pleased to announce the general availability of DB PowerStudio version 18.4! IDERA’s DB PowerStudio provides a powerful cross-platform...
DevOps is a software delivery philosophy that focuses on delivering quality faster. The environment of everyone is different. But we can translate...
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...
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...
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...
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...
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...
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...