Have a little free time over the holidays while providing coverage for work, or like to brush up on technical information? In addition to the many...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Dealing with %ERRORLEVEL%
All PowerShell versions When you run native EXE console commands inside your scripts, these commands typically return a numeric return value. This...
Automating Data Modeling Tasks
Finding ways to automate common tasks can make your data modeling more productive. By investing a little bit of time initially, you can save time...
Compacting Paths
[WindowsAPILib.Helper _i="0" _address="0" theme_builder_area="post_content" /][WindowsAPILib.Helper _i="1" _address="1"...
Get the OU from an LDAP Path
All Versions To extract certain parts from raw strings, you can often use a combination of text splitting and text substring commands. For example,...
Proof of Concepts made Easy with The Cloud
As a Solutions Architect, there are times when you actually need to replicate customer scenarios, often becomes a challenge, unless you have your...
Creating Huge Dummy Files
All PowerShell versions If you need to stress test systems, or need large dummy files for other purposes, here is some code that can create even...
Data Modeling for Agile Environments
Agile Development has always been at the forefront of new ways of developing software. So why should Data Modeling be left behind? In this short...
Limiting Maximum String Length
All Versions To make sure output text is not excessively long, you can use logic like this to shorten text that is longer than a given maximum...
Consistent Data in Distributed Systems
This is a video replay from the DataU online conference. Data types that are not consistent across multiple systems where data movement occurs could...
Integrated cross-platform SQL IDE for increased database development efficiency
Have you ever wanted a SQL IDE that would help you code SQL for multiple platforms using a Single IDE? Now you can! with Embarcadero's RapidSQL...
2 Ways to identify that we have a bad plan in SQL Server
SQL Server is a complex RDBMS with a lot of capabilities in it. I am sure most of us have just scratched the surface when it comes to working with...
3 soft skills that you want to have in an interview
It was couple of years back that my friend had written this article on my blog - Interview Questions and Answers – Perspectives of an Author. I know...
Top 3 Sample Databases for PostgreSQL
If a developer is attempting to learn a new process or test some code, it’s best to utilize a test environment such as a sandbox rather than the...
Setting Permissions in AD or Windows Registry
ActiveDirectory Module We already illustrated previously how you can use Get/Set-Acl to read and write permissions to files and folders. The truth...
Catching Errors in Native EXEs (Part 2)
All versions Here is yet another approach that you can use to detect errors emitted by console applications: $ErrorActionPreference = 'Continue'...
The #1 Data Modeling Issue – Being ‘Dead’ Right – By Len Silverston, Universal Data Models, LLC
While many data modelers are very open minded and not righteous at all in their attitudes, over the years, I have heard the following statements...
Replacing NTFS Permissions with SDDL Information
All PowerShell versions With Get-Acl, you can output the security information from files and folders as plain text in SDDL format (Security...
How to Connect your Applications to your Data
This is a video replay from the DataU online conference. An Application Programming Interface (API) brings your own applications closer to your...
Cloud Databases – A Primer
Ever since the era of Cloud Computing featuring SaaS(Software as a Service) pioneered by Salesforce, Databases have not been left behind. Databases...
Cloning NTFS Permissions
All PowerShell Versions Here is some simple code that reads the NTFS permissions from one folder and applies the exact same settings to another....
Catching Errors in Native EXEs (Part 1)
All Versions When you run native console EXE commands such as robocopy.exe, ipconfig.exe, or similar commands, you can handle errors raised by these...
Exploring Microsoft SQL Server System Databases
The Microsoft SQL Server System comprises of four key System Databases master model msdb and tempdb The following table outlines the key points...
Empower your Applications with Embarcadero Team Server APIs
The Team Server REST Application Programming Interface (API) allows one application to talk to another application directly and securely. Team...
Result Cache Using Rapid SQL
Hi! The Result Cache is a newer structure for Oracle11 and newer databases. This feature remembers the invariables and return...
Oracle 12 New Limits
Hi! I’ve been working on PL/SQL topics and wanted to share with you a new Oracle12 feature. Oracle12 now allows for much longer...
3 Things You Didn’t Know About Black Box Trace
Black Box Trace In earlier versions of SQL Server, there have been situations where root cause analysis was never possible because data saved by SQL...
Using WMI Inheritance
All Versions WMI classes are inherited from each other, and that’s something you can take advantage of. Take this line: PS> Get-WmiObject...
Data Modeling Source Control Demystified
This video replay from the Data U online conference gives you an overview of the challenges faced by organizations wanting to implement a secure...
Finding Process Owners
All PowerShell versions To find out who owns a particular process and how many instances are running, try this simple piece of code: $ProcessName =...