[Video] Free DBA Training Month: Configuring TempDB, Lock Pages in Memory, and the DAC
While you’re stuck inside wondering if you’ll ever be able to attend a user group meeting again, I’m giving you free access to training materials that your boss probably wouldn’t have been nice enough to buy you anyway. So far t …
A Hybrid Approach to Database DevOps
The post A Hybrid Approach to Database DevOps appeared first on SQLServerCentral.
How to ACTUALLY save money in the cloud with SQL Server
The post How to ACTUALLY save money in the cloud with SQL Server appeared first on SQLServerCentral.
How to Add Help to PowerShell Scripts
Shortly after writing my last article on Parameters, I had to update a script, and I wanted to make it easier for others to run. One of the features I wanted to add was the ability to show them what the script would do with the provided parameters with …
[Video] Free DBA Training Month: Restores for Oops Deletes
While you’re stuck inside wondering if you’ll ever be able to attend a user group meeting again, I’m giving you free access to training materials that your boss probably wouldn’t have been nice enough to buy you anyway. So far t …
Text Mining and Sentiment Analysis: Analysis with R
The series so far: Text Mining and Sentiment Analysis: Introduction Text Mining and Sentiment Analysis: Power BI Visualizations Text Mining and Sentiment Analysis: Analysis with R This is the third article of the “Text Mining and Sentiment Analys …
The Underground Map of SQL Monitor
The post The Underground Map of SQL Monitor appeared first on SQLServerCentral.
Introduction to Azure SQL Database Instance Pools
The post Introduction to Azure SQL Database Instance Pools appeared first on SQLServerCentral.
[Video] Free DBA Training Month: Setting Up Alerts and Ola’s Scripts
While you’re stuck inside wondering if you’ll ever be able to attend a user group meeting again, I’m giving you free access to training materials that your boss probably wouldn’t have been nice enough to buy you anyway. So far t …
Concurrency Control in SQL Server
A “Transaction” in SQL Server The standard definition of a transaction states that “every query that runs in a SQL Server is in a transaction,” that means any query you run on a SQL Server is considered as being in a trans …
Using SQL Clone and SQL Change Automation to switch database branches
The post Using SQL Clone and SQL Change Automation to switch database branches appeared first on SQLServerCentral.
[Video] Free DBA Training Month: Checking For Corruption
For the last couple of months, I’ve been giving away all kinds of free online training to help y’all stay busy and raise your skills during the quarantines. March and April were all about performance tuning, so let’s change things up …
Postgresql JDBC Tutorial on Linux
PosgtreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, Postgres is able to run on various platforms, such as macOS, Solaris, Wi …
SQL Change Automation enables a new flexible approach to DevOps
The post SQL Change Automation enables a new flexible approach to DevOps appeared first on SQLServerCentral.
Making a Difference in Uncertain Times
The post Making a Difference in Uncertain Times appeared first on SQLServerCentral.