(Vitor Montalvao) More and more Azure VMs are being deployed every day, but one of the issues is the cost. What can be done to reduce the costs of Azure VMs?
Tag: sql server
SQL SERVER – Removing Additional Transactional Log Files
(Pinal Dave) The best part of writing blogs is that I always get follow up questions from users. Recently I wrote two blog posts while working on Comprehensive Database Performance Health Check about additional transactional log files and today I got to follow up on questions via email.
Five Mistakes To Avoid When Migrating To Power BI From Another BI Platform
(Chris Webb) Now that Power BI is so popular, it’s becoming more and more common for organisations to migrate their reports from other BI platforms to Power BI. And why not?
Power BI Dashboard vs Report vs Workbook
(Koen Verbeeck) We are currently using Power BI as our self-service reporting and ad-hoc analysis tool. There are so many different ways to present data to the users that it becomes overwhelming.
How to Find the Estimation Cost for a Query
(Greg Larsen) In the processes of executing a query the database optimizer calculates an estimate at the cost to run the query. This cost is determined based on statistics.
Installing SQL Server 2019 on Azure VM
(blobeater) Unfortunately, this is not an on-premises SQL Server install because I do not have the right operating system available for SQL Server 2019, which includes the below:
SQL SERVER – Multiple Log Files to Your Databases – Not Needed
(Pinal Dave) The other day I was hired by a large consulting organization that is managing database operations for the bank Comprehensive Database Performance Health Check. The organizations wanted to have lots of performance issues and we worked through them one at a time.
Basics of Working with JSON in SQL Server
(Kenneth Igiri) JSON is an acronym for JavaScript Object Notation, that became popular a little over seventeen years ago. JSON is essentially a data format, it was popularized by Douglas Crockford, a well-known programmer with an interesting history who was also involved in the development of JavaSc
Securely Manage Database Credentials Using Visual Studio Manage User Secrets
(Sherlee Dizon) As a developer we are all familiar with using web.config or appsettings.json to store our database connection, user credentials and other application secret keys of our web applications. Last year I had an opportunity to explore and learn .Net Core and I learned that it is not secure
What Prevents You From Securing Your Servers?
(Grant Fritchey) Reading about how hackers are using SQL Server instances that are exposed on the internet AND have weak passwords to work into systems, I’m sitting here wondering why.