2015-09-14
2,432 reads
Articles
Excel File Data Validation for SQL Server Imports
Jeffrey Yao suggests a solution to validate Excel data via PowerShell and Regular Expressions.
2015-09-14
3,457 reads
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.
2015-09-11 (first published: 2013-11-25)
19,238 reads
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.
2015-09-11
3,709 reads
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.
2015-09-10
3,703 reads
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.
2015-09-09
3,469 reads
SQL 2016: Columnstore row group Merge policy and index maintenance improvements
Denzil Ribeiro looks at how SQL Server 2016's new Merge functionality in INDEX REORGANIZE simplifies Columnstore index maintenance significantly.
2015-09-08
3,007 reads
2015-09-07
2,328 reads
Building Databases: One Man’s Best Practice?
One man’s meat is often another man’s poison. In this editorial Tony Davis looks at why a migrations-based approach to database version control might not always be best practice.
2015-09-07
6,262 reads
Hidden Tricks To SQL Server Table Cleanup
How to delete millions of rows with virtually no contention.
2015-09-04 (first published: 2013-03-06)
28,393 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers