Announcing the General Availability of SQL Diagnostic Manager for MySQL 8.9.7

We are pleased to announce the general availability of SQL Diagnostic Manager (SDM) for MySQL 8.9.7  Existing users may upgrade to this version through the...
Read More
dbps-release

Categories

Using “more” in the PowerShell ISE

Using “more” in the PowerShell ISE

by | Mar 23, 2015 |

PowerShell ISE In the PowerShell console, you can pipe commands to the old-fashioned “more.com”, or better yet, to Out-Host –Paging. This will display data page by page, asking for a key press to continue: PS> Get-Process | more PS> Get-Process | Out-Host...

Using “more” in the PowerShell ISE

Measuring Website Response (and Execution Times)

by | Mar 13, 2015 |

PowerShell 3.0 and later Sometimes it is important to know just how long a command takes. For example, to monitor web site response times, you could use Invoke-WebRequest. Measure-Command measures execution time. $url = 'http://www.powershell.com' # track execution...

Team DBA and Collaboration

Team DBA and Collaboration

by | Mar 11, 2015 |

In previous blog posts I have explored the relevance of the DBA position itself in business  and the unique ways that SQL Server DBAs tend to fall into their positions.   After mulling over those topics I found myself considering the varying...

Using “more” in the PowerShell ISE

Exporting Out-GridView Content

by | Feb 13, 2015 |

PowerShell 3.0 and later Out-GridView is a very useful cmdlet to output results to an extra window. Unlike outputting to the console, Out-GridView will not cut off anything. And it has a not-so-obvious way of easily copying the information to other applications. Try...

Using “more” in the PowerShell ISE

Top 3 Development Environments for PostgreSQL

by | Jan 15, 2015 |

PostgreSQL is an object-relational database management system (ORDBMS) supporting extensibility and standards-compliance. Just like any other advanced RDBMS, PostgreSQL does more than retrieving or updating data. PostgreSQL is a very popular database...

Using “more” in the PowerShell ISE

Finding Explicit Permissions

by | Jan 5, 2015 |

All PowerShell versions Typically, NTFS permissions in the file system are inherited. You can, however, add explicit permissions to files and folders. To find out where inheritance was changed and direct security settings have been added, you can use this code sample:...

Using “more” in the PowerShell ISE

Accessing COM Objects without ProgID

by | Jan 2, 2015 |

All Versions Typically, to access COM objects, these objects need to register themselves in the Windows Registry, and PowerShell needs the registered ProgID string to load the object. Here is an example: $object = New-Object -ComObject Scripting.FileSystemObject...

Using “more” in the PowerShell ISE

Changing GPO Description/Comment

by | Dec 31, 2014 |

GroupPolicy Module When you create a new Group Policy, you can set a comment (or description). There is no apparent way, however, to change the description later. Here is code that allows you to retrieve a group policy, then read and/or change the description. Make...

Using “more” in the PowerShell ISE

Top 3 Sample Databases for PostgreSQL

by | Dec 22, 2014 |

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 production server. A sandbox environment is the place where there are scenarios like the real world but no real world data....

Using “more” in the PowerShell ISE

Replacing NTFS Permissions with SDDL Information

by | Dec 18, 2014 |

All PowerShell versions With Get-Acl, you can output the security information from files and folders as plain text in SDDL format (Security Descriptor Definition Language): $FolderToRead = 'C:\folder1' $securityDescriptor = Get-Acl -Path $FolderToRead...

Using “more” in the PowerShell ISE

Top 4 Startup Parameters DBAs Must Know

by | Dec 1, 2014 |

Introduction Working on a server is always something DBAs cherish. With every environment that they monitor, they want to know how applications can be optimally run on a specific server. In this constant pursuit of performance tuning, they always find unique ways of...

Using “more” in the PowerShell ISE

Pinging via IPv4

by | Nov 13, 2014 |

All PowerShell versions You can use ping.exe just like any other command inside PowerShell scripts. By adding “-4” to the command line, you can force ping to use IPv4 (add “-6” to force IPv6 instead). PS> ping localhost -4 ReTweet this...

5 Different Ways to Start SQL Server Services

5 Different Ways to Start SQL Server Services

by | Oct 27, 2014 |

If nothing works, then a restart works. This is the exact sentiments that an Administrator has when it comes to working with software. If you are working as SQL Server DBA, you must have done this many times – restart SQL Server Services. It’s always interesting to...

Using “more” in the PowerShell ISE

Getting the Number of Lines in a String

by | Sep 15, 2014 |

All PowerShell Versions Here is a clever trick how to find out how many lines a string (not a string array!) contains: $text = @' This is some sample text Let's find out the number of lines. '@ $text.Length - $text.Replace("`n",'').Length...

Using “more” in the PowerShell ISE

Finding Minimum and Maximum Values

by | Sep 5, 2014 |

All PowerShell Versions To find the smallest and largest item in a range of numbers, use Measure-Object: $list = 1,4,3,1,3,12,990 $result = $list | Measure-Object -Minimum -Maximum $result.Minimum $result.Maximum This works for any input data and any data type. Here...

Using “more” in the PowerShell ISE

Getting Files with Specific Extensions Only

by | Aug 15, 2014 |

All PowerShell versions When you use Get-ChildItem to get a list of files, you may have noticed that the -Filter parameter occasionally returns more files than you’ve expected. Here is an example of this. This line does not just return files with a...