Dealing with Parameter Sniffing in SQL Server
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Running $PSScriptRoot in Selected Code
One of the big pitfalls in PowerShell code is the automatic variable $PSScriptRoot which always holds the path to the folder the current script is located. This however requires that (a) the current script is in fact already saved to file, and (b) you are executing...
Pasting Multiple Lines in PowerShell
Unexpected Behavior When Pasting Multiple Lines of PowerShell Code When you copy multiple lines of PowerShell code and paste them into a shell window, the result often is not what you expect. PowerShell starts executing the first line and won’t execute the pasted code...
Cleaning Up PowerShell Modules (Part 2)
In part 1 we looked at removing PowerShell modules that were originally installed via “Install-Module”. You can as well remove PowerShell modules manually if you no longer need them. After all, they are just folders. PowerShell Modules Here’s code that lists all...
Cleaning Up PowerShell Modules (Part 1)
There are plenty of scripts available that promise to read the original Windows 10 product key from the registry by converting a series of binary values. In the first part of this mini-series, we’ll check out where PowerShell keeps its modules, and what you can do to...
Quickly Finding Outdated PowerShell Modules
In the most simplistic case, you can check all your installed modules for updates with just a one-liner (remove -WhatIf to actually perform the update): PS C:\> Get-InstalledModule | Update-Module -WhatIf Get-InstalledModule lists all modules that were installed in...
Analyze blocking for SQL Server
Blocking is a normal activity that occurs in SQL Server and it does that to control data integrity and make sure only one resource can change a set of data at one time. The problem with blocking is if SQL Server blocked a session for a long period, this can cause...
Using Efficient Lists in PowerShell
By default, PowerShell uses simple “object arrays” when you define lists, when commands return more than one result, or when you otherwise need to store more than one thing in a variable. Default object arrays are OK but they cannot grow once you created them. When...
Managing File Shares on Windows with PowerShell (Part 1)
Managing Network Shares with the SMBShare Module Windows comes with a module called “SMBShare” which contains 42 cmdlets to manage network shares. This module works with Windows PowerShell and PowerShell 7: PS> Get-Command -Module SMBShare CommandType Name Version...
Out-GridView with Custom Columns
Out-GridView can be a universal dialog when you use the -OutputMode or -PassThru parameters. When you do, a grid view window displays additional buttons in its lower right corner so you can choose items and pass them on to additional cmdlets. This line could help...
Converting Ticks to DateTime
Occasionally, date and time information are stored as “Ticks” in the format of a so-called “FileTime”. Ticks are 100-nanosecond units since 01/01/1601. Active Directory internally uses this format, yet you can also find it elsewhere. Reading Windows Installation Time...
Top 5 Benefits of Universal Database GUI
Universal database graphical user interfaces (GUIs) are among the most productive tools available to database administrators (DBAs) and developers. A well-crafted universal database GUI can greatly assist team members to maintain and implement new features to their...
Finding and Fixing Locking Issues on SQL Server Databases
In SQL Server, locking helps improve efficiency by preventing resources from being used simultaneously by different transactions. Issues with SQL Server locking can adversely affect the performance of SQL Server databases. In systems that have many users, the...
Top 5 Reasons for Slow SQL Server Queries and How to Fix Them
Slow SQL Server Queries are a common issue among database administrators (DBAs). You would be hard-pressed to find a SQL Server DBA who was not interested in improving the performance of their databases and applications. Slow response time can impact database...
Unlock Additional PowerShell Modules in Windows 10
PowerShell Modules in Windows 10 for Server Management Windows 10 comes with a number of PowerShell modules that you can use to control Server functionality - like WSUS Update Management which is only one example of many. In earlier Windows 10 builds, these PowerShell...
Exporting CSV without Quotes (and Other Conversion Tricks)
PowerShell comes with a bunch of Export- and ConvertTo- cmdlets so you can serialize object data to CSV, JSON, XML, and other formats. That’s great but it is not hard at all to create your own export functions. Export-Csv in Windows PowerShell For example, Export-Csv...
What Is an IDE? – The Difference Between IDEs and Code Editors
When evaluating integrated development environments vs. code editors, the right option comes down to your requirements. IDE's have a broad feature set and code editing is just one capability. This post will help you understand the difference between IDEs and code...
What Is Non-Uniform Memory Access (NUMA)?
Bare metal to cloud hosted virtual machines Non-Uniform Memory Access (NUMA) is a four-letter word in every sense, well beyond simply the number of characters in the acronym to many data professionals, particularly those in an operational database administrator (DBA)...
Using BITS to Download Files (Part 1)
What Is BITS (Background Intelligent Transfer System)? BITS (Background Intelligent Transfer System) is the technique used by Windows to download huge files such as operating system updates. You can use the same system, too, to download large files. As an extra...
Repairing Install-Module (PowerShellGet)
With Install-Module, you can easily download and install additional PowerShell modules from the PowerShell Gallery (www.powershellgallery.com). However, on Windows systems this command may be broken. Many Windows systems still ship with the outdated version 1.x, and...
Identifying Performance Problems Part 1
Every server, database, storage appliance and network encounter some sort of performance issues. It is a major part of our job as database administrators to properly monitor and fix those performance issues whether it is in your traditional on premises environment or...