Celebrate SQL Saturday with Embarcadero Embarcadero is proud to sponsor SQL Saturday in Austin, TX this Saturday. Whether you’re a long time user of...
Month: January 2015
Updating SQL Elements health check intervals
Periodically when I am speaking to users of SQL Elements I receive a request related to changing the interval at which health checks are run for...
Automatic Unrolling and Memory Consumption
PowerShell 3.0 and later In PowerShell 3.0, a new feature called “Automatic Unrolling” was introduced. With it, you can write code like this:...
Aqua Data Studio 15.0.13 – Minor Fixes and Major Enhancements
We have released the 15.0.13 patch which includes several major enhancements and addresses several defects. This version contains numerous Hive...
Copying Command Line History
All PowerShell versions To preserve all the PowerShell commands that you entered in a PowerShell session, check out this one liner:...
Getting Computer Serial Number
All PowerShell versions In a previous tip we illustrated how you can take a DELL serial number and check online the warranty status. Other vendors...
BigData Support: DBArtisan and RapidSQL Technology Preview
Recently I got the opportunity to have a tinker with our BigData Technology preview for DBArtisan and RapidSQL. I was able to simply and easily...
Checking DELL Warranty Online
PowerShell Version 2.0 and later If you own a DELL computer, you can take advantage of a web service that takes your computer serial number and...
Upcoming SQLSaturdays
It’s a new year and SQLSaturdays continue across the world. SQLSaturdays are free 1-day training events for SQL Server professionals, brought...
Solving Common DBA Tasks at a Leading German Bank with DB PowerStudio
A leading German bank uses DBArtisan to manage hundreds of databases in their organization. This case study will show how many common DBA tasks are...
True Type Font Iconography for Android and iOS Apps
. Download Project Files Download the project files. How to Deploy a Custom True Type Font First create a new Multi Device Application in...
Cmdlets to Manage MSI Packages
PowerShell 2.0 and later Anyone who needs to manage MSI installer packages may benefit from an open source project found here:...
Reading Multiline Text
PowerShell 3.0 and later Sometimes you will stumble across tips like the following one: $FilePath = "$env:SystemRoot\WindowsUpdate.log"...
Requiring Administrator Privileges
PowerShell 4.0 and later If you know that a given script needs Administrator privileges, then a simple #requires statement is enough to make sure...
Beginning Joins with SQL
Introduction When we are talking about relational database, we are usually talking about many different tables and the relationships between them....
Documenting Your Data Landscape For The Organization
When it comes to making informed decisions, data is the most critical asset an organization possesses. In this session, you'll see how to create...
Analyzing and Removing Print Jobs
Windows 8.1 or Server 2012 R2 Both Windows 8.1 and Server 2012 R2 come with a module called “PrintManagement”. It includes all cmdlets...
How to centrally manage enterprise data definitions in your data mangement projects?
One of the key issues in a Data Warehouse, Master Data Management or BI project is the lack of a centralized and easily accessible Data Definition...
Listing All Print Jobs
Windows 8.1 or Server 2012 R2 Both Windows 8.1 and Server 2012 R2 come with a module called “PrintManagement”. It includes all cmdlets...
Remotely Updating Group Policy
Windows 8.1 or Server 2012 R2 To update Group Policy settings on a remote machine, use Invoke-GPUpdate, and submit the name of the computer where...
Getting Physical – Using automation to build robust, high-fidelity schemas from your logical models
High-fidelity database schemas capture essential business rules and help ensure data quality, but can be very time-consuming to produce and...
Managing Printers
Windows 8.1 or Server 2012 R2 Both Windows 8.1 and Server 2012 R2 come with a module called “PrintManagement”. It includes all cmdlets...
Attended a Geek Sync yet? Next up learn more about Monitoring Tempdb
Join us on Geek Sync June 3rd @ 11am CST where you will learn from Idera superhero Vicky Harp about her Guide for Understanding and...
Simplifying .NET Types
All PowerShell versions PowerShell uses short names for the most common .NET types. To see if there is a short name for a .NET type you are using,...