Removing Whitespace (and Line Breaks)

Removing Whitespace (and Line Breaks)

You may know that each string object has a method called Trim() that trims away whitespace both from the beginning and end of a string: $text = ' Hello ' $text.Trim() Trim() and Line Breaks A lesser known fact is that Trim() will also eat away leading and trailing...

Removing Whitespace (and Line Breaks)

Understanding break, continue, return, and exit

Understanding Control Flow: break, continue, return, and exit Do you know off-hand what "break", "continue", "return", and "exit" do? These are powerful language constructs, and here is a test function to illustrate how different their effects are: 'Starting' function...

Removing Whitespace (and Line Breaks)

Getting Registry Values and Value Types

Get-ItemProperty can easily read registry values, but you do not get back any information about the registry value type. Get-ItemProperty -Path 'HKLM:\Software\Microsoft\Windows NT\CurrentVersion' Alternative Approach Using .NET Here is an alternate approach that uses...

Removing Whitespace (and Line Breaks)

Tinker, Tailor, Developer, DBA

Tinker, Tailor, Developer, DBA is not intended as a pitch on a slightly less harrowing book or movie than the John Le Carre classic.   Rather, it is a consideration of the career progressions of those working in and around SQL Server and how that progression...

Removing Whitespace (and Line Breaks)

Using “more” in the PowerShell ISE

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...

Removing Whitespace (and Line Breaks)

Measuring Website Response (and Execution Times)

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

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...

Removing Whitespace (and Line Breaks)

Exporting Out-GridView Content

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...

Removing Whitespace (and Line Breaks)

Top 3 Development Environments for PostgreSQL

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...

Removing Whitespace (and Line Breaks)

Finding Explicit Permissions

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:...

Removing Whitespace (and Line Breaks)

Accessing COM Objects without ProgID

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...

Removing Whitespace (and Line Breaks)

Changing GPO Description/Comment

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...

Removing Whitespace (and Line Breaks)

Top 3 Sample Databases for PostgreSQL

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....

Removing Whitespace (and Line Breaks)

Replacing NTFS Permissions with SDDL Information

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...

Removing Whitespace (and Line Breaks)

Top 4 Startup Parameters DBAs Must Know

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...

Removing Whitespace (and Line Breaks)

Pinging via IPv4

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...