Running SQL Server on Oracle and Google Cloud
Introduction In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure (OCI) and Google Cloud Platform (GCP) offer to host a Microsoft SQL Server database. This information can prove to be handy while de …
Learn Python Complex Built-in Data Types including List, Tuple, Range, Dictionary and Set
The post Learn Python Complex Built-in Data Types including List, Tuple, Range, Dictionary and Set appeared first on SQLServerCentral.
ICYMI: What’s behind the explosive growth in data?
The post ICYMI: What’s behind the explosive growth in data? appeared first on SQLServerCentral.
What Trace Flags Are You Using, and Why?
Most of the time, when you need to change SQL Server’s behavior – like how it handles memory or parallelism – there are easy-to-use switches to get the job done. In SQL Server Management Studio, just right-click on the server’s …
« I started lobbying to just toss the tool aside. »
The post « I started lobbying to just toss the tool aside. » appeared first on SQLServerCentral.
SQL Log File Too Big
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 …
DAX table functions for paginated reports: Part 1
The post DAX table functions for paginated reports: Part 1 appeared first on SQLServerCentral.
[Video] Office Hours: Q&A on the Beach at Sunset
You posted and voted on questions at https://pollgab.com/room/brento and I answer ’em on the beach. It’s not your eyes: the camera’s hunting for focus a lot in this video. Here’s what we covered: 00:00 Introductions 01:01 RoJo: …
When to use CHAR, VARCHAR, or VARCHAR(MAX)
The post When to use CHAR, VARCHAR, or VARCHAR(MAX) appeared first on SQLServerCentral.
PowerShell in Azure Data Studio
Introduction Powershell is a powerful command shell used to automate tasks. You can automate Windows tasks, like killing Windows processes or services. Also, you can administer SQL Server and Azure SQL Database. Azure Data Studio includes an extension …
DevOps 101: What, who, why and how?
The post DevOps 101: What, who, why and how? appeared first on SQLServerCentral.
Reporting on the Progress of a Flyway Database Development Project
The post Reporting on the Progress of a Flyway Database Development Project appeared first on SQLServerCentral.
SQL Server Development Using Free Tools
We all know that SQL Server database development is fun! Still, there are some tasks involved that seem harder than they should be. You can make those tasks easier with SQLFacts, a FREE suite of tools for SQL Server database engineers. Please refer to …
Vertipaq optimization and its impact on columnstore compression
The post Vertipaq optimization and its impact on columnstore compression appeared first on SQLServerCentral.
Fundamentals Week: Your First Official SQL Server Class.
You love learning from me. You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes …