A Little Paranoia is Good

• by Grant Fritchey

• SQLServerCentral

• Database Weekly

Today, Grant Fritchey talks about being prepared for the worst.

Favorite Cars

• by Steve Jones

• SQLServerCentral

• Misc

Today Steve asks about the vehicles you like to drive to get around in today's world.

Obsoleting Unused SSRS Reports

• by Amarendra Reddy Thummeti

• SQLServerCentral.com

• Reporting Services (SSRS)

Learn about programmatically obsoleting unused SSRS reports from your Report Server.

Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key

• by Additional Articles

• SimpleTalk

• NoSQL

As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design considerations for porting a SQL Server schema to Cassandra. The first article explains the Cassandra primary key.

Creating Test Data

• by Steve Jones

• SQLServerCentral

• Redgate Software
• SQL Provision
• Test Data

Test data is hard to come by, and I agree with Brent Ozar: " I get so frustrated when I hear trainers/presenters/bloggers/idealists talk about how developers should be using purpose-built-from-scratch data sets with no real customer data in ’em. The real world just rarely works that way." I agree, and I know this is a […]

Use Polybase to consume Oracle data from SQL Server on Linux 2019

• by pabechevb

• SQLServerCentral

• PolyBase
• SQL Server 2019
• Virtualization, containers, and k8s

Learn how to set up Polybase in containers to access an Oracle database.

Replace Model SQL Server Database with a User Database

• by Additional Articles

• MSSQLTips.com

• Model Database
• User database

In this tip we look at what happens if we replace the SQL Server model database with a regular user database

A Problem with Cowboy Coding

• by Steve Jones

• SQLServerCentral

• DevOps and Continuous Delivery (CI/CD)
• software development

Cowboy coding can be a problem, and in a case Steve talks about, a temptation for someone to get more work.

Stairway to AlwaysOn Level 4: Analyse and Deploy a Windows Server Failover Cluster

• by Perry Whittle

• SQLServerCentral.com

In level 4 of the stairway to AlwaysOn we look at creating a Windows Server Failover Cluster.

Free eBook: SQL Server Execution Plans, Third Edition

• by Press Release

• Redgate

• Execution Plans

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.