Importing Files in Parallel with SSIS

• by Paulo de Jesus

• SQLServerCentral.com

• Integration Services (SSIS)

Run multiple instances of your package in parallel so that each instance processes a portion of the total number of files

Waits and Queues

• by Steve Jones

• SQLServerCentral

• Performance and Tuning
• wait statistics

This week Steve is wondering if you know how to use waits and queues for troubleshooting.

Improve Data Quality for SQL Server Reporting

• by Additional Articles

• MSSQLTips.com

• SQL Server Reporting Services

Poor data quality for any reason is very expensive in terms of man hours and decision making to all organizations. There are a number of ways to address the issue with both SQL Server Reporting Services and Power BI.

Scaling SQL Monitor with your growing estate

• by Additional Articles

• Redgate

• SQL Monitoring

Tony Davis describes the features and capabilities of SQL Monitor that allow it to scale smoothly to monitor a growing estate of servers and databases, while still providing a single, simple dashboard that gives the team all of the essential SQL Server metrics and alerts, establishes baselines, and detects trends in behavior.

Don't Get On This Page

• by Steve Jones

• SQLServerCentral

• Data Privacy and Protection
• GDPR
• Security

There is a page where GDPR fines are tracked. None of us want to get on that page.

Let’s Start with Architecture

• by Pamela Mooney

• SQLServerCentral

• Administration

In this article, we look at the conceptual design for gathering information about your servers to better understand how they are performing.

New Release: SQL Clone 4

• by Additional Articles

• Redgate

• Product News, Releases, and Upgrades

Introducing the new “Teams” feature in SQL Clone. Define access to instances, images and clones for specific teams and enable devs to self-service, refreshing environments on demand.

Yes and No Questions Are Not So Simple

• by Additional Articles

• SimpleTalk

• Data Platform

Joe Celko explains why questions requiring yes or no answers are more complicated than you might realize in both spoken language and computing.

Stairway to SQL Server Security Level 3: Principals and Securables

• by Don-Kiely

• SQLServerCentral.com

What is a SQL Server principal? And what does it get a permission on? In this stairway level, you’ll learn about the various principals that can be authorized through permissions to perform actions and access securable objects in the SQL Server instance.

The First Rule

• by Steve Jones

• SQLServerCentral

• software development

Steve has a good rule for anyone that's designing software or databases.