Sites anglophones


Monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services

Publié le 24 février 2020 sur sqlservercentral.com
 

As a database administrator, you’re often required to maintain other components apart from SQL Server, from installation to performance tuning and, hopefully not, troubleshooting. Most probably you’re already monitoring SQL Server Error Log, but the ot …

How to Forecast the Size of Restore of Backup in SQL Server? – Interview Question of the Week #265

Publié le 23 février 2020 sur journey to sqlauthority
 

Question: How to Forecast the Size of Restore of Backup in SQL Server?Answer: Recently, I had discussed this in consulting engagement: Comprehensive Database Performance Health Check. We had a very unique scenario where we had a huge backup file of the …

In Praise of User-Defined Datatypes

Publié le 22 février 2020 sur sqlservercentral.com
 

User-defined datatype aliases assist in allowing clear readable code. Without them, you can still be consistent in your naming of a column, parameter or variable as ‘price’, but if you use, for example, a datatype called ‘price’, then your naming can b …

SQL SERVER – Always On Error: This Database is Encrypted by Database Master Key, You Need to Provide Valid Password When Adding it to the Availability Group

Publié le 22 février 2020 sur journey to sqlauthority
 

As a part of my work, I also provide consultancy to fix the issues. It has three advantages, first one is that I earn money and the second one, more important one, is that I get to troubleshoot and learn, and the third one is I share it further via my …

SQL Server Machine Learning 2019: Working with Security Changes

Publié le 21 février 2020 sur simple-talk.com
 

I have a confession to make. Why, in my last article about shortest_path in SQL Server 2019, have I used Gephi in order to illustrate the relationships, instead of using a script in R for the same purpose and demonstrate Machine Learning Services as we …

SQL SERVER – Always On Listener Not Coming Online – Failed to Create New NBT Interface, Status 1450

Publié le 21 février 2020 sur journey to sqlauthority
 

During the recent consulting engagement Comprehensive Database Performance Health Check with my client, one of the DBA was busy with Always On deployment. He asked me if I can help him with some pointers. Since I was able to fix it and learned som …

Azure Data Factory Triggers

Publié le 21 février 2020 sur sqlservercentral.com
 

Triggers in ADF are used to run pipelines automatically either on a wall-clock schedule or at a periodic time interval. There is enough documentation on these two types of triggers with examples. But, for someone like me coming from an SSIS background, …

Why you Should Always Specify Whether a Column Accepts Nulls

Publié le 21 février 2020 sur sqlservercentral.com
 

The post Why you Should Always Specify Whether a Column Accepts Nulls appeared first on SQLServerCentral.

Updated First Responder Kit and Consultant Toolkit for February 2020

Publié le 20 février 2020 sur brentozar.com
 

We spent Valentine’s Day removing the bugs from your chocolates. You’re welcome. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First …

MySQL – Get Last Query Cost Using SHOW STATUS LIKE ‘Last_Query_Cost’

Publié le 20 février 2020 sur journey to sqlauthority
 

During the recent webcast I did for Idera, I had the pleasure of showing quite a lot of new tricks and tips. One of the most appreciated tips was about how to get Last Query Cost in MySQL using the command SHOW STATUS LIKE ‘Last_Query_Cost’ …

DBA Team Mashup

Publié le 20 février 2020 sur sqlservercentral.com
 

Have you ever been the sole DBA at a company from the ground up? Me either. Full control of installations, processes and monitoring is a pipe dream for many. Understanding every aspect of your environment and knowing how to react to specific issues tha …

Using SQL Prompt Code Snippets for Repetitive Tasks

Publié le 20 février 2020 sur sqlservercentral.com
 

The post Using SQL Prompt Code Snippets for Repetitive Tasks appeared first on SQLServerCentral.

Configure SQL Server Transparent Data Encryption with PowerShell

Publié le 20 février 2020 sur sqlservercentral.com
 

The post Configure SQL Server Transparent Data Encryption with PowerShell appeared first on SQLServerCentral.

Interesting Undocumented Tidbits in SQL Server 2019 CU2

Publié le 19 février 2020 sur brentozar.com
 

SQL Server 2019 Cumulative Update 2 is out, and Microsoft snuck in a few things that they didn’t mention in the release notes. Contained Availability Groups continue to get new investments. In the lead-up to SQL Server 2019’s release, we go …

WHERE GETDATE() BETWEEN StartDate AND COALESCE(CancelDate, EndDate) Is Even Harder to Tune.

Publié le 19 février 2020 sur brentozar.com
 

In my last post, we started with a memberships table, and each membership had start & end dates. I’m going to create the table and populate it with everyone having an active membership – their StartDate is the same as their Stack Overfl …


Pages :