Sites anglophones


SQL SERVER – Performance Impact of Unique Index

Publié le 24 juillet 2019 sur journey to sqlauthority
 

Today I am going to share a story of my client who has hired me over 7 times for my most popular consulting service Comprehensive Database Performance Health Check for different servers and situations. In the latest engagement, we had a very interestin …

How to Enable SQL Server CLR Integration using T-SQL

Publié le 24 juillet 2019 sur sqlservercentral.com
 

The post How to Enable SQL Server CLR Integration using T-SQL appeared first on SQLServerCentral.

Do you really know what’s happening with your servers?

Publié le 24 juillet 2019 sur sqlservercentral.com
 

The post Do you really know what’s happening with your servers? appeared first on SQLServerCentral.

PolyBase in SQL Server 2019 – The End of ETL?

Publié le 23 juillet 2019 sur simple-talk.com
 

One of the new features in SQL Server 2019 is SQL Server Big Data Clusters, and one part of this feature is PolyBase. Now you may wonder: Hasn’t PolyBase been around for quite a while? And you’re right! PolyBase was introduced in SQL Server …

Building an AMD Ryzen 7 3700X Desktop Machine

Publié le 23 juillet 2019 sur sqlskills.com - glen berry
 

Since the AMD Ryzen 3000 series processors were released on July 7, 2019, I decided to build a new desktop machine based on this processor. This was to give me some hands on experience with an AMD Ryzen 3000 series processor, and because I actually enj …

DBA Training Plan 4: Checking for Corruption

Publié le 23 juillet 2019 sur brentozar.com
 

You would think that when SQL Server writes your data to disk, it’s totally safe. Forever. You would be wrong. It’s almost like there are gremlins out to get you, purposely trying to trash your data. In the really old days, it was problems …

SQL Authority News – SysAdminDay – System Administrator Appreciation Day

Publié le 23 juillet 2019 sur journey to sqlauthority
 

System Administrator Appreciation Day or SysAdminDay is around the corner and I am very excited about it. Every single year, I receive tons of emails and messages on this day.History of SysAdminDayI think the trend of celebrating sysadmin day is increa …

Azure Elastic jobs

Publié le 23 juillet 2019 sur sqlservercentral.com
 

Azure Elastic jobs provide similar functionality in Azure as MS SQL Server Agent for MS SQL Server databases on premises. The only big problem I have noticed so far is a lack of graphic tools to manage Azure Elastic jobs. So, the most of operations wit …

Data privacy next steps: Compliant Database DevOps

Publié le 23 juillet 2019 sur sqlservercentral.com
 

The post Data privacy next steps: Compliant Database DevOps appeared first on SQLServerCentral.

What are Columnstore Indexes?

Publié le 22 juillet 2019 sur simple-talk.com
 

Columnstore indexes were first introduced in SQL Server 2012. They are a new way to store the data from a table that improves the performance of certain query types by at least ten times. They are especially helpful with fact tables in data warehouses. …

DBA Training Plan 3: Treat Your Servers Like Cattle, Not Like Pets

Publié le 22 juillet 2019 sur brentozar.com
 

In our last post in this series, I talked about why you should be using Ola Hallengren’s maintenance script for backups and sp_DatabaseRestore for faster restores. These two tools have implications for how you build, back up, recover, and fail ov …

SQL SERVER – Dynamic SQL and Temporary Tables

Publié le 22 juillet 2019 sur journey to sqlauthority
 

Followup question to previous blog posts is always fun and interesting. Earlier on this blog, I had written about SQL SERVER – Dynamic SQL and Global Temporary Tables, I received following follow up question about Dynamic SQL and Temporary Tables …

Data Transfer Strategies between MongoDB and SQL Server

Publié le 22 juillet 2019 sur sqlservercentral.com
 

SQL Server users are accustomed to the relative ease with which they can get data from, and send data to, other databases systems. This article aims to answer the question of whether there are any problems of data interchange with MongoDB. In doing so, …

How to find Updated Column in SQL Server Trigger

Publié le 22 juillet 2019 sur sqlservercentral.com
 

The post How to find Updated Column in SQL Server Trigger appeared first on SQLServerCentral.

Can an Index Reduce Performance of SELECT Query? – Interview Question of the Week #234

Publié le 21 juillet 2019 sur journey to sqlauthority
 

Question: Can an Index Reduce Performance of SELECT Query?Answer: Of course!I have discussed this subject multiple times on this blog. Of course, Index can reduce the performance of any query and particularly of SELECT queries without even being that i …


Pages :