Raw PowerShell output is hard to read. Here are three common ways to format PowerShell script output, starting with Format-Table, so results make sense.
PowerShell Scripts – get-process with SQL Server process
I was playing with the get-process cmdlet in PowerShell. Here is how to use get-process with SQL Server to find the sqlservr process and its details.
SQL SERVER – How to Avoid Triggers for Multiple Row Operations in a Table
A late-night mail from an old customer about an application error led to this lesson: how to avoid triggers causing trouble with multiple row operations.
Creating and Running an SQL Server Unit Test – Best Ways to Test SQL Queries
Testing SQL code matters as much as writing it. I show how to create and run a SQL Server Unit Test with tSQLt, the free open source framework.
SQL SERVER 2016 – Creating Clustered ColumnStore with InMemory OLTP Tables
While preparing my SQLPASS session on SQL Server 2016, I explored creating clustered ColumnStore with InMemory OLTP tables. Here is what I learned.
SQL SERVER – Fix Error Msg 35336 Working with ColumnStore Indexes
A bank moving from SQL Server 2012 to 2016 wanted to use non-clustered ColumnStore indexes. Here is the error Msg 35336 we hit and how to fix it.
SQL SERVER – Simple Example of BCP Command Line Utility
Need to export table data fast? A step by step, simple example of the BCP Command Line Utility, from finding bcp.exe to running the export.