[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 […]
Sites anglophones
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 ...
Is your company hiring for a database position as of April 2023? Do you wanna work with the […]
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from […]
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 […]
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 […]
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 […]
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 […]
[Video] Office Hours: Ask Me Anything About SQL Server in ...
Off the coast of Costa Rica, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: […]
Piping, Filtering and Using Flyway Output in PowerShell
The post Piping, Filtering and Using Flyway Output in PowerShell appeared first on SQLServerCentral.
The role of forethought for a computer engineer
If you have ever played a game of chess against someone good, or perhaps against a computer, […]
Is SQL Server 2019 More CPU-Intensive Than SQL Server 2016?
I’m running into something that I’m having a hard time believing. A client was hitting CPU issues during […]
The Curious Case of…. alcoholism
Hello, my name is Paul, and I’m a high-functioning alcoholic. For the last ten years or so, I’ve […]
Using Virtual Network Data Gateways to Secure Access to Azure ...
Power BI and Azure are two related services, but with a considerable independence between them. Power BI […]
This is the Last Week of Free PowerShell Training.
You’ve been working hard all month to get through our newest class, Fundamentals of PowerShell for DBAs. This week, […]
How to use the SQL WHERE Clause with Examples
The post How to use the SQL WHERE Clause with Examples appeared first on SQLServerCentral.
Passing parameters to query without TVFs
Problem Statement You have a need to extract data from a table or view with 1 or more […]
Database Monitoring: The ROI of Build vs. Buy
The post Database Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
How to Connect SQL Server and Create C# Objects for ...
If you’re a developer or a database administrator, you undoubtedly know that SQL Server and other relational database […]
Thought Leadership resource page
The post Thought Leadership resource page appeared first on SQLServerCentral.
SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, ...
The post SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, Privileges and Owners – Part II […]
Office Hours: Questions That Didn’t Make the Cut
Sometimes, y’all post questions at https://pollgab.com/room/brento and they don’t get a lot of upvotes, and reading through ’em, […]
[Video] Office Hours in Cartagena, Colombia
Before heading out to Old Town for sightseeing, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what […]
The future of AI in solving database challenges
The post The future of AI in solving database challenges appeared first on SQLServerCentral.
Paging Data in T-SQL
Sometimes when working with very large sets of data, you may not want to return all of […]
It’s Monday. Do You Know Where Your PowerShell Training Is?
You’re over the hump! Just two weeks left to go. All month long, I’m giving away our newest […]
ChatGPT and PowerShell – Some practical examples
Introduction to ChatGPT and PowerShell In this article, we will show how to work with ChatGPT and PowerShell. […]
New functions in SQL Server 2022 – LEFT_SHIFT and RIGHT_SHIFT
The post New functions in SQL Server 2022 – LEFT_SHIFT and RIGHT_SHIFT appeared first on SQLServerCentral.
The Basics of PostgreSQL Views
Article Overview This article will help you to understand what is a database view in general and in […]
What are the biggest challenges organizations face in their digital ...
The post What are the biggest challenges organizations face in their digital transformation efforts? appeared first on SQLServerCentral.
SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) ...
The post SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types appeared first on SQLServerCentral.
Slow Startup, Failover, and Restore Times with In-Memory OLTP
When In-Memory OLTP came out, I worked with it briefly, and I remember coming away thinking, “Who in […]
The SELECT Statement in Oracle
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT […]
Recording What’s Changed when Running Oracle Migrations with Flyway
The post Recording What’s Changed when Running Oracle Migrations with Flyway appeared first on SQLServerCentral.
[Video] Office Hours at Sea: Heading to Jamaica
I’m on a boat! I’m on a 10-day Panama Canal cruise, and I stopped (well, not the boat) […]
Are PostgreSQL memory parameters magic?
Configuration parameters are the most mythical creatures in the world of PostgreSQL. Ordinary PostgreSQL users often do […]
Better Keep Up: More Free PowerShell Videos This Week.
We’re almost halfway through the month. How’s it coming? You keeping up? Or are you having a tough […]
How to Install the AdventureWorks Sample Database in Azure SQL ...
The post How to Install the AdventureWorks Sample Database in Azure SQL Database appeared first on SQLServerCentral.
Find Invalid Objects in SQL Server
One of the most important responsibilities of any database administrator is to maintain the integrity of the database, […]
On-Demand Webinar – Monitoring: The ROI of Build vs. Buy
The post On-Demand Webinar – Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
How to Implement CI/CD in Azure Data Factory (ADF)
Continuous Integration and Continuous Deployment (CI/CD) are integral parts of the software development lifecycle. As a Data Engineer/ […]
SELECT DISTINCT SQL Command to Return a Unique List of ...
The post SELECT DISTINCT SQL Command to Return a Unique List of Values appeared first on SQLServerCentral.
Build a Better WordPress Archives Page Using MySQL
I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar […]
Do you need Trace Flag 460?
For most people that are reading this post, I’d venture to guess that you have no idea what […]
Who’s Hiring in the Microsoft Data Platform Community? March 2023 ...
Is your company hiring for a database position as of March 2023? Do you wanna work with the […]
Complex Production Database Deployments and Flyway
The post Complex Production Database Deployments and Flyway appeared first on SQLServerCentral.