SQL Server Bugs That Might Bite You
I’m on my way to give a presentation at the PASS Database Administration Virtual Chapter about SQL Server bugs. All the materials...
2014-12-10
500 reads
The Truth About Index Fragmentation
In just a little while, I’m going to give a presentation at the PASS Performance Virtual Chapter. You can download...
2014-11-20
457 reads
Show Only Specific Databases
One of our customers is implementing a very large consolidation project in which they enable users to create their own...
2013-01-08
310 reads
SELECT Top 4 Bugs FROM DBAs IN SQL Server
I gathered the 4 most common bugs I find DBA are using in their code. Feel free to send me...
2012-11-11
462 reads
Parallel Processing For Pros
Hi,
Yesterday I delivered a session on Parallel Processing at the Israeli User Group.
I had a great time and hope you...
2012-06-05
317 reads
Update Statistics and the new TraceFlag 2371
What comes first, the chicken or the egg? What happens first – update statistics or re-compilations?
The Statistics life cycle
As a regular...
2012-01-18
370 reads
Pro and Cons of Parameter Sniffing
Look at the following 3 scripts:
-- 1. Hardcoded
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime < '19900101'
-- 2. Variable
DECLARE @FilterDate DATETIME = '19900101'
SELECT
*
FROM
Sales.Orders
WHERE
DateAndTime...
2012-01-02
442 reads
2011-09-03
345 reads
Answer to the Quiz
Hi Everybody,
Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course...
2011-08-28
324 reads
Answer to the Quiz
Hi Everybody,
Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course...
2011-08-27
440 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