Sites anglophones


SQL SERVER – Memory Optimized Tables, Transactions, Isolation Level and Error

Publié le 11 juin 2019 sur journey to sqlauthority
 

Today we will see an interesting story about Memory Optimized Tables, Transactions, Isolation Level and Error. While I was working with my customer with Comprehensive Database Performance Health Check, we came across a very interesting situation.My cus …

Slower is Faster

Publié le 11 juin 2019 sur sqlservercentral.com
 

I recently had the privilege of attending the Redgate hosted SQL in the City Summit in London. It was a great event and the highlight of my day was to talk to Steve Jones and Grant Fritchey. However, something bothered me on one of the topics which Ste …

What Happens to DBAs When We Move to the Cloud?

Publié le 10 juin 2019 sur brentozar.com
 

I’m finishing up a bit of a summer tour – Techorama Belgium, SQL Saturday Dallas, SQL Saturday South Florida, and this week, SQL Intersection in Orlando – and I’ve gotten the same question from several attendees. It goes somethi …

Managing Always Encrypted Locally Stored Certificates in PowerShell

Publié le 10 juin 2019 sur sqlservercentral.com
 

Many applications need access to sensitive information such as credit card numbers, Social Security numbers, or even just legal names and addresses. This data is usually stored in your database, and one of your options for securing that data is by usin …

How Much Memory is in Locked Pages? – Interview Question of the Week #228

Publié le 9 juin 2019 sur journey to sqlauthority
 

Question: How Much Memory is in Locked Pages?Answer: Before we see the answer to this question, I suggest you read the blog post here first which I had written last year. What is Lock Pages In Memory? – Interview Question of the Week #186When ena …

SQL SERVER – Script: Find Last System / Operating System Reboot or Restart Time

Publié le 8 juin 2019 sur journey to sqlauthority
 

Sometimes we need to find last reboot time of the server via some script. In this blog, I am sharing the script to find the last system reboot time.I have written blog earlier to find last restart time of SQL Server. When Was SQL Server Last Restarted? …

Updated Stack Overflow Public Data Set for June 2019

Publié le 7 juin 2019 sur brentozar.com
 

The place that saves your job Taryn and the kind folks at Stack Overflow have updated their public XML data dump for June, so I’ve imported that into an updated sample database for your blogging and presenting satisfaction. You can download the 4 …

SQL SERVER – FIX: Msg 7416 – Access to the Remote Server is Denied Because No Login-mapping Exists

Publié le 7 juin 2019 sur journey to sqlauthority
 

While working with a client, I encountered few errors while using linked server and I am going to share my solutions via a few blog posts. In this blog we would talk about fixing error 7416 – Access to the remote server is denied because no login …

SQL Server and R with dplyr Package Examples for mutate, transmute, summarise, group_by, pipe and filter

Publié le 7 juin 2019 sur sqlservercentral.com
 

The post SQL Server and R with dplyr Package Examples for mutate, transmute, summarise, group_by, pipe and filter appeared first on SQLServerCentral.

What’s Better, CTEs or Temp Tables?

Publié le 6 juin 2019 sur brentozar.com
 

I get this question a lot, so let’s set up an example with the Stack Overflow database. My query’s goal is to: Find the top 5 Locations List the users who live in those top 5 Locations, alphabetized by their DisplayName There are a LOT of w …

SQL SERVER – Detecting Database Isolation Level MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT

Publié le 6 juin 2019 sur journey to sqlauthority
 

Yesterday one of my previous customer with whom I worked on Comprehensive Database Performance Health Check reached out me with a very simple but very interesting question related to Detecting Database Isolation Level MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSH …

SQL Server function to convert integer date to datetime format

Publié le 6 juin 2019 sur sqlservercentral.com
 

The post SQL Server function to convert integer date to datetime format appeared first on SQLServerCentral.

Coffee Mug – Indexes and SELECT Queries

Publié le 5 juin 2019 sur journey to sqlauthority
 

Sometimes I feel like I have become a kid again when I do a blog post such as today but it is indeed the best part of running a blog tirelessly for over 13 years. This morning I received a coffee mug with printed quotes of Indexes and SELECT Queries.Ha …

Monitor SQL Server Integration Services Packages Stuck in Running Status

Publié le 5 juin 2019 sur sqlservercentral.com
 

The post Monitor SQL Server Integration Services Packages Stuck in Running Status appeared first on SQLServerCentral.

Tips for Better Presentations

Publié le 4 juin 2019 sur brentozar.com
 

Today’s post is for those of you who give presentations to user groups and conferences. Upload your resources before the session starts. When you say “I’ll upload the resources later,” the attendee hears you saying, “I …


Pages :