Professional Development

SQLServerCentral Editorial

Small Changes, Big Results

  • Editorial

Last week I was able to attend THAT conference in Wisconsin Dells, Wisconsin. It was my first time in the great state of cheese, and the conference lived up to its reputation. As a developer focused conference (rather than a database conference), I didn't have much expectation that my session about automating database changes would […]

(1)

You rated this post out of 5. Change rating

2023-08-05

1,843 reads

SQLServerCentral Editorial

What Counts for a DBA: Skill

  • Editorial

Practice makes perfect:” right? Well, not exactly. The reality of it all is that this saying is an untrustworthy aphorism. I discovered this in my “younger” days when I was a passionate tennis player, practicing and playing 20+ hours a week. No matter what my passion level was, without some serious coaching (and perhaps a […]

(1)

You rated this post out of 5. Change rating

2021-08-14

251 reads

Blogs

Microsoft Purview data governance best practices

By

Microsoft Purview can be the best data governance tool in the world, but it...

AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped

By

Running AI and data pipelines on the edge instead of the cloud has gone...

UNION vs UNIONALL: #SQLNewBlogger

By

While writing another post I realized my UNION query didn’t work as one might...

Read the latest Blogs

Forums

Replacing Maintenance tasks now using SSMS 22 - what to do with File operations

By terry999

Unfortunately I'm using SSMS 22. It didn't come with maintenance plans by default. I...

Secure Cached Plans

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Secure Cached Plans

Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Complex Data Processing with dbt...

Visit the forum

Question of the Day

Secure Cached Plans

The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?

See possible answers