SQL Database Overview
Learn about what a SQL database is, what is stored in a database and how to interact with a database.
SQL Monitor supports Amazon RDS Monitoring
SQL Monitor works with your SQL Server data, wherever that data exists, from local instances to AWS RDS and AWS virtual machines. You can keep an eye on your estate, regardless of where the data is.
Becoming a Better DBA
Steve has some advice on how to be a better DBA, or really better at whatever career you choose.
Understanding Shared Access Signature and Access Policy in Azure Storage
This article covers how you can give access with a shared key to Azure Storage Accounts and apply a policy for how users can access the files.
Introduction to artificial intelligence
Artificial intelligence applications are all around us, but what does it really mean? In this article, Kumar Abhishek explains the history and progress of artificial intelligence.
Summit 2022 Community Pre-cons have been announced
We’re delighted to announce the Summit community pre-conference sessions and speaker lineup! Choose from 14 pre-cons featuring Brent Ozar, Kimberly Tripp, Melissa Coates, Itzik Ben-Gan, Denny Cherry, and others, taking place on Monday Nov. 14 and Tuesday Nov. 15. Full-day pre-con sessions will cover topics including database performance tuning and troubleshooting, T-SQL querying, DAX, security, cloud VMs, Azure Data Factory, Azure infrastructure, parameter sniffing, Power BI, PostgreSQL, equity toolkits, and much more!
Dealing with Transaction Log Growth
Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reliably. The typical DML command used in SQL are INSERT, UPDATE and DELETE. When INSERT introduces new […]
Flawed Data Integration
These days we often have multiple applications that need to exchange data in use by customers. Steve shares a few thoughts on his recent experiences.
Power BI Report Builder Expressions - Date Functions
Learn about expressions and date functions in the Power BI Report Builder.
[Re-post] The 10 Benefits of Monitoring for Leaders
A third-party database monitoring tool is an investment that drives enormous value for the bottom line of a business in ten key ways, from simplifying cloud migration to retaining talent. Here's how.
Blogs
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Forums
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Pushing the Limits of AGs
Comments posted to this topic are about the item Pushing the Limits of AGs
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers