Introduction to DAX for paginated reports

• by Additional Articles

• SimpleTalk

• BI

SSRS reports can be built using DAX. In this article, Adam Aspin explains how to get started using DAX to build the reports.

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

• by Ben Miller (DBAduck)

• SQLServerCentral.com

In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server.

Worse Before Better

• by Steve Jones

• SQLServerCentral

• software development

We need to approach software development with a balance of making things better, and ensuring they work.

Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services

• by Additional Articles

• MSSQLTips.com

• Big Data

In this article we look at how to create a scale-out SQL Server PolyBase solution on AWS

How a monitoring tool benefits the entire organization

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Redgate estimate that the savings realized with a monitoring tool could be well over $85,000 / year*. Does your organization understand how a monitoring tool can impact almost every department?

Access All Your Data in Google Data Studio with CData Connect Cloud 

• by JerodJ

• SQLServerCentral

Google Data Studio helps you create comprehensive reports and data visualizations. When combined with CData Connect Cloud, you get instant, cloud-to-cloud access to data from supported SaaS, Big Data and NoSQL sources for visualizations, dashboards, and more. CData Connect Cloud provides a live cloud-to-cloud interface for all your data, making it easy to build reports from […]

Azure Data Studio - A SandDance demo

• by Daniel Calbimonte

• SQLServerCentral

• Azure Data Studio

Learn how you can get better charting in Azure Data Studio with SandDance.

Getting Beyond Passwords

• by Steve Jones

• SQLServerCentral

• Security

Steve doesn't think that we will get beyond passwords.

Dry Runs for Database Migrations using Flyway Teams

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

How Dry Run scripts work, and how they can be used to deliver a single-script release artifact to Staging, verify placeholder substitutions in SQL migration scripts, and simply team code reviews.

Using SQL Server sequence objects

• by Additional Articles

• SimpleTalk

• Learn SQL

SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL Server sequence objects.