PowerShell

Greg Moore in PowerShell

How to Add Help to PowerShell Scripts

PowerShell scripts are the tool of choice for many admins, but how do you make them easy for others to...

13 May 2020 12 min read

BI

Sanil Mhatre in BI

Sentiment Analysis and Text Mining with R: Word Clouds, NRC Lexicon, and Scores

Text mining and sentiment analysis with R: install the tm package, clean text data, build term-document matrices, generate word clouds,...

13 May 2020 20 min read

Performance

Greg Larsen in Performance

Right-Sizing Row Mode Query Memory Requirements

When the optimizer doesn’t estimate the correct amount of memory for a query, either memory is wasted that could be...

29 April 2020 16 min read

BI

Imran Quadri Syed in BI

Implementing a Data Quality Monitoring Framework

For any Business Intelligence solution to be useful for analytical and decision-making purposes, it is imperative that the underlying data...

29 April 2020 26 min read

Database Administration

Robert Sheldon in Database Administration

Storage 101: Modern Storage Technologies

In this article of the series, Robert Sheldon discuses emerging trends in storage like virtual SANs, intelligent storage, computational storage...

28 April 2020 13 min read

NoSQL

Shel Burkow in NoSQL

Translating a SQL Server Schema into a Cassandra Table: Part III Many-to-Many, Attribute Closure and Solution Space

In the third and final article of the series, Shel Burkow demonstrates several designs that cover many-to-many relationships, attribute closure,...

21 April 2020 18 min read

Performance

Fabiano Amorim in Performance

Tempdb – Here’s a Problem You Didn’t Know You Had

Because of its many roles, tempdb is the source of performance issues in SQL Server, and there are recommended configuration...

21 April 2020 14 min read

Database Administration

Pamela Mooney in Database Administration

How to Set Up Transactional Replication

Replication is one way to copy data to another database or server. In this article, Pamela Mooney describes how to...

16 April 2020 11 min read

Theory and design

Joe Celko in Theory and design

Codd’s Twelve Rules

Dr. Codd proposed the normalization rules we used to design databases, but did you know that he also came up...

14 April 2020 16 min read

Database Administration

Robert Sheldon in Database Administration

Storage 101: Data Center Storage Configurations

In this article in the series, Robert Sheldon explains the differences between direct-attached storage, network-attached storage, and storage area networks.…

08 April 2020 11 min read

T-SQL Programming

Edward Pollack in T-SQL Programming

Stale SQL Server Views: Detecting and Fixing Views After Table Changes

SQL Server views can silently return wrong columns after underlying tables are altered. Learn to detect stale views with sp_refreshview,...

31 March 2020 24 min read

T-SQL Programming

Greg Larsen in T-SQL Programming

SQL Server Batch Mode on Rowstore: Reduce CPU on Analytic Queries

SQL Server 2019 Batch Mode on Rowstore reduces CPU usage of large analytic aggregate queries by 20–30% without rewriting any...

25 March 2020 19 min read

Roy Ernest

Introduction to SQL Server Spatial Data

Many applications require the handling of geospatial data. Roy and Surenda take you through the basics of SQL Server spatial...

18 March 2020 22 min read

Database Administration

Robert Sheldon in Database Administration

Storage 101: Understanding the NAND Flash Solid State Drive

Today, most organization are using solid-state drives for everything from laptops to enterprise database storage and virtual machines. In this...

11 March 2020 13 min read

PowerShell

Greg Moore in PowerShell

SQL Server and Undocumented Extended Procedures

Smart DBAs automate tasks whenever possible. In this article, Greg Moore shows the need to use caution when using undocumented...

03 March 2020 11 min read

Database Administration

Robert Cain in Database Administration

How to Create an Ubuntu PowerShell Development Environment – Part 2

You’ll need several tools in place to effectively work with SQL Server in Linux. In this article, Robert Cain explains...

03 March 2020 13 min read

Tools

Edward Pollack in Tools

Knowledge Sharing with SQL Notebooks

SQL Notebooks, based on Jupyter Notebooks, is one of the best things about Azure Data Studio. In this article, Edward...

03 March 2020 16 min read

BI

Sanil Mhatre in BI

Text Mining and Sentiment Analysis: Power BI Visualizations

Power BI is perfect for analyzing surveys. In this article, Sanil Mhatre demonstrates how to build several visualizations for key...

02 March 2020 15 min read

NoSQL

Shel Burkow in NoSQL

Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints

Complex integrity constraints are more challenging to enforce in Cassandra than they are in a relational database. In this article,...

02 March 2020 16 min read

Database Administration

Robert Sheldon in Database Administration

Storage 101: Understanding the Hard-Disk Drive

In this article in the series, Robert Sheldon provides a deep dive into HDDs.…

18 February 2020 12 min read

Register for Simple Talk

Databases

How to Add Help to PowerShell Scripts

Sentiment Analysis and Text Mining with R: Word Clouds, NRC Lexicon, and Scores

Right-Sizing Row Mode Query Memory Requirements

Implementing a Data Quality Monitoring Framework

Storage 101: Modern Storage Technologies

Translating a SQL Server Schema into a Cassandra Table: Part III Many-to-Many, Attribute Closure and Solution Space

Tempdb – Here’s a Problem You Didn’t Know You Had

How to Set Up Transactional Replication

Codd’s Twelve Rules

Storage 101: Data Center Storage Configurations

Stale SQL Server Views: Detecting and Fixing Views After Table Changes

SQL Server Batch Mode on Rowstore: Reduce CPU on Analytic Queries

Introduction to SQL Server Spatial Data

Storage 101: Understanding the NAND Flash Solid State Drive

SQL Server and Undocumented Extended Procedures

How to Create an Ubuntu PowerShell Development Environment – Part 2

Knowledge Sharing with SQL Notebooks

Text Mining and Sentiment Analysis: Power BI Visualizations

Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints

Storage 101: Understanding the Hard-Disk Drive