Stairway to Columnstore Indexes Level 3: Building The Columnstore
The performance increase columnstore indexes grant when reading data from the index is offset by the expensive process required to build the index. In this Stairway level, Hugo Kornelis walks you through the steps SQL Server takes when building (or rebuilding) a columnstore index.
Database DevOps: Standardize, Automate, Monitor & Protect
See how our end-to-end framework for extending DevOps to your database enables your organization to balance the demand to deliver software fast with the need to protect and preserve business critical data.
Python Built-in Statistics Functions using SQL Server Data
Learn how to use statistical functions in Python with data from a SQL Server database along with several different examples.
How to use a Powershell script to track the network latency issue in AOAG
In this article, we will learn how to use a Powershell script to track the network latency issue in the AwlaysOn availability group (AOAG), the network latency may become a real issue for the AOAG, if the network latency is too high for AOAG, the primary replica will lose the connection to the secondary replica, […]
Stairway to DAX and Power BI - Level 17: Time Intelligence Functions: The DAX DATEADD() Function
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX DATEADD() function, discussing its syntax, uses and operation. He then provides hands-on exposure to DATEADD(), focusing largely upon a popular use in creating prior-period values at multiple Date hierarchy levels.
Business Analytics from Application Logs and SQL Server Database using Splunk
Learn how Splunk can be used to get information from application logs or a SQL Server database.
Look Beyond What You See
One of the sales managers at Redgate Software posted an origin story about how he came to work at Redgate Software. It's an interesting story, and while I don't work in sales or have the same origin story, I don't know that I could have seen the place I'm in now early in my career. […]
Building a Database with Flyway
Flyway, especially Flyway Teams edition, can be used in several different ways to accommodate a database development that was originally based on builds rather than migrations. This article explores four different ways to use Flyway to build a particular version of a database, from the ground up, using a single migration script. It should help teams select the best way to incorporate Flyway into an existing database build system, during development, while benefitting from use of Flyway's versioned migration system for deployments and releases.
SQL Server vs Oracle: Data Masking
In this article, we look at how to mask/hide data for users using Dynamic Data Masking in SQL Server and Data Redaction in Oracle
Blogs
Daily Coping 11 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using DBCC CLONEDATABASE to create a schema only copy of your database.
DBCC CLONEDATABASE is one of those features that I don’t use often but it’s...
VS Live Microsoft HQ Slides and Code
By Steve Jones
Thanks to everyone that attended my sessions today at VS Live. I have my...
Forums
SSIS Running From SQL Job Fails - Most Of The Time
I have three SSIS packages created in Visual Studio 2019, going against a SQL...
Grand total of the sum of a field taking another field
Hello everyone, I am trying to calculate the field called "Load weight". The calculation...
Ask SSC