SQL SERVER – Memory Optimized Tables, Transactions, Isolation Level and Error
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
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?
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
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
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
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
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
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
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?
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
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
The post SQL Server function to convert integer date to datetime format appeared first on SQLServerCentral.
Coffee Mug – Indexes and SELECT Queries
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
The post Monitor SQL Server Integration Services Packages Stuck in Running Status appeared first on SQLServerCentral.
Tips for Better Presentations
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 …