Sites anglophones


 

Mastering TempDB: Managing TempDB growth

Publié le 22 mars 2021 sur simple-talk.com
 

The series so far: Mastering TempDB: The basics Mastering TempDB: Managing TempDB growth As you learned in part one of this Mastering TempDB series, TempDB is a global resource used for many operations within SQL Server. You create and allocate tempora …

 

Our Monday Links Email is 10 Years Old.

Publié le 22 mars 2021 sur brentozar.com
 

I’ve been celebrating the 20th anniversary of BrentOzar.com, but it just so happens that this year marks another fun anniversary. Ten years ago, way back in 2011, I wrote: You’re overworked.  You don’t have the time to sit around …

Five facts about the SQL Server Tempdb Database

Publié le 22 mars 2021 sur sqlservercentral.com
 

The post Five facts about the SQL Server Tempdb Database appeared first on SQLServerCentral.

Migrating SSIS packages to Azure – Lift and Shift using Azure Data Factory

Publié le 22 mars 2021 sur sqlservercentral.com
 

Unlike an on premises SQL Server, Integration Services (SSIS) works very differently on Azure. If there are requirements to run our existing SSIS packages on Azure, then we need to understand our options. In this article we will talk about our opt …

SQL Templates and Code Snippets in SSMS and SQL Prompt

Publié le 22 mars 2021 sur sqlservercentral.com
 

The post SQL Templates and Code Snippets in SSMS and SQL Prompt appeared first on SQLServerCentral.

Documenting a SQL Server Data Catalog in HTML and Git Markdown

Publié le 19 mars 2021 sur sqlservercentral.com
 

The post Documenting a SQL Server Data Catalog in HTML and Git Markdown appeared first on SQLServerCentral.

Azure AD Authentication for Azure SQL Databases

Publié le 19 mars 2021 sur sqlservercentral.com
 

The post Azure AD Authentication for Azure SQL Databases appeared first on SQLServerCentral.

Where I See Databases Going in the Next 10 Years

Publié le 18 mars 2021 sur brentozar.com
 

This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than blogging about database problems & solutions like I usually do. I’m going to generalize a little by decade here to k …

Getting a Query Execution Plan in PostgreSQL

Publié le 18 mars 2021 sur sqlservercentral.com
 

Introduction You often need to check the performance of a PostgreSQL query you just wrote to look for some way to improve performance. In order to do this, you need a report of the query execution, which is called the execution plan). The query executi …

It’s Been Decades. Why Don’t Databases Manage Themselves Yet?

Publié le 17 mars 2021 sur brentozar.com
 

This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than blogging about database problems & solutions like I usually do. A much younger me When I started working with databases, w …

Encrypt and Decrypt Passwords in SQL Server with PowerShell

Publié le 17 mars 2021 sur sqlservercentral.com
 

The post Encrypt and Decrypt Passwords in SQL Server with PowerShell appeared first on SQLServerCentral.

What Does a Database Administrator Actually Do?

Publié le 16 mars 2021 sur brentozar.com
 

BrentOzar.com is 20 years old, and I’m celebrating by being a little retrospective and future-looking this month. Today, I’m publishing a post that I could have published 10 years ago, or maybe 20 years ago, and maybe even 10 years from now …

Delete SQL Statement in SQL Server, Oracle and PostgreSQL

Publié le 16 mars 2021 sur sqlservercentral.com
 

The post Delete SQL Statement in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral.

Reusing Query Results in SSMS

Publié le 16 mars 2021 sur sqlservercentral.com
 

The post Reusing Query Results in SSMS appeared first on SQLServerCentral.

Using Non-SQL Languages in Azure Data Studio

Publié le 16 mars 2021 sur sqlservercentral.com
 

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Da …


Pages :