(James Serra) As I see a huge number of customers migrating their on-prem databases to the Azure cloud, the main question they ask is about whether they should go with an IaaS solution (SQL Server in a VM) or a PaaS solution (SQL Database).
Tag: sql server
(Julie Koesmarno) G’day! In this blog post, I’d like to touch on how Data Analysts can leverage SQL Notebooks (available in Azure Data Studio) to document their analysis, to share their methods / techniques and to collaborate with others so that they can reproduce the analysis and/or they can extend
(Pinal Dave) SQL Server Performance tuning is an amazing subject, it never stops to amaze me. Every single day, I take only one Comprehensive Database Performance Health Check and keep the rest of the time open for either learning new stuff or helping people with On Demand (50 Minutes).
(Joe Gavin) You need to create an automated process to transfer files using Secure File Transfer Protocol (SFTP) with SQL Server Agent. Check out this article to learn how.
SQL SERVER – SSMS Install Error 0x80070652 – Setup is Blocked Due to Another Install Currently running. Please Let the Other Install Complete and then Restart the Computer if Necessary
(Pinal Dave) While preparing for a demo for my client Comprehensive Database Performance Health Check, I was installing necessary applications on my laptop. In this blog, I would share my experience with SQL Server Management Studio SSMS install error – Setup is blocked due to another install curren
(Jack Vamvas) Question: In the application error logs there is a message – The DELETE statement conflicted with the REFERENCE constraint FK_xxxxxxxxx
(Nai Biao Zhou) Many organizations have known the fact that data have been evolved from the by-product of corporate applications into a strategic asset . Like other corporate assets, the asset requires specialized skills to maintain and analyze.
(Hadi Fadlallah) There are many operations that we may run while working with OLAP cubes such as cube and partitions processing, executing administrative tasks, performing analysis and more…
(Kenneth Fisher) The other day I saw a weird option for the UPDATE command in a stack overflow answer. Basically it looked like this:
(Pinal Dave) Earlier this week, I wrote a blog post about SQL SERVER – Top Reasons for Slow Performance. The blog post got extremely popular as it contained many real-world problems and suggestions. After the blog post was released, I received quite many emails and questions.