How to Build a Cost Effective Virtual Desktop for Your Remote Teams
In this article we look at how you can easily build virtual desktops that you can deploy to your teams using Amazon WorkSpaces.
2020-11-06
Additional Articles
Questions about SQL Prompt you were too shy to ask
Phil Factor answers some questions you've been itching to ask about SQL Prompt, covering ranked code completion suggestions and auto-fixing SQL code smells, and suggesting where in the tool to find other nuggets of hidden treasure.
2020-11-06
Git Anatomy
In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch.
2020-11-05
Explore the Role of Normal Forms in Dimensional Modeling
In this tip we walk through an exercise of developing a data model based on the characteristics of the data requirements.
2020-11-04
Monitoring Amazon RDS SQL Servers with SQL Monitor v11
SQL Monitor v11 introduces native support for SQL Server instances hosted on Amazon Web Services (AWS) Relational Database Service (RDS) platform. In this post we'll explore the metrics you need to keep an eye on with Amazon RDS SQL Server monitoring, how a monitoring tool will help you manage the process of migrating databases to the Amazon cloud, as well as measures its success, and how SQL Monitor allows you to monitor all your SQL Server instances, wherever they are hosted, through a single pane of glass.
2020-11-04
Static Hosting with Azure Blob Storage and Azure CDN
No matter what you need, Azure probably has a solution. In this article Diogo Souza demonstrates how to host a static web page in Azure in just a few steps with Azure Blob Storage and Azure CDN.
2020-11-03
Managing Power BI Workspaces with PowerShell
In this article we look at how to manage Power BI workspaces using PowerShell cmdlets.
2020-11-02
SQL IntelliSense and Autocomplete in SSMS
Phil Factor reviews the major features of SSMS IntelliSense and autocomplete and then explains how SQL Prompt fills in the gaps, and how to use to use the two in tandem to 'get the best of both worlds'.
2020-11-02
Efficiently Polling Remote Data Sources
In this article, Edward Pollack describes some of the issues when querying against remote data sources. He covers remote SQL Servers and also connecting to a PostgreSQL database.
2020-10-30
Adding Custom Stored Procedure Templates to SQL Server Management Studio and Visual Studio 2019
In this article we look at how to build a custom stored procedure template that can be used in either SSMS or Visual Studio for all new development.
2020-10-29
Blogs
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
The Only Valid Test of a Backup is a Restore
Please, let me reiterate: The only valid test of a backup is a restore....
Comparing an Old Running Total to Window Functions
By Steve Jones
Often I see running totals that are written in SQL using a variety of...
Forums
Help with index rebuild
Hi there! This should make some eyes roll for some of you DBA's out...
Cannot connect to Analysis Services via Excel
For myself this seems to work and for other users they receive this error:...
Azure Managed Instance Backup Schedule with SQL Job
Lets do configure backups in my own in Azure Managed Instance......My Lead has directed...
Question of the Day
Migration Assistant Issues
If I run the Data Migration Assistant to check for an upgrade from SQL Server 2008 to SQL Server 2022, which categories of issues are pointed out as potential items that can affect an upgrade? (choose 3)
See possible answers