(Chris Webb) About two years ago I wrote a blog post describing how the #table M function can be used to generate tables, but in that post I only covered the functionality I used regularly – namely using #table with a list of column names or a table type in the first parameter.
Tag: sql server
Updated query to view data in the error log
(Kenneth Fisher) This is one of my favorite scripts. It pulls all of the data from the error log and dumps it into a temp table. I did one version here but it was pretty specific to I/O errors.
Using Managed Service Identity (MSI) with and Azure App Service or an Azure Function
(benjaminperkins) Instead of storing user id / passwords or database connection strings in source or configuration files, you should consider storing them in an Azure Key vault.
SQL SERVER – Impact of Transaction on the Free Log Space
(Pinal Dave) Earlier I wrote a blog post about SQL SERVER – How to Find Free Log Space in SQL Server? After reading this blog post, I received the following question from one of the users about the impact of the transaction on the free log space.
SQL Server error query processor ran out of internal resources and could not produce a query plan
(Bhavesh Patel) We recently upgraded from SQL Server 2014 to SQL Server 2016 and started to get these error messages “Msg 8623, Level 16, State 1, Line 1 The query processor ran out of internal resources and could not produce a query plan…”. In this tip I will discuss this error for more clarific
Azure SQL Database – The Default Isolation Is?
(blobeater) So what is the default isolation level for Azure SQL Database? I ran the following code to check it out.
Indexing in SQL Server is becoming more of an art form with each new version
(Denny Cherry) Back in the old days of SQL Server 2012, we’d always tell people that creating indexes was half art and half science. And that’s true, but we’d create some non-clustered indexes (designed correctly of course), and the system would magically go faster.
ORDER BY newid() is an Unbiased Way To Randomize
(Michael J. Swart) Mike Bostock is a data-visualization specialist. And it really shows in his blog. Every article is really well designed (which makes sense… many of the articles are about design).
SQL SERVER – Reading Transaction Log to Identified Who Dropped a Table
(Pinal Dave) The other day I received a distress email from a user who wanted to find out who has dropped a table or column from their database. During the On Demand (55 minutes) consultation, not only I was able to help them with restoring their lost data but also was able to find out which user ha
How (I) would handle a timeout in Azure Function
(benjaminperkins) I wrote this article about adding a host.json file to an Azure Function “How to add a HOST.JSON file to an Azure Function” and while I was breaking it, I saw a behavior which I didn’t expect.