Sites anglophones


Azure Data Factory : Your First Data Pipeline

Publié le 11 août 2020 sur sqlservercentral.com
 

Introduction Azure Data Factory is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. We can create and schedule data pipelines which can move …

SQL Server Bulk Insert for Multiple CSV Files from a Single Folder

Publié le 11 août 2020 sur sqlservercentral.com
 

The post SQL Server Bulk Insert for Multiple CSV Files from a Single Folder appeared first on SQLServerCentral.

European Union Folks: Wanna Attend Mastering Index Tuning?

Publié le 10 août 2020 sur brentozar.com
 

You need to speed up a SQL Server app, but you only want to make index changes. You don’t want to buy hardware, change SQL Server, or change the code. I’ll teach you the most important advanced lessons in one day. In my one-day Mastering In …

Pluralsight Course – Open Source Cloud: Executive Briefing

Publié le 10 août 2020 sur journey to sqlauthority
 

Earlier last month, I had written about Open Source Cloud technology and I got lots of positive response to the series. Lots of people thought the series explained the concept of the open-source cloud in very and simple words. I really appreciate the f …

Protect SQL Databases with Dell EMC PowerProtect and DataDomain Under VMware

Publié le 10 août 2020 sur sqlservercentral.com
 

Introduction We are now in the data era – data is growing at rapid space, being processed in different ways, and becoming more distributed across data centers and clouds. Thus databases are also growing and they are stored and protected in variou …

How to Get Rowcount of Every Table in SSMS? – Interview Question of the Week #288

Publié le 9 août 2020 sur journey to sqlauthority
 

Question: How to Get Rowcount of Every Table in SSMS?Answer: After watching my earlier video on the fastest way to get the rowcount for the table, I got lots of questions from the user, if there is a way to list rowcount for every single table in SQL S …

Alter Index Add Column – Workaround – SQL in Sixty Seconds #097

Publié le 8 août 2020 sur journey to sqlauthority
 

During the recent Comprehensive Database Performance Health Check, I identified at my client’s place that we needed to modify one of the indexes and add a couple of additional columns to improve its performance. However, while modifying it we fac …

SQL Server Cumulative Update Documentation Is Going Downhill, Fast

Publié le 7 août 2020 sur brentozar.com
 

Microsoft appears to have given up on patch documentation, and that’s kinda scary for a product that costs thousands of dollars per core. Yesterday’s SQL Server 2019 Cumulative Update 6 launched with the worst documentation I’ve seen …

Fastest Way to Retrieve Rowcount for a Table – SQL in Sixty Seconds #096

Publié le 7 août 2020 sur journey to sqlauthority
 

Whenever I am helping my clients with their SQL Server Performance Comprehensive Database Performance Health Check, every single time I get this question. What is the fastest way to retrieve rowcount for a table? Performance issues most of the tim …

Gathering SQL Server Performance Counters for Multiple Servers

Publié le 7 août 2020 sur sqlservercentral.com
 

The post Gathering SQL Server Performance Counters for Multiple Servers appeared first on SQLServerCentral.

Getting Started with Azure DevOps

Publié le 7 août 2020 sur sqlservercentral.com
 

The post Getting Started with Azure DevOps appeared first on SQLServerCentral.

Where are Table Variables Stored? – SQL in Sixty Seconds #095

Publié le 6 août 2020 sur journey to sqlauthority
 

A very popular question we will answer today Where are Table Variables Stored? Recently I have posted few videos on my YouTube Channel about SQL Server performance Tuning and I have received an email from my client of Comprehensive Database Perfor …

Basic Git for DBAs: What’s a Pull Request?

Publié le 6 août 2020 sur sqlservercentral.com
 

This is the sixth article in a series on the basics of using Git. The other articles in the series are: Basic Git for DBAs: Getting Started with Git Basic Git for DBAs: Sharing Files Through GitHub Basic Git for DBAs: the Basics of Branches Basic Git f …

SQL Server Problems We Don’t Have Anymore

Publié le 5 août 2020 sur brentozar.com
 

We have completely new problems today. I was cleaning out a folder of presentations and I realized there are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today. Virtual Log Files (VLFs) – it …

Quantum Computing With an Example of Coin – SQL in Sixty Seconds #094

Publié le 5 août 2020 sur journey to sqlauthority
 

Quantum Computing is the next wave in computing and it is very different from traditional computing. Lots of people often ask me what is Quantum Computing. I decided to build a short video based on Quantum Computing with an example of a coin. I use the …


Pages :