PASS Summit is the must-attend conference for Microsoft data professionals; delivering 3 full days of technical training on data architecture, management, and analytics. Get the skills you need with in-depth sessions created and led by industry experts. Network and problem-solve with peers and Microsoft engineers, and get ahead of the curve with spotlight sessions on today’s hot topics. Join Redgate and the PASS community in Houston on November 10 - 13 to future-proof your data career.

Text Mining and Sentiment Analysis: Introduction

by Additional Articles

SimpleTalk

Microsoft provides a service to analyze text data called Text Analytics Cognitive Service. In this article, Sanil Mhatre demonstrates how to use this service from Power BI.

Why you Should Always Specify Whether a Column Accepts Nulls

by Additional Articles

Redgate

SQL PROMPT

Phil Factor explains the factors that determine whether a column will allow null values, if you don't specify it explicitly in the column definition. If you rely on the default behavior established by your connection settings, you could be in for some nasty surprises.

DBA Team Mashup

by gm.jones

SQLServerCentral

This article explains an idea for DBA team roles and responsibilities.

Maybe Being Famous is a Bad Idea

by Grant Fritchey

SQLServerCentral

Professional Development

Today, Grant Fritchey talks about the downsides of being famous.

Configure SQL Server Transparent Data Encryption with PowerShell

by Additional Articles

MSSQLTips.com

Transparent Data Encryption is way to protect the data in your SQL Server database. This can be setup using T-SQL, SSMS and using PowerShell.

Using SQL Prompt Code Snippets for Repetitive Tasks

by Additional Articles

Redgate

SQL PROMPT

Louis Davidson discovers the joy of using SQL Prompt code snippets to remove repetition from a variety of tasks, from inserting comment headers, to creating tables, to executing useful metadata queries.

Stairway to SQL Server Agent: Level 1: Setup and Overview

by Richard Waymire

SQLServerCentral.com

SQL Server Agent is a Microsoft Windows service that allows a DBA to automate administrative tasks. SQL Server Agent can run jobs, monitor SQL Server, and process alerts. The SQL Server Agent service must be running before any jobs scheduled to execute automatically can be run

The Soft Skill of Respect

by Steve Jones

SQLServerCentral.com

Editorial

One of the soft skills that is important at work is respect.

Quickly Find and Mask all Sensitive Data with Data Masker for SQL Server

by Additional Articles

Redgate

data masking

Khie Biggs, a software developer on the Data Masker team at Redgate explains how a recent set of Data Masker improvements should make it significantly easier and faster to determine what data needs to be masked, implement a masking plan, and then to apply the masking operation, to protect sensitive and personal data in all the tables and columns of your SQL Server databases.

PASS Summit 2020

Text Mining and Sentiment Analysis: Introduction

Why you Should Always Specify Whether a Column Accepts Nulls

DBA Team Mashup

Maybe Being Famous is a Bad Idea

Configure SQL Server Transparent Data Encryption with PowerShell

Using SQL Prompt Code Snippets for Repetitive Tasks

Stairway to SQL Server Agent: Level 1: Setup and Overview

The Soft Skill of Respect

Quickly Find and Mask all Sensitive Data with Data Masker for SQL Server

Blogs

Claude AI Convinced Me Not to Build an iPad App

A New Word: Dolorblindness

Claude Code Helps Analyze Test Data Manager Log Files

Forums

Data Warehouse Toolkit meets Star Schema: The Complete Reference

GPX distance and time analysis in SQL Server

The DBA is Dead; Long Live the DBA

Question of the Day

Changing the AG Listener