Excel File Data Validation for SQL Server Imports
Jeffrey Yao suggests a solution to validate Excel data via PowerShell and Regular Expressions.
MCSA 70-462 Training Kit Preparation: Hyper-V Lab Environment Setup
If you are planning on taking the Microsoft Certification Exam for 70-462, this guide provides the step-by-step instructions to completely setup your Hyper-V lab environment used in the official training kit.
PowerShell and ADO.NET Connection String Settings for SQL Server
Tim Smith addresses some common questions from PowerShell developers about connection strings, errors with strings, and alternative development approaches to using connection strings.
When to Quote in PowerShell
The one question about PowerShell that trips up almost everyone is about when and how to quote strings. Because PowerShell replaces the old command shell, it has to be able to work the way that it did with string parameters, but it also has to behave like a .NET scripting language to replace VBA. In this article, Michael Sorens explains the how and when of PowerShell quoting.
More on CXPACKET Waits: Skewed Parallelism
When cardinality estimates are incorrect, the parallel threads doing the query work are given uneven amounts of work to do. This problem can lead to a seeming explosion in CXPACKET waits occurring and is commonly called skewed parallelism; Paul Randal explains how to check for it.
Blogs
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Forums
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers