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
Accessing individual Files and Folders Remotely via WMI
WMI is an excellent way of remotely checking files or folders since it has the ability to access individual files and folders, and also works locally as well as remotely. Files are represented by the WMI class CIM_DataFile whereas folders are represented by...
Converting ASCII and Characters
Convert ASCII value to a character To convert the ASCII value to a character, use type casting like this: [char]65 Convert a character to ASCII value To do the opposite and convert a character to its ascii value, use this: [int][char]'A' Here, the letter "A" is first...
Validating a URL
Validating User Input as a URL Using System.URI To make sure user input is a valid URL, you can use the System.URI type. Try to convert the raw string into this type. If it works, the string is a valid URI. You can then further examine the converted result to limit...
Assigning Multiple Variables
Refer the code : In PowerShell, you can initialize multiple variables in just one line. The following line sets all variables to the value 1: $a = $b = $c = $d = 1 To swap variables, list variables as comma-separated lists (actually, PowerShell treats your lists...
Converting Hash Tables to Objects
Hash Tables are convenient but are not true objects. This is bad because you are unable to output the hash content to formatting cmdlets or export cmdlets. With a short function, you can easily convert a Hash Table to an object, providing all the flexibility you need...