Sites anglophones


Building PasteThePlan.com: Removing Comments

Publié le 28 janvier 2020 sur brentozar.com
 

PasteThePlan.com We have this PasteThePlan where you can copy/paste the contents of execution plans, and then share the links around the web. You’ve pasted 16,621 plans so far, and I’m always amused to see them continuing to trickle in ever …

SQL SERVER – Enable Additional Logging for SQL Server Agent

Publié le 28 janvier 2020 sur journey to sqlauthority
 

When I searched for this topic, I was getting blogs where they were talking about additional logging for the job step in SQL Server Agent jobs. In this blog, I would share my learning about logging about SQL Server Agent itself.Like the ERRORLOG file f …

Do Not Set Trustworthy On for the SSISDB Catalog

Publié le 28 janvier 2020 sur sqlservercentral.com
 

The Problem Recently, we suddenly started having issues with deploying SSIS-packages to our SSISDB catalog on SQL Server 2016 Standard Edition. I am writing this blog to share the solution we have found, which I have not been able to find anywhere onli …

PASS Summit 2020

Publié le 28 janvier 2020 sur sqlservercentral.com
 

The post PASS Summit 2020 appeared first on SQLServerCentral.

Automate SFTP File Transfer with SQL Server Agent and WinSCP

Publié le 28 janvier 2020 sur sqlservercentral.com
 

The post Automate SFTP File Transfer with SQL Server Agent and WinSCP appeared first on SQLServerCentral.

Securing Data in SQL Server

Publié le 27 janvier 2020 sur sqlskills - jonathan kehayas
 

Recently I have been having quite a few discussions around security of data inside of SQL Server and how to prevent the massive data breaches that we have been hearing about on the news.  Like most things some people want “THE ANSWER” …

Why Database Monitoring Tools Are So Hard to Interpret

Publié le 27 janvier 2020 sur brentozar.com
 

SentryOne’s Greg Gonzalez recently published a post about “Why Wait Stats Alone Are Not Enough.” Sure, Greg’s obviously biased towards his own monitoring tool, but his post is really well-written and fair. I want to explain the …

SQL SERVER – Display Rupee Symbol in SSMS

Publié le 27 janvier 2020 sur journey to sqlauthority
 

Recently, I was reached out by one of the my financial technology clients based out of the USA who has just launched their services in India. Their system worked fine in most of the area but the challenge was to display the Indian currency sign. They r …

Basic Concepts of Probability Explained with Examples in SQL Server and R

Publié le 27 janvier 2020 sur sqlservercentral.com
 

The post Basic Concepts of Probability Explained with Examples in SQL Server and R appeared first on SQLServerCentral.

Month-over-Month calculation using DAX in Power BI

Publié le 27 janvier 2020 sur sqlservercentral.com
 

Introduction Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past. The goal is to adjust the slice of the past you are viewing …

What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261

Publié le 26 janvier 2020 sur journey to sqlauthority
 

Question: What are Different Methods to Know the Row Count of Table?Answer: The answer to this question is very simple and many. I have previously blogged about this topic many times. Here are a few sample questions one can on this topic:How many users …

SQL SERVER – Heaps, Scans and RID Lookup

Publié le 25 janvier 2020 sur journey to sqlauthority
 

Today we will discuss a question which I was recently asked by my client during the Comprehensive Database Performance Health Check. The question was do heaps are very bad and always force a table scan? The answer is NOT Always, whenever there is a cas …

Updated First Responder Kit and Consultant Toolkit for January 2020

Publié le 24 janvier 2020 sur brentozar.com
 

A couple of times a year, I disconnect from the Internet to sit down with a planning book, my Epic Life Quest, and my future task list. I spend time making sure my day-to-day tasks are still prioritized right. When I do that, I often find out that I …

SQL SERVER Tools I Use and Recommend (Updated: January 2020)

Publié le 24 janvier 2020 sur journey to sqlauthority
 

One of the most popular questions I often receive during Comprehensive Database Performance Health Check is which are the third-party tools I use in my daily routine and I recommend them. Here is the updated list for January 2020 of all the tools which …

Monitoring SQL Server with Splunk and SQL Monitor

Publié le 24 janvier 2020 sur sqlservercentral.com
 

The post Monitoring SQL Server with Splunk and SQL Monitor appeared first on SQLServerCentral.


Pages :