To display text information, you can of course launch notepad.exe, and use the editor to display the text. Displaying text in an editor is not such...
Month: May 2015
Playing Sound in the Background
If your script takes some time to complete, you may want to play a system sound file. Here is a sample illustrating how this can be done: # find...
DDL Invalid – Missing event types in Compliance Manager
If you are auditing a SQL server that is running extended event traces, you may be seeing events come through in SQL Compliance Manager of category...
Finding Executable
Many file extensions are associated with executables. You can then use Invoke-Item to open a document with this executable. Finding out just which...
Data Breaches: A Shift from Pure Prevention to Monitoring and Collaboration
It’s every Database Administrator’s nightmare to see your company’s name in the headlines in connection with a high profile data breach. Breaches...
ISQL Editor in DBArtisan and Rapid SQL – DBA and Developer Skill Sprints
In this skill sprint we cover ISQL editor features in DBArtisan and Rapid SQL. Learn about the options available in the ISQL window for different...
Splitting Text at Uppercase Letters
To split a text at each uppercase letter, without having to provide a list of uppercase characters, try this example: $text =...
Finding Uppercase Characters
If you'd like to find uppercase characters, you could use regular expressions. However, you would then provide a list of uppercase characters to...
Using Green Checkmarks in Console Output
In a previous tip you have seen that the PowerShell console supports all characters available in a TrueType font. You just need to convert the...
Using Symbols in Console Output
Did you know that console output can contain special icons like checkmarks? All you need to do is set the console to a TrueType font like...
MSSQLTips Reviews Top New SQL Free Tools from Idera
Most of you are aware of the variety of free tools Idera offers to the SQL community to help with SQL Server tasks. Some of you have even mentioned...
Finding Your Top Offending Statements with Extended Events
Finding the top offending statements for a specific workload can be hard if you are not using the best tool in your toolbox. On SQL Server 2012 and...
Monyog MySQL Monitor 6.3 Has Been Released
Changes (as compared to 6.27) include: Features: * A log of long running queries can now be generated and downloaded as CSV in Sniffer interface...
Test Nested Depth
When you call a function, PowerShell increases the nest level. When a function calls another function, or script, this will again increase the nest...
Continuous Delivery in the Database
What is Continuous Delivery? Agile Software development deals with the shorter development cycles and frequent releases. This development process...
Aborting Pipeline
Sometimes you might want to abort a pipeline when a certain condition is met. Here is a creative way of doing this. It works all the way back to...
El control de versiones: Primeros pasos con Git, repositorios remotos y RAD Studio XE8
En una de las últimas encuestas entre los desarrolladores de RAD Studio, nos dimos cuenta de que todavía hay una parte importante de la comunidad...
Version control: Get started with Git, remote repositories and RAD Studio XE8
In one of the latest surveys among RAD Studio developers, we realized that there is still a significant part of the community that doesn’t use any...
Контроль версий: Начните с Git, удаленных репозиториях и RAD Studio X Е8
В одном из последних исследований среди разработчиков RAD Studio, мы поняли, что есть еще значительная часть сообщества, которые не используют...
O controle de versão: Comece a trabalhar com Git, repositórios remotos e RAD Studio XE8
Em uma das mais recentes pesquisas entre os desenvolvedores do RAD Studio, percebemos que ainda há uma parte significativa da comunidade que não...
Aligning Your Models for Master Data Management – by David Loshin
In my last post, I suggested that the conventional “facet” approach to designing master data models (in which each master domain is modeled,...
"Continue" and Labels
When you use the "Continue" statement inside a loop, you can skip the remainder of this loop iteration, and continue with the next....
Get Memory Consumption
To get a rough understanding how much memory a script takes, or how much memory PowerShell puts aside when you store results in a variable, here is...
Creating Custom Multi-Device Preview Devices
In RAD Studio XE8, we introduced the Multi-Device Preview. The Multi-Device Preview provides a design time view of what your...