Ever since the era of Cloud Computing featuring SaaS(Software as a Service) pioneered by Salesforce, Databases have not been left behind. Databases...
Cloud Databases – A Primer
read more
Month: December 2014
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...
SQL Diagnostic Manager 9.0 Beta
We are pleased to announce that SQL Diagnostic Manager 9.0 will soon be available for beta testing. Please note that this will be pre-release code...
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 =...
Top 3 Security Concepts Any DBA Must Know
DBAs understand how critical and important security is but due to other administration priorities, it can often take a back seat. When working...
3 Tips for Technical Presentation That Every Developer Must Know
Over the past decade, I have developed and given many technical presentations that range from being cultural, based on depth of audience or on...
Parsing DISM Log File
PowerShell 2.0 and later In your Windows folder, you find all kinds of system log files. One is DISM.log which contains information about the...
Top 2 Errors When Working with Datetime Conversions
Working on universal applications has its own challenges. Often I have seen developers resort to unwanted conversions inside the database based on...
Setting Active Directory Attributes
ActiveDirectory Module To set AD attributes for a user account, PowerShell uses hash tables. That’s a versatile approach that lets you specify...
SQL Safe and AlwaysOn Availability Groups
With the release of version 7.4 in August, SQL Safe added AlwaysOn Availability Group support by taking into account the preferred replica when...
Adhoc Database Monitoring Made Easy
There are times when you need to get adhoc monitoring information from your databases. Well, now you can! with Embarcadero's DBArtisan Analyst...
Managing Change in Enterprise Data Modeling
It is often said that Change Management is nothing new in the IT Industry. The Data Modeling space is no different. The critical facet in enabling...
Bulk Creating AD Users from Excel Sheets
Module ActiveDirectory To create a large number of new Active Directory users, you can import the user data from a CSV file, for example export an...
Altering wait categories in SQL Diagnostic Manager
SQL Diagnostic Manager ships with built-in categorization of wait types which are encountered in monitoring. These categories are used on both the...
Removing AD Group Members
Module ActiveDirectory To remove one or many users from an Active Directory group, try this approach: $user = @() $user += Get-ADUser -Filter { Name...
Monyog MySQL Monitor 6.22 Has Been Released
Important note: With the 6.1 release we have changed registration keys. The new key is available for registered users from our Customer Portal....