Sites anglophones


Recovering Scripts After SSMS Crash

Publié le 31 juillet 2020 sur sqlskills - jonathan kehayas
 

It happens to the best of us and this post is more of a reminder for myself the next time it happens to me than anything else.  You are working in SQL Server Management Studio, you have a few tabs open (OK, it was 123 this time, but lets stay focu …

A One-Slide Summary of the Differences Between TDE and Always Encrypted

Publié le 31 juillet 2020 sur brentozar.com
 

The folks on Twitter liked this, so sharing it here: It’s a one-slide summary from a SQL Critical Care client’s deck, so obviously it’s abridged, but I think it does a pretty good job of summing things up. Some highlights of the conve …

Install MongoDB on Windows – SQL in Sixty Seconds #091

Publié le 31 juillet 2020 sur journey to sqlauthority
 

SQL Server is my passion and I have been keeping busy most of the time in my career doing. While SQL Server is my primary expertise, I also focus on MariaDB, PostgreSQL, MySQL and many other relational databases. However, in the real world, it is not a …

Tracking use of Deprecated SQL Server Features

Publié le 31 juillet 2020 sur sqlservercentral.com
 

The post Tracking use of Deprecated SQL Server Features appeared first on SQLServerCentral.

SQL in Sixty Seconds – Need Your Feedback

Publié le 30 juillet 2020 sur journey to sqlauthority
 

I have been writing about SQL Server Blog for over 13 years now and I have been also creating various different videos on SQL Server Performance Tuning topics. I have recently decided to spend more time in building the videos and have created three vid …

Honorifics in the 21st century

Publié le 30 juillet 2020 sur sqlservercentral.com
 

I have been a data professional on and off since my first full time job in 1997, though my work with data started long before that when I would catalogue my family’s music collection in a spreadsheet. Categorizing things is part of our nature as data p …

Getting Started with Azure Blueprints

Publié le 30 juillet 2020 sur sqlservercentral.com
 

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

The security_error_ring_buffer_recorded event and why you don’t need it

Publié le 29 juillet 2020 sur SQLSkills.com - Erin Stellato
 

 I recently ran through a health audit for a customer, and in reviewing their system_health output I was reminded of the unnecessary security_error_ring_buffer_recorded event.  That’s right: you don’t need it in your system_health …

Remember “Nothing Stops a Hekaton Transaction?” Yeah, About That.

Publié le 29 juillet 2020 sur brentozar.com
 

When In-Memory OLTP first came out, Microsoft liked to go around bragging at conferences that “Nothing stops a Hekaton transaction.” I remember hearing that and kinda chuckling at the time, and I was reminded of it by a recent client who wa …

Creating Covering Index to Eliminate Join – SQL in Sixty Seconds #090

Publié le 29 juillet 2020 sur journey to sqlauthority
 

Last week, I had published Remove Bookmark Lookup – SQL in Sixty Seconds #089 and I got a tremendous response to the video. Lots of people reached out to me with lots of questions. I have written a follow-up series to this video as well. You may …

Creating a Simple Development Harness with SQL Compare and SQL Data Generator

Publié le 29 juillet 2020 sur sqlservercentral.com
 

The post Creating a Simple Development Harness with SQL Compare and SQL Data Generator appeared first on SQLServerCentral.

What SQL ConstantCare® Has Been Finding In Your Servers Lately

Publié le 28 juillet 2020 sur brentozar.com
 

SQL ConstantCare® analyzed over 3,000 of your SQL Servers this month. Here are the things we check for and the number of servers where we found this problem this month: Backup Back Up Your TDE Certificate – 137 servers affected Take a Fu …

SQL SERVER – 7 Follow Up Answers to Remove Bookmark Lookup

Publié le 28 juillet 2020 sur journey to sqlauthority
 

Earlier last week, I published a blog post and SQL in Sixty Seconds video and it got thousands of view in just a few hours and I have received lots of questions based on this question about how to remove bookmark lookup. I have taken the 7 most asked q …

Exploring the SQL Compare Options

Publié le 28 juillet 2020 sur sqlservercentral.com
 

The post Exploring the SQL Compare Options appeared first on SQLServerCentral.

How to Expand a Range of Dates into Rows using a SQL Server Numbers Table

Publié le 28 juillet 2020 sur sqlservercentral.com
 

The post How to Expand a Range of Dates into Rows using a SQL Server Numbers Table appeared first on SQLServerCentral.


Pages :