Is your SQL database log file too big? Maybe it is. But maybe it’s not. When log files keep growing and appear to be too big some might suggest switching to Simple recovery, shrinking the log file, and switching back to Full recovery. While this will work to shrink the file and free up disk […]
The post SQL Log File Too Big appeared first on SQLServerCentral.
DAX table functions for paginated reports: Part 1
Several DAX table functions can be used for paginated reports when you want all the data, not a summary. Adam Aspin explains how to use DAX table functions for paginated reports.
The post DAX table functions for paginated reports: Part 1 appeared first on SQLServerCentral.
The post DAX table functions for paginated reports: Part 1 appeared first on SQLServerCentral.
When to use CHAR, VARCHAR, or VARCHAR(MAX)
It’s important to choose the right datatypes when designing a database. Greg Larsen explains the differences between CHAR, VARCHAR and VARCHAR(MAX).
The post When to use CHAR, VARCHAR, or VARCHAR(MAX) appeared first on SQLServerCentral.
The post When to use CHAR, VARCHAR, or VARCHAR(MAX) appeared first on SQLServerCentral.
PowerShell in Azure Data Studio
Learn how to get started with PowerShell in Azure Data Studio.
The post PowerShell in Azure Data Studio appeared first on SQLServerCentral.
The post PowerShell in Azure Data Studio appeared first on SQLServerCentral.
DevOps 101: What, who, why and how?
More and more organizations are turning to DevOps as a way of working together to improve the efficiency and quality of software delivery, and increase value to the business. But what exactly is DevOps and what does it mean for you and your organization?
The post DevOps 101: What, who, why and how? appeared first on SQLServerCentral.
The post DevOps 101: What, who, why and how? appeared first on SQLServerCentral.
Reporting on the Progress of a Flyway Database Development Project
This article demos a novel way to report on the progress of your Flyway development project. It provides both SQL and PowerShell versions of code that extracts information for each database version from the Flyway schema history table and then plots it in a Gantt chart.
The post Reporting on the Progress of a Flyway Database Development Project appeared first on SQLServerCentral.
The post Reporting on the Progress of a Flyway Database Development Project appeared first on SQLServerCentral.
SQL Server Development Using Free Tools
You can make SQL Server database development faster and easier with a FREE toolkit!
The post SQL Server Development Using Free Tools appeared first on SQLServerCentral.
The post SQL Server Development Using Free Tools appeared first on SQLServerCentral.
Vertipaq optimization and its impact on columnstore compression
Vertipaq optimization is a critical component of the columnstore compression process. Edward Pollack explains how it works and what you need to know to manage it.
The post Vertipaq optimization and its impact on columnstore compression appeared first on SQLServerCentral.
The post Vertipaq optimization and its impact on columnstore compression appeared first on SQLServerCentral.
