Handling the Duplication of Records
Learn how to easily identify and remove duplicate records when you discover them.
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.
NoSqlOnSql
Introduction NoSqlOnSql is a strict syntactical superset of SQL; it adds NoSQL document-oriented capabilities to the SQL language. For this, it uses uses JSON-like documents, integrating them into the normal flow of SQL statements. NoSqlOnSql is based on augmenting a SQL database to support NoSQL features without any kernel changes. In this sense it is […]
The Separation of Tools
SSMs and ADS are the new tools for SQL Server and the data platform, both of which are now available separately from SQL Server.
Managing Power BI Workspaces with PowerShell
In this article we look at how to manage Power BI workspaces using PowerShell cmdlets.
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'.
What is Possible?
There’s the old saying “Whether you think you can or you think you can’t -- you’re right” from Henry Ford. I’ve thought about this more recently while reading the book The Rise of Superman Decoding the Science of Ultimate Human Performance which talks about how athletes have performed so called impossible feats over the past few […]
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.
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kontak Resmi BCA KCU GADING SERPONG Telp:08218154393
WhatsApp:08218200205 Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia Garden No.001...
Alamat Kontak Resmi BCA KCP Kepa Duri Telp:08218154393
WhatsApp:08218200205 Jl. Mangga Raya No.20, RT.4/RW.3, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat,...
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers