How to Backup Redshift Log Views
Recently I had a discussion with my manager about the need to save the log data that is stored in the STL log views, as I found the following line in the AWS Redshift documentation: « To manage disk space, the STL log views only retain approximately two …
Office Hours: Dodging Work Edition
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Today, I’m dodging work, so I went through your questions while I waited for the coffee shop to open: Here’s what we covered: 00:00 …
How to setup multi-subnets Azure SQL VM AG group based WSFC (Windows Server 2019)
In this article, we will learn how to set up Azure SQL VM AOAG based on Windows Server 2019 Failover Cluster step-by-step, it is a detailed supplement to the Microsoft official articles and it is a beginner’s guide for people who have no experience to …
[Video] Fundamentals of Stored Procedures at SQLBits
Anybody can write a stored procedure with a little help from Google. This session is about how to write stored procedures that have a high likelihood of performing well and are easy to troubleshoot. This fast-paced, all-demo session from SQLBits will N …
Generate Random Dates in T-SQL
The post Generate Random Dates in T-SQL appeared first on SQLServerCentral.
How to install SQL Server 2022 step by step
The post How to install SQL Server 2022 step by step appeared first on SQLServerCentral.
Why Adding Some Memory Doesn’t Fix All Caching Problems
It seems obvious: add some memory, and SQL Server should be able to cache data, thereby making queries run faster … right? Well, if you can’t cache everything you need for a query, you might be surprised to find that SQL Server may still re …
Creating Azure Policy to setup Virtual Machine Auto-Shutdown
The Auto-Shutdown policy is another important policy to ensure our virtual machines don’t expend more than what we planned for them. If we have a time window to use the virtual machines, the auto-shutdown policy can deactivate them at the r …
Accessing Relational Databases in Go at Pluralsight
I just released my 42nd course on the learning platform Pluralsight. It was fun to build this new course Accessing Relational Databases in Go. I have been consulting with Go Lang for quite a while. My client has all soft of the database like MySQL, Pos …
Infographic Designer Visuals in Power BI
Introduction The infographic designer’s visuals allow you to create nice reports with infographic icons. You will be able to see reports like this one: Or this one: In this article, we will learn how to use this visual and how to configure it. Requirem …
Query SQL Server with Python and Pandas
The post Query SQL Server with Python and Pandas appeared first on SQLServerCentral.
Establishing a Connection to PostgreSQL with GoLang
Introduction In the modern era, Golang has been very popular as a programming language. Often developers building software need to connect to a PostgreSQL database from their Golang project making the use of the Go’s database package. This article will …
Power BI – How to Download and Get Started
The post Power BI – How to Download and Get Started appeared first on SQLServerCentral.
Columnstore Indexes are Finally Sorted in SQL Server 2022
The post Columnstore Indexes are Finally Sorted in SQL Server 2022 appeared first on SQLServerCentral.
How to Add Invisible Indexes in SQL Server Enterprise Edition
Every now and then, a client says, “We want to add indexes to this third party application, but if we do, we’ll lose support.” No problem – enter indexed views. Say our vendor app is the Stack Overflow database, and the app cons …