The 2017 Company Retreat in Photos: Alaska
For our annual company retreat, we flew to Seattle, boarded the Ruby Princess, and visited Juneau, Skagway, Ketchikan, and Victoria. No stories or explanations – just photos. Enjoy! Ruby Princess in Alaska After kayaking in Chilkoot Lake Lots of …
What does Keyword STATS Indicates in Backup Scripts in SQL Server? – Interview Question of the Week #138
Question: What does Keyword STATS Indicates in Backup Scripts in SQL Server? Answer: This is a very interesting question. I have seen many DBA using the backup scripts and using the keywords STATS but when I ask them if they really know why they a …
Connect Logic Apps to Data Lake Store using a service principal
You can read this blog post at this link: https://jorgklein.com/2017/08/31/connect-logic-apps-to-data-lake-store-using-a-service-principal This blog has moved to www.jorgklein.com There will be no further posts on sqlblog.com. Please update your feeds …
Blog moved!
This blog has moved to www.jorgklein.com There will be no further posts on sqlblog.com. Please update your feeds accordingly. For a limited time I will continue to keep sqlblog.com updated by posting a link when I publish new posts on jorgklein.com You …
Using AT TIME ZONE to manipulate and convert time zones
I have a series of blogs about temporal tables in SQL Server 2016, which you can see here . However, one thing I never had mentioned was that the Temporal Row Start and End Times are always stored in UTC times (which is generally inconvenient to work w …
SQL SERVER – How to Rename Extention of MDF File? – A Simple Tutorial
The other day while working with a customer during SQL Server Performance Tuning Practical Workshop, I noticed an MDF file with very strange extensions. When I asked the DBA why they have such a large data file with extension PDF (instead of commo …
Troubleshooting SQL Server Performance Problems
Sponsored by: IDERA Date: Thursday, October 26, 2017 – Time: 02:00 PM Eastern Daylight Time – Duration: 1 hour read more
Best Practices for SQL Server Backup and Disaster Recovery
Sponsored by: IDERA Date: Thursday, September 28, 2017 at 2:00 PM EDT – Duration: 1 hour read more
Should You Enforce Foreign Key Relationships in the Database?
It’s one of those fierce religious wars that divides families and tears loved ones apart. First, if two tables are related, should we tell SQL Server about it? If SQL Server knows that there’s a relationship, then it can make better decisio …
Learning designed for the data professional
– PASS Summit offers five educationally-packed days lead by highly-rated, experienced speakers and sessions focused on the way you work with data. Speaker highlights include Bob Ward, and Sunil Agarwal from the Microsoft Tiger Team. Join us Oct 31 to N …
SQL SERVER – How to Install SQL Server Management Studio (SSMS) From Command Line?
SQL Server Management Studio (SSMS) has been removed from the product release cycle. Now SSMS is shipped as a free tool and doesn’t need to have set up media to install. Earlier I wrote a blog which you can read below. SQL SERVER – Installi …
Upgrading SQL Server– Intel Xeon-W Family
On August 30, 2017, Intel released their new Intel Xeon Processor W Family of one-socket workstation processors (hence the W) based on the Skylake-SP Xeon server processors. These processors are meant as a replacement for the older one-socket Intel Xeo …
Upgrading SQL Server– Database Experimentation Assistant
Another useful, if somewhat complicated, free tool from Microsoft is the Database Experimentation Assistant (DEA). Microsoft released DEA version 2.1 on July 25, 2017, with many new improvements over the earlier preview versions as detailed here. Here …
First Responder Kit Release: Fully Hand Automated
Did you know there are more issues closed in this FRK than there are planets in this solar system? Special thanks to Pluto for making that statement possible, and all the other planets that didn’t form. Also thanks to @mches for making …
SQL Code Smells
Table of Contents Introduction 1. Problems with Database Design 1.1. Packing lists, complex data, or other multivariate attributes into a table column 1.2. Using inappropriate data types 1.3. Storing the hierarchy structure in the same table as the ent …