Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud Data Management Approaches
The post Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud Data Management Approaches appeared first on SQLServerCentral.
Performance Tuning with SQLFacts Tools
The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved into cloud services, their efficiency has a direct impact on the recurring bills. A workload that consumes more resources than necessary cost …
What SQL Server People Should Know About Amazon Aurora Serverless
You, dear reader, are most likely a Microsoft SQL Server user – either a DBA or developer. Set your pencil down for a second because you’re not going to learn about a Microsoft product today, nor are you going to learn something that is goi …
[Video] Office Hours: Ask Me Anything at Sea
It was a dark and stormy morning, on the last day of my Panama Canal cruise. Before I perished, I sat down to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: > 00:00 Start 00:36 ClippyTheDBA: Hi Br …
The ten habits for highly successful compliant database DevOps
The post The ten habits for highly successful compliant database DevOps appeared first on SQLServerCentral.
PASS Data Community Summit 2023 registrations are open!
The post PASS Data Community Summit 2023 registrations are open! appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? April 2023 Edition
Is your company hiring for a database position as of April 2023? 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 incl …
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connect …
Improving SQL Server Performance and Availability with Accelerated Database Recovery
For many businesses, database performance and availability are crucial elements. A database crash or a lengthy transaction can cause a lot of downtime and have a negative effect on business operations. However, with the introduction of Accelerated Data …
DAX CASE Statement Functionality with IF, SWITCH and SWITCH True
The post DAX CASE Statement Functionality with IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Improving the Quality of your Database Monitoring
The post Improving the Quality of your Database Monitoring appeared first on SQLServerCentral.
Snowflake Temporary Tables vs. Transient Tables
The post Snowflake Temporary Tables vs. Transient Tables appeared first on SQLServerCentral.
Shrink Database Log Files One by One
I have about 25-30 client databases on my computer for testing purposes when I support or do new development for them. Unfortunately, the databases were set up with simple recovery for some and full recovery for others. The simple recovery databases ar …
GENERATE_SERIES: My new go-to to build sets
I have come across a lot of use cases for manufacturing rows on the fly, aside from the common goal of populating a large data set such as a numbers or calendar table. A few favorites include building sample data, pivoting an unknown number of columns, …
A Beginners Guide to MySQL Replication Part 1
MySQL Replication is a process where data from one MySQL database known as the source (formerly called “master”) is copied over to one or more other databases called replicas (formerly called “slaves”). Think of this like having …