Who’s Hiring in the Database Community? August 2022 Edition
Is your company hiring for a database position as of August 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must inc …
Swap Columns – SQL in Sixty Seconds #199
Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. Think of the scenario where you have a form with first name and last name. Now users have input the data in a different order than you expect. In this cas …
How to Get Data Using Python in Power BI
Introduction Get data from Python in Power BI is a possible. Python is one of the most popular programming languages. Several websites consider Python as the #1. Even the DBAs feel some pressure to learn Python. SQL Server included some features to int …
A day in the life of a DBA using SQL Monitor: in a 90 second video!
The post A day in the life of a DBA using SQL Monitor: in a 90 second video! appeared first on SQLServerCentral.
Running a Python Application as a Windows Service
The post Running a Python Application as a Windows Service appeared first on SQLServerCentral.
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 …