How to Use SQL Server Features to Cut Web App Latency in Half
Discover how SQL Server features reduce web app latency. Learn key tactics to deliver faster queries and better performance in today’s web economy.
Building a Dynamic Countdown Timer in Power BI
A countdown timer can be a powerful visual tool in many Business Intelligence reporting scenarios. This could be for marketing campaigns, contract expiries, and business deals with clients. Real-time countdown visuals are not natively supported in Power BI. Although, there is the Count Down Timer custom visual, which is not dynamic in its configuration.
Building AI Governance and Policies- First Steps
AI has moved from experimental to operational in record time for many organizations. In industries like fintech, healthcare, and retail where sensitive PII (personally identifiable information) and relational databases are the backbone of daily operations, this innovation speed to adopt AI brings enormous opportunity, but also significant risks
Building a Simple SQL/AI Environment
This article shows a simple way to integrate a local GEnAI model into your T-SQL work.
Don't Forget About Financial Skills
A bit of advice from Steve to ensure you do not neglect the management of your finances for the long term.
Power BI TMDL View: Benefits, Security Risks & Best Practices
The Tabular Model Definition Language (TMDL) provides a simpler way of defining Power BI Semantic Models. Unlike the JSON-based Tabular Model Scripting Language (TMSL), TMDL uses a more accessible tab-based format for specifying DAX measures, relationships, and Power Query code.
Getting More Time from AI
Today Steve wonders what you might do with extra time if the AI can give it to you.
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Learn how a trace flag affects SQL Server reading from disk and where this might be a useful thing for you to enable.
Side by Side Upgrade to SQL Server 2022
As a SQL Server DBA, the migration of SQL Server from an existing version to the latest version is a usual activity. In today’s cloud-oriented world, many organizations still prefer an on-prem environment; my organization is one of them. There are multiple reasons to keep your data on-prem, like having more privacy and control of the environment. Currently, our major project is to migrate our existing Microsoft SQL Server 2019 to SQL Server 2022. Recently, we completed the POC. Today, let’s discuss the steps of the SQL Server 2022 installation and migration of our databases.
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Surya Kencana Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
Alamat BCA KCP Ketapang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers