Keep Your Data Clean
In working with client data you start to notice trends that raise flags in your mind. In my case I'm...
2010-03-05
502 reads
Allen White
- Interests: Running, Theatre, Flying, SQL Server
Speaking at SQLSaturday #33 in Charlotte
I'll be presenting two sessions this Saturday (March 6, 2010) in Charlotte - Automate SQL Server Administration with PowerShell and Gather...
2010-03-04
573 reads
Bookstores and Databases
My wife is a Board member for Project LEARN in Medina County, Ohio (just southeast of Cleveland). Last night at...
2010-03-03
338 reads
T-SQL Tuesday #3: Database Relationships
In my first T-SQL Tuesday submission I thought I'd mention something that we often take for granted when working with...
2010-02-10
457 reads
Speaking about Indexing
I'll be presenting two sessions this week (February 9 and 11, 2010), both on SQL Server Indexing. The first is...
2010-02-08
349 reads
Speaking at SQLSaturday #30 in Richmond
I'll be presenting two sessions this Saturday (January 30, 2010) in Richmond - Automate SQL Server Administration with PowerShell and Gather...
2010-01-25
367 reads
PASS 2009 Evaluation Results
The results are in, and I'm pleased, but not satisfied. I delivered a brand new session called Gather SQL Server...
2010-01-13
413 reads
Service Broker Basics - Part Deux
Last week I introduced the Service Broker Basics . Today I'd like to cover some of the "plumbing" - the components that...
2010-01-12
477 reads
Service Broker Basics
I'm currently implementing a Service Broker solution at a client site, and it's been an interesting challenge, because there's not...
2010-01-06
535 reads
[OT] Happy New Year
Well, it's been an interesting year. I got to teach four different brand new SQL Server courses, and teach classes...
2009-12-31
1,342 reads
Blogs
AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped
Running AI and data pipelines on the edge instead of the cloud has gone...
UNION vs UNIONALL: #SQLNewBlogger
By Steve Jones
While writing another post I realized my UNION query didn’t work as one might...
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Forums
Secure Cached Plans
Comments posted to this topic are about the item Secure Cached Plans
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform
Comments posted to this topic are about the item Complex Data Processing with dbt...
Over or Under Provisioned
Comments posted to this topic are about the item Over or Under Provisioned
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