Werner Enterprises is a transportation and logistics leader with more than 8,000 trucks, 24,000 trailers and nearly 13,000 employees. Today, 65...
database-tools
Code-Signing PowerShell Scripts (Part 1)
Adding a digital signature to a PowerShell script is no black magic anymore these days, and while you ideally need an official “trusted” code...
Professional Error Handling
Often PowerShell scripts use a very simple form of error reporting that is structured like this: # clearing global error list: $error.Clear() #...
Cleaning Hard Drive (Part 2)
In the previous post we introduced the Windows tool cleanmgr and its parameters /sageset and /sagerun that you can use to define and run automated...
How to ensure that databases are backed up regularly
Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases....
Cleaning Hard Drive (Part 1)
Part of Windows is an ancient tool that can clean your hard drive: cleanmgr.exe. This tool can remove a variety of data garbage and at times removes...
Announcing the General Availability of SQL Secure 4.0
We are pleased to announce the general availability of SQL Secure 4.0 SQL Secure is the industry-leading, state of the art auditing and security...
Managing Bluetooth Devices (Part 3)
If you’d like to programmatically unpair a paired Bluetooth device, then there is no built-in cmdlet available. Still PowerShell can do the trick,...
Managing Bluetooth Devices (Part 3)
If you’d like to programmatically unpair a paired Bluetooth device, then there is no built-in cmdlet available. Still PowerShell can do the trick,...
Managing Bluetooth Devices (Part 3)
If you’d like to programmatically unpair a paired Bluetooth device, then there is no built-in cmdlet available. Still PowerShell can do the trick,...
Leveraging WMI (Part 3)
The new Get-CimInstance cmdlet lets you query WMI locally, and there is (limited) support for remote queries: you can specify the -ComputerName...
Managing Bluetooth Devices (Part 2)
If you’re just looking for a quick way in Windows to pair and unpair Bluetooth devices, try this command: PS> explorer.exe...
Managing Bluetooth Devices (Part 1)
Identifying Bluetooth devices that your computer has connected to is as easy as a one-liner: PS> Get-PnpDevice -Class Bluetooth Status Class...
Discover how cardinality affects performance
Cardinality is a term from set theory that deals with the size of a set. Data cardinality can affect query plans and performance. Minimize the...
Make SQL Server performance easy
Every database administrator hates to wake up at midnight just to learn there is an emergency with their database. Sometimes, even though their...
Enable customer business intelligence via data catalogs, business glossaries, and data governance
For over three decades, organizations have relied on data warehouses to support business information consumers’ needs for descriptive analytics to...
Leveraging WMI (Part 5)
WMI classes are organized in so-called namespaces that start at “root” and work like a directory structure. The default namespace is rootcimv2, and...
Cut SQL Server licensing costs
SQL Server resellers often send true-up forms to their customers more frequently than Microsoft requires. Some customers receive them every month....
Understand the role of data architects in data governance
Effective data governance programs are partnerships between the business and technical parts of the organization. Often, organizations focus more on...
Improve database performance by 400%
A large enterprise telecommunications company that provides wireless services and internet services in the United States of America uses a...
Decide between agent-based versus agentless monitoring
Monitoring applications, networks, and servers (physical, virtual, and cloud) across multiple platforms has become essential, making smart server...
Measure database performance under pressure
Today’s complex applications execute hundreds of SQL procedures and maybe thousands of SQL statements during a typical workload. Database...
Compare four leading database IDE tools
Today, many roles within an organization often work with the ever-growing amounts of data in databases. No longer are databases the purview of just...
Leveraging WMI (Part 4)
The secret to successfully leveraging WMI is knowing the class names that represent what you are after. In the previous tip we explained how to use...