Sites anglophones


The Curious Case of… whether corruption can propagate to secondary databases

Publié le 26 février 2020 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog “GUID” is Encrypted by It

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

Sometimes I get amazed by the speed at which the search engine crawls and gets the right results. A few days ago, I wrote a blog about a UI error in Always On availability group. Someone found that blog, followed it, got another error and contacted me …

SQL SERVER – Drivers for DevOps – Efficient Monitoring

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

At SQL Authority, my main job is to work with SQL Server Performance Tuning, and every day I learn that more organizations are implementing DevOps for their database platform. DevOps is a collaborative approach to software development and delivery that …

Introduction to Indexed Views in SQL Server

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

Introduction Usually, when a view is created in the SQL Server database, it is just a virtual table (not stored on disk) that might fetch results from one or more underlying physical tables (stored on disk). Views are mainly created to maintain securit …

Free Fundamentals of Index Tuning Week: Part 1, Indexing for the WHERE Clause

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

I’m teaching my Mastering Index Tuning pre-con at SQLBits and SQL Saturday Iceland, and part of the prerequisites is that you’re already familiar with my How to Think Like the Engine class and my Fundamentals of Index Tuning class. I was go …

SQL SERVER – Unable to Allocate Enough Memory to Start ‘SQL OS Boot’. Reduce Non-essential Memory Load or Increase System Memory

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

One of my clients, contacted me to fix one of the errors which they received while starting SQL Service. In this blog, I would share my learning about error “Unable to allocate enough memory to start ‘SQL OS Boot’. Reduce non-essentia …

Deployment Suite for Oracle: What’s New?

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

The post Deployment Suite for Oracle: What’s New? appeared first on SQLServerCentral.

Saving Game Data with Unity

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

The post Saving Game Data with Unity appeared first on SQLServerCentral.

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, …


Pages :