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.
Recover Recently Closed Tab in SSMS
Learn different ways to recover a T-SQL script when using SQL Server Management Studio if SSMS is accidently shutdown without saving the script.
Building a PC
Steve has a few thoughts on building your own PC to help you with work or your career.
The benefits of database change management
Using a change management system for database code is a new idea for many database administrators. Grant Fritchey explains the many benefits of database change control.
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers