SQL server 2016 Sp1 CU4 regression error while applying permission on entity level, quick workaround
Sql Server 2016 Sp1 CU4 was recently released here https://support.microsoft.com/en-us/help/4024305/cumulative-update-4-for-sql-server-2016-sp1 . we made a significant improvement in terms of performance when working on Models tree view control which i …
SQL SERVER – How to Get Updated Link for Code and Database Samples?sample
Some emails, indeed triggers blog posts such as the one I received the other day about database samples. “Hey Pinal, I read your earlier blog posts related to how to install sample database wideworldimports. It was good, however we would love to …
[Video] Office Hours 2017/08/30 (With Transcriptions)
This week, Brent, Erik, and Richie discuss Availability Groups, versions of sp_BlitzIndex™, SQL Server installation issue, backing up SSRS reports, SQL Server on Linux, failovers, detaching/attaching databases, extended events, career progression …
How Much Can One Column Change A Query Plan? Part 1
Beyond Key Lookups I’m going to show you two queries, and two query plans. The two queries are only different by one selected column, but the two query plans are wildly different. Unless I’ve talked to you in the last few days, these may su …
Introduction to Azure Cosmos DB
Azure Cosmos DB is the latest data service offering from Microsoft. Azure Cosmos DB is a super set of DocumentDB and provides a new set of capabilities. These capabilities make Azure Cosmos DB stand out from other members in the NoSQL database family.
Azure DWH part 15: PolyBase and Azure Data Lake
In this article, we will learn how to query a csv file stored in the Data Lake using PolyBase.
SQL SERVER – Different Methods to Know COMPATIBILITY LEVEL of a Database
COMPATIBILITY LEVEL in SQL Server indicates the version of SQL Server with which the database is to be made compatible. Whenever you create a new database, compatibility level is set to that database. Sometimes you may need to change this so that some …
SQL Server Diagnostic Information Queries for September 2017
On September 1, 2017, Dropbox turned off the sharing feature that I was previously using to host these scripts, which broke hundreds of existing links on my blog. I will be switching to their new sharing method, at least temporarily, until I decide wha …
Protecting production data in non-production environments
In this article, Grant Fritchey looks at the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production environment.
SQL SERVER – Alternative to DBCC INPUTBUFFER – sys.dm_exec_input_buffer
DBCC INPUTBUFFER has been one of the most popular commands to display the last statement sent from a client to an instance of Microsoft SQL Server. We all have been using it for quite a while. However, this DBCC command showed very little information a …
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 …