Azure DWH part 22: Dynamic Management Views
The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.
Is the old stuff worth learning?
Often we are encouraged to learn the latest things, but sometimes the old stuff is worth knowing too.
Query Plan Oddities: Two Identical Missing Indexes
Brent demos a single query plan that asks for 2 identical indexes on the same table.
The Case of the Shrinking CFO, err Database
Shrink SQL Server databases quickly and with virtually no contention.
Why Haven’t You Upgraded SQL Server?
Kathi Kellenberger wonders what's keeping your business from upgrading.
Cascading Update and Delete for SQL Server 2017 Temporal Tables
Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.
Securing Reporting Services Reports
Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.
VMs for Development
Many technical people use Virtual Machines to build their own lab or test environment. Today Steve Jones asks how you've built your setup.
New Azure SQL Database Standard Tier Sizes
Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Forums
Rethinking How We Approach Assignment Help
Assignments aren’t just tasks to submit—they’re opportunities to build understanding, discipline, and problem-solving skills....
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers