I wrote about how to timeout an external process in #PowerShell.
chandlergray.com/blog/how-to-timeout-an-external-process-in-powershell
I wrote about how to timeout an external process in #PowerShell.
chandlergray.com/blog/how-to-timeout-an-external-process-in-powershell
Sometimes I write posts just so I remember the steps later. This one covers how I set up my local FTP servers.
Read here: chandlergray.com/blog/setting...
SQL Server = Monty Hall. Pick the first plan, get a goat. Parameter sniffing locks you in. Learn how to switch doors here:
chandlergray.com/blog/the-mon...
I thought this was about SQL Agent Jobs until I watched the video 😆
Wolves in five.
Here's my first attempt at building a real-world useful #Python application. This is for all of the #FantasyBaseball nerds out there. Any feedback is welcome!
chandlergray.com/projects/fan...
Inherited a SQL Server environment with “creative” autogrowth settings? Here’s how I standardize filegrowth across all databases with a simple script.
New Blog Post: How to Set SQL Server Autogrowth for All Databases (and Why You Should)
#sql #sqlserver
chandlergray.com/blog/how-to-...
New Blog Post: How to Safely Shrink a SQL Server Transaction Log File
chandlergray.com/blog/how-to-...
New Blog Post: Migrating Your SSRS ReportServer Database
chandlergray.com/blog/migrati...
What are you trying to say, Aaron?!
How to Install SQL Server 2022 on MacOS
chandlergray.com/blog/how-to-...
How to Analyze Wait Stats in SQL Server 2022
chandlergray.com/blog/how-to-...
New Post: How to Configure and Tune MAXDOP
chandlergray.com/blog/how-to-...
Using PowerShell to Automate Glenn Berry’s SQL DMV Queries
What Is dbatools? The Script Accessing the Script Prerequisites How to Use the Script Pro Tip I find myself using Glenn Berry's SQL Server DMV queries more than any other performance tuning or diagnostic tool. Due to the frequency with…
Identifying and Removing Duplicate Indexes in SQL Server
Why Duplicate Indexes Are Problematic The Script How It Works Gathering Basic Index Information Retrieve Key Columns Retrieve Included Columns Drop Index Statement Find the Duplicates in my Results Limitations In an earlier post, I mentioned…
How to Improve SQL Server Performance by Avoiding Key Lookups
Investigating the I/O Performance Adding the Index Including Columns Recently I've been looking into simplifying my performance tuning efforts. One of the more straightforward methods for improving the performance of a query is to…
How to Download and Install the Latest Cumulative Update for SQL Server
Download the Latest CU Installing the CU Post Installation Tasks Microsoft isn't perfect. Because of this, they need to push out regular updates to SQL Server. These come out in several formats but most often we see this in…
How to Download and Install SQL Server Management Studio (SSMS)
Downloading SSMS Installing SSMS Post-Installation Next Steps SQL Server Management Studio (SSMS) is Microsoft's official tool for interacting with Microsoft SQL Server. SSMS is an essential for Database Administrators that need to…
How to Download and Install Microsoft SQL Server 2022
Downloading SQL Server 2022 Installing SQL Server 2022 Post-Installation Installing SQL Server 2022 is a straightforward process if you follow the right steps. Below, I’ll walk you through how to download the installation media and successfully…
Resolving SQL Server Instance and Database Collation Discrepancies: Step-by-Step Guide
Recently I experienced a situation while migrating a database to a new SQL Server instance where the instance collation was different than the database collation, causing tempdb to become unusable. This…