Sites anglophones


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 …

[Video] What to Do When SQL Server is Slow

Publié le 29 juin 2018 sur brentozar.com
 

Someone comes running in and asks, “Are you doing something on the SQL Server right now? Can you take a look at it? It seems really slow.” It’s one of the most common complaints we get about our databases – and yet, most of us d …

[Video] SQL Query Optimization: Why Is It So Hard to Get Right?

Publié le 29 juin 2018 sur brentozar.com
 

The first paper on cost-based query optimization was published in 1979 by Patricia Selinger from IBM Research. This paper laid the basic framework for optimizing relational queries that is still in place today. While there have been many technical enha …

Introducing Microsoft BI Reporting and Analysis Tools

Publié le 29 juin 2018 sur sqlservercentral.com
 

Choose the right BI tool by learning about the different strengths of the Microsoft analysis and reporting tools. Microsoft provides a variety of BI tools that can address key workloads, such as Power BI and Excel. The article discusses the workloads a …

SQL SERVER – Many BACKGROUND Threads with Command VDI_CLIENT_WORKER

Publié le 29 juin 2018 sur journey to sqlauthority
 

There are so many wait types available in SQL Server and sometimes I feel that it’s an ocean of wait types. I have already written about most common wait types earlier. In this blog, we would learn about VDI_CLIENT_WORKER / VDI_CLIENT_OTHER wait …

What is the FCB_REPLICA_SYNC spinlock?

Publié le 28 juin 2018 sur sqlskills.com - paul randall
 

A question came up on the Data Platform MVP email list last night asking what the FCB_REPLICA_SYNC spinlock is. I answered the question and then promised to do a quick blog post, as there’s no information online about it that I could find. Explan …

Does It Matter Which Field Goes First in an Index?

Publié le 28 juin 2018 sur brentozar.com
 

Let’s take the dbo.Users table from the Stack Overflow database, which holds exactly what you think it holds – the list of users: StackOverflow.dbo.Users Say I want to count up all of the people with 1 reputation point:SELECT COUNT(*) FROM …

Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI

Publié le 28 juin 2018 sur sqlservercentral.com
 

In this tip, you will be walked through a method to calculate MTD, QTD, YTD and running total in Power BI. This method is useful in stock calculations and balance sheet calculations.


Pages :