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.
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.
Automate MSBI deployments Using PowerShell
There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.
The Forever Technology War
The differences in our understanding of technologies can make for some communication challenges.
Git Anatomy
In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch.
Maintaining Data in a Flow
One of the challenges of using scripts is maintaining them and ensuring the adapt over time.
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.
Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".
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.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Atrium Tlpn/wa:085373737551
Ruko Atrium Blok E. 12-13, RW.2, Senen, Kec. Senen, Kota Jakarta Pusat, Daerah Khusus...
BCA KCP Kreo Ciledug,Telp/Wa 0821.3111.159
Jl. HOS Cokroaminoto Jl. Ciledug Raya, RT.001/RW.006, Kreo Selatan, Kec. Larangan, Kota Tangerang, Banten...
BCA KCP Abdul Muis Tlpn/wa:085373737551
Gedung Graha Motor City, Jl. Abdul Muis No.24-26 Level I Suite 101, Petojo Sel.,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers