I often get questions that how to fix the issue where excel loses decimal values when values are pasted from SSMS Resultset.
SQL SERVER – Installing Data Quality Services (DQS) on SQL Server 2012
Installing Data Quality Services on SQL Server 2012? The DQS client has its own installer, and it needs Master Data Services and IIS first.
SQL SERVER – Powershell – Importing CSV File Into Database – Video
PowerShell expert Laerte Junior shows importing CSV file into database tables with PowerShell, with a video, building on my SQL in Sixty Seconds post.
SQL SERVER – Load Generator – Free Tool
Need to generate load on SQL Server? SQL Server Load Generator is a free tool that runs many queries at once under different logins and app names.
SQL SERVER – Migrate a SQL Server Reports from one server to another server
A Microsoft migration tool helps you migrate SQL Server Reports from native mode to SharePoint integrated mode with a PowerShell script it generates.
SQL SERVER – Performance Tuning – Part 2 of 2 – Analysis, Detection, Tuning and Optimizing
Part 2 of my performance tuning series moves from setup to analysis, detection, tuning and optimizing, reading the profiling results section by section.
SQL SERVER – Performance Tuning – Part 1 of 2 – Getting Started and Configuration
Performance tuning scared me early in my career. Part 1 of 2 covers how I got started, what practice taught me, and the setup needed to begin.