Recovering Scripts After SSMS Crash
It happens to the best of us and this post is more of a reminder for myself the next time it happens to me than anything else. You are working in SQL Server Management Studio, you have a few tabs open (OK, it was 123 this time, but lets stay focu …
A One-Slide Summary of the Differences Between TDE and Always Encrypted
The folks on Twitter liked this, so sharing it here: It’s a one-slide summary from a SQL Critical Care client’s deck, so obviously it’s abridged, but I think it does a pretty good job of summing things up. Some highlights of the conve …
Install MongoDB on Windows – SQL in Sixty Seconds #091
SQL Server is my passion and I have been keeping busy most of the time in my career doing. While SQL Server is my primary expertise, I also focus on MariaDB, PostgreSQL, MySQL and many other relational databases. However, in the real world, it is not a …
Tracking use of Deprecated SQL Server Features
The post Tracking use of Deprecated SQL Server Features appeared first on SQLServerCentral.
SQL in Sixty Seconds – Need Your Feedback
I have been writing about SQL Server Blog for over 13 years now and I have been also creating various different videos on SQL Server Performance Tuning topics. I have recently decided to spend more time in building the videos and have created three vid …
Honorifics in the 21st century
I have been a data professional on and off since my first full time job in 1997, though my work with data started long before that when I would catalogue my family’s music collection in a spreadsheet. Categorizing things is part of our nature as data p …
Getting Started with Azure Blueprints
The post Getting Started with Azure Blueprints appeared first on SQLServerCentral.
The security_error_ring_buffer_recorded event and why you don’t need it
I recently ran through a health audit for a customer, and in reviewing their system_health output I was reminded of the unnecessary security_error_ring_buffer_recorded event. That’s right: you don’t need it in your system_health …
Remember “Nothing Stops a Hekaton Transaction?” Yeah, About That.
When In-Memory OLTP first came out, Microsoft liked to go around bragging at conferences that “Nothing stops a Hekaton transaction.” I remember hearing that and kinda chuckling at the time, and I was reminded of it by a recent client who wa …
Creating Covering Index to Eliminate Join – SQL in Sixty Seconds #090
Last week, I had published Remove Bookmark Lookup – SQL in Sixty Seconds #089 and I got a tremendous response to the video. Lots of people reached out to me with lots of questions. I have written a follow-up series to this video as well. You may …
Creating a Simple Development Harness with SQL Compare and SQL Data Generator
The post Creating a Simple Development Harness with SQL Compare and SQL Data Generator appeared first on SQLServerCentral.
What SQL ConstantCare® Has Been Finding In Your Servers Lately
SQL ConstantCare® analyzed over 3,000 of your SQL Servers this month. Here are the things we check for and the number of servers where we found this problem this month: Backup Back Up Your TDE Certificate – 137 servers affected Take a Fu …
SQL SERVER – 7 Follow Up Answers to Remove Bookmark Lookup
Earlier last week, I published a blog post and SQL in Sixty Seconds video and it got thousands of view in just a few hours and I have received lots of questions based on this question about how to remove bookmark lookup. I have taken the 7 most asked q …
Exploring the SQL Compare Options
The post Exploring the SQL Compare Options appeared first on SQLServerCentral.
How to Expand a Range of Dates into Rows using a SQL Server Numbers Table
The post How to Expand a Range of Dates into Rows using a SQL Server Numbers Table appeared first on SQLServerCentral.