Sites anglophones


SQL SERVER – Unable to See SQL Server Configuration Manager. How to Open it?

Publié le 5 juillet 2018 sur journey to sqlauthority
 

I get many emails every day and I do respond to them as soon as I can.  Sometimes they are about the business and sometimes they are from my blog readers who have followed my other blog and need help with something else. Most of the time, I do hav …

10 SQL Server Feature Requests I’ve Upvoted Recently

Publié le 4 juillet 2018 sur brentozar.com
 

In no particular order: Database Level Option for Storing Wait Stats – just like we can store query plan history in Query Store, it’d be awesome to get performance history over time. Give more info on the “String or Binary Data Would …

SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client Was Not Authenticated. The Server Response Was: 5.5.1 – Using Gmail

Publié le 4 juillet 2018 sur journey to sqlauthority
 

In my earlier blog, we saw one possible cause database mail error due to SSL settings. Today we will learn about another Database Mail Error. SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client was not Aut …

Management Studio Hides Missing Indexes From You.

Publié le 3 juillet 2018 sur brentozar.com
 

SQL Server Management Studio only shows you the first missing index recommendation in a plan. Not the best one. Not all of them. Just whichever one happens to show up first. Using the public Stack Overflow database, I’ll run a simple query:S …

Azure SQL Database and GDPR Compliance

Publié le 3 juillet 2018 sur sqlservercentral.com
 

In recent years, technology landscape has undergone dramatic changes, driven primarily by cloud computing and a continuously increasing level of attention dedicated to security, privacy, and compliance. One of the more significant initiatives that atte …

Importing Tricky CSV Files with PowerShell

Publié le 3 juillet 2018 sur sqlservercentral.com
 

A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explai …

What is SQL Change Automation?

Publié le 3 juillet 2018 sur sqlservercentral.com
 

William Brewer explores the features of Redgate’s SQL Change Automation

New Trends and Challenges in Database Administration

Publié le 3 juillet 2018 sur journey to sqlauthority
 

In the previous blog posts, we discussed the evolution of the DBA along with the challenges, changes and their upcoming trends. Data is the most critical part of any application. The changing nature of the data always brings new challenges to DBAs. New …

Calling all user group leaders! We want to present for you again in 2018!

Publié le 3 juillet 2018 sur sqlskills.com - paul randall
 

So far this year, we at SQLskills have presented remotely (and a few in-person) to 59 user groups and PASS virtual chapters around the world, and we have 17 more scheduled! Now we’re into the second half of 2018, we’d like to schedule …

Building SQL ConstantCare®: Collecting Query Plans

Publié le 2 juillet 2018 sur brentozar.com
 

Coming Soon In an upcoming release, we’ll start collecting query plans from your servers. Since this may result in the transmission of PII, it will be opt-in only. We won’t be getting this by default, because we don’t want anyone to b …

Machine Learning 101: The Mathematics of an Artificial Neural Network

Publié le 2 juillet 2018 sur sqlservercentral.com
 

This article (1) demonstrates an artificial neural network as it learns to recognize alphanumeric characters and (2) elucidates the mathematics of the feed-forward/back-propagation algorithm the artificial neural network employs.

Troubleshooting Blocking in SQL Server using SQL Monitor

Publié le 2 juillet 2018 sur sqlservercentral.com
 

Learn what causes blocking and how you can use SQL Monitor to help solve performance issues.

SQL SERVER – gMSA: The Service Did Not Start Due to a Logon Failure

Publié le 2 juillet 2018 sur journey to sqlauthority
 

This is one of the most common errors which is seen my most DBA when they are using a domain account as the service account. In this blog, we would learn about the cause and solution of error The service did not start due to a logon failure while using …

How to Check Edition Specific Features Enabled In SQL Server? – Interview Question of the Week #180

Publié le 1 juillet 2018 sur journey to sqlauthority
 

Question: How to Check Edition Specific Features Enabled In SQL Server? Answer: I had asked this question in the recent interview of the person who was applying for the job of the DBA. The very task the DBA supposed to get was of migrating databases fr …

SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client was not Authenticated. The Server Response Sas: 5.5.1

Publié le 30 juin 2018 sur journey to sqlauthority
 

Have you ever configured database mail using Gmail account? There are many articles on the internet describing the steps. In this blog, we would learn about fixing an error “The SMTP server requires a secure connection or the client was not authe …


Pages :