(2019-May-24) Data Flow as a data transformation engine has been introduced to the Microsoft Azure Data Factory (ADF) last year as a private feature preview. This privacy restriction has been lifted...
2019-06-11 (first published: 2019-05-24)
3,325 reads
In my blog post here https://the.agilesql.club/2019/06/what-steps-are-there-to-move-to-safe-automated-database-deployments/ I described the steps you need to go through so you can build up your confidence that you are capable of deploying databases...
2019-06-11
3 reads
In my blog post here https://the.agilesql.club/blogs/ed-elliott/2019-06-10/steps-to-automated-database-deployments I described the steps you need to go through so you can build up your confidence that you are capable of deploying databases...
2019-06-11
10 reads
Cosmos DB falls into the “NoSQL” technology group, call it a buzz word if you like but it is very different to classic Relational Databases such as SQL Server....
2019-06-10
205 reads
We know that indexes are necessary for query performance but comes with overhead during DML operations. Usually, the overhead is worth the performance gain we get out of them....
2019-06-10 (first published: 2019-05-21)
856 reads
In this post, we continue with another beginner’s blog of database features that may be unknown to many. Let’s take a look at filtered indexes. Many database administrators are...
2019-06-10 (first published: 2019-05-22)
765 reads
Hello there! Another week, another roundup of Internet interesting stuff. Press Microsoft Business Applications Summit The event is happening now in the Georgia World Congress Center in Atlanta, GA....
2019-06-10
15 reads
Use Case
Leveraging aws system manager sessions can help with aws development, by eliminating the need to RDP for work that can be done via a PowerShell session. In addition,...
2019-06-10
8 reads
[read this post on Mr. Fox SQL blog] For the longest time data science was often performed in silos, using large machines with copies of production data. This process...
2019-06-10
7 reads
[read this post on Mr. Fox SQL blog] For the longest time data science was often performed in silos, using large machines with copies of production data. This process...
2019-06-10
85 reads
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
i have sqlexpress on rds, is there any way i can get notifacation that...
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers