SQL Server 2017 – SELECT INTO [A SPECIFIC FILEGROUP]
Forget about Adaptive Query Processing for a minute, what other feature have I been waiting for? SELECT INTO a specific...
2018-06-19
574 reads
All About SQL
Azure SQL DB – Login failed for user NT AUTHORITY\ANONYMOUS LOGON.
Now that I have your attention with a powerful title how about some context? It is quite common to get...
2018-06-26 (first published: 2018-06-15)
2,298 reads
Azure SQL Database – Stairway Series
Hello all – I am excited to announce that I will be doing a Stairway series on Azure SQL Database hosted...
2018-06-13
388 reads
Linked Server to Azure SQL Database
You may (or may not) have a requirement to setup a linked server to Azure SQL Database from a locally...
2018-06-13 (first published: 2018-06-05)
1,849 reads
Azure SQL Database – The Default Isolation Is?
So what is the default isolation level for Azure SQL Database? I ran the following code to check it out....
2018-05-30
409 reads
Azure SQL Database / SQL Server – Paused Index Rebuild
I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when...
2018-05-30 (first published: 2018-05-22)
1,883 reads
Handy TSQL for Azure SQL Database
I do not always use the Azure portal to make database changes or to check for certain information. I use...
2018-05-14
321 reads
Extended Events – Using Azure Storage
Last year I wrote about Azure SQL Database extended events (https://blobeater.blog/2017/02/06/using-extended-events-in-azure/) and gave an example where I was capturing deadlocks...
2018-05-21 (first published: 2018-05-08)
1,423 reads
Getting my Twitter Data via Azure Logic Apps
As a mini project I wanted to use Azure logic apps to pull tweets from my twitter account when people...
2018-05-02
330 reads
Azure SQL Database – A Copying “Gotcha”
Creating copies of your Azure SQL Database is a common and relatively simple process. You can issue a TSQL statement...
2018-04-24
351 reads
Blogs
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Forums
printing complete path
get-ChildItem C:\ -recurse -erroraction silentlycontinue | sort length -descending | select -first 10 FullName,length...
Vendor claims unused table space impacts performance
Hello experts, I got a report from an application owner of degraded performance for...
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers