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...
All PowerShell versions With Get-Acl, you can output the security information from files and folders as plain text in SDDL format (Security...
This is a video replay from the DataU online conference. An Application Programming Interface (API) brings your own applications closer to your...
Ever since the era of Cloud Computing featuring SaaS(Software as a Service) pioneered by Salesforce, Databases have not been left behind. Databases...
All PowerShell Versions Here is some simple code that reads the NTFS permissions from one folder and applies the exact same settings to another....
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...
The Microsoft SQL Server System comprises of four key System Databases master model msdb and tempdb The following table outlines the key points...
The Team Server REST Application Programming Interface (API) allows one application to talk to another application directly and securely. Team...
Hi! The Result Cache is a newer structure for Oracle11 and newer databases. This feature remembers the invariables and return...
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...
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...
All Versions WMI classes are inherited from each other, and that’s something you can take advantage of. Take this line: PS> Get-WmiObject...
This video replay from the Data U online conference gives you an overview of the challenges faced by organizations wanting to implement a secure...
All PowerShell versions To find out who owns a particular process and how many instances are running, try this simple piece of code: $ProcessName =...
DBAs understand how critical and important security is but due to other administration priorities, it can often take a back seat. When working...
Over the past decade, I have developed and given many technical presentations that range from being cultural, based on depth of audience or on...
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...
Working on universal applications has its own challenges. Often I have seen developers resort to unwanted conversions inside the database based on...
ActiveDirectory Module To set AD attributes for a user account, PowerShell uses hash tables. That’s a versatile approach that lets you specify...
With the release of version 7.4 in August, SQL Safe added AlwaysOn Availability Group support by taking into account the preferred replica when...
There are times when you need to get adhoc monitoring information from your databases. Well, now you can! with Embarcadero's DBArtisan Analyst...
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...
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...
SQL Diagnostic Manager ships with built-in categorization of wait types which are encountered in monitoring. These categories are used on both the...