The Curious Engineer

All blogs / Databases

Blog do Ezequiel

learn.microsoft.com/en-us/archive/blogs/blogdoezequiel

SQL Server Insights

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
153 from 29 Oct 2008 to 29 Mar 2019
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/blogdoezequiel/feed.xml

2019 1

  1. We have moved!

2018 4

  1. Developer’s Choice: Hinting Query Execution model
  2. Predicate Pushdown and why should I care?
  3. More Showplan enhancements – UDFs
  4. More Showplan enhancements – Row Goal

2017 12

  1. Perfect statistics histogram in just few steps
  2. Making parallelism waits actionable
  3. New Showplan enhancements
  4. Persisting statistics sampling rate
  5. New in SSMS: Searching in Showplan
  6. New in SSMS: Performance Dashboard built-in
  7. Correlating xEvents with DMVs
  8. SQL Server 2017 Showplan enhancements
  9. New in SSMS: Query Performance Troubleshooting made easier!
  10. Easy way to get statistics histogram programmatically
  11. Getting more statistics information programmatically
  12. Unicode strings and implicit conversions

2016 17

  1. Extended per-operator level performance stats for Query Processing
  2. Query progress: anytime, anywhere
  3. Developers Choice: USE HINT query hints
  4. Developers Choice: CREATE OR ALTER
  5. New Showplan XML properties in SSMS October Release
  6. 24HOP - Portuguese Edition 2016
  7. AdaptiveIndexDefrag and Maintenance Solution moved to GitHub
  8. Tiger speaking at PNWSQL User Group
  9. Operator progress changes in LQS
  10. Memory grant related diagnostics
  11. MSSQLTIGER and May PASS Virtual Conferences
  12. Presenting at #SQLBits XV
  13. April updates to Plan Comparison Tool
  14. Added per-operator level performance stats for Query Processing
  15. What’s new with SSMS Plan Comparison Tool?
  16. Addressing large memory grant requests from optimized Nested Loops
  17. Index Usage DMV behavior updated

2015 7

  1. SQL Server 2016 – Added information on TempDB Spill events – xEvents
  2. SQL Server 2016 – Added information on TempDB Spill events – Showplan
  3. @@VERSION and SERVERPROPERTY – What changed?
  4. Comparison Tool released with latest SSMS
  5. Cardinality Estimation for Correlated Columns in SQL Server 2016
  6. Ninja Troubleshooting- User Interface freezing during SQL Server database restore.
  7. Building elastic and fault tolerant Data Platform solutions with Azure, SQL Server and HDInsight

2014 8

  1. When do conversions generate conversion warnings? And why are these bad?
  2. SQL Swiss Army Knife #15 - Handling duplicate indexes
  3. Have you heard of the EPM Framework?
  4. MDS 2012/2014: Where my soft deletes at?
  5. Too many single use plans, now what?
  6. Beam me up, Azure!
  7. SQL Swiss Army Knife #14 - Troubleshooting with Waits and Latches
  8. SQL Swiss Army Knife #13 – Exploring the plan cache – Part 2

2013 10

  1. Using DQS with SQL Server AlwaysOn AG
  2. Master Data Services Operations Guide released
  3. Programmatically find MS Shipped Databases
  4. SQL Swiss Army Knife #13 – Exploring the plan cache – Part 1
  5. PAGELATCH_EX waits and heavy inserts
  6. Microsoft BI Authentication and Identity Delegation white paper
  7. SQL Swiss Army Knife Series is indexed
  8. Premier TechTracks SQL Server is Live
  9. Ezequiel will be in the next SQL Saturday #188
  10. The Kerberos, SharePoint, Reporting Services and Internet Explorer case

2012 20

  1. Table variables and row estimations – Part 2
  2. Table variables and row estimations – Part 1
  3. Upgrading Data Quality Services (DQS) from RTM to SQL Server 2012 SP1
  4. About Maintenance Plans – grooming SQL Server
  5. SQL Swiss Army Knife #11.1 - Locking, blocking and active transactions
  6. Take most of Reporting Services Logs with Excel 2013
  7. A practical example on missing a filtered index
  8. SQL Swiss Army Knife #12 - Index information galore!
  9. SQL Server 2012 new high VLFs warning: Important update
  10. Free SQL Server 2012 eBook giveaway
  11. Ezequiel will be at the next SQLSaturday #115
  12. The SQL Swiss Army Knife #3 - View I/O per file - Updated
  13. A case of seeks and scans
  14. Antivirus Guidelines for SQL Server - KB 309422– It was Updated !
  15. SQLAzure – “SQL Azure Compatibility Assessment” and “SQL Azure Security Services” Services
  16. SQL Server 2012 – AlwaysOn (HA/DR)
  17. SQL Server 2012 – Online Launch Event
  18. PowerPivot Security Architecture
  19. T-SQL Misconceptions - JOIN ON vs. WHERE
  20. Three effective tips for Reporting Services management

2011 23

  1. SQL Server 2012 RC0 Released
  2. Can PerformancePoint have interactive features?
  3. How to configure cascading filters in Dashboard Designer (SharePoint 2010 SP1)
  4. The “rumor” is true: SQL Server 2012 has a new high VLFs warning (Edited).
  5. SQL Server 2008 SP3 RTM
  6. Auto Update Statistics Asynch - Are you really, really using it?
  7. What's new in Performance Point Services (SharePoint 2010 SP1)
  8. SQL Swiss Army Knife #10 - VLFs again. What’s your current status?
  9. Notes about SQL Server 2008 R2 SP1
  10. MOSS, BizTalk, SCOM and SQL Server Collations
  11. Adaptive Index Defrag
  12. How to integrate SSRS Reports with PerformancePoint Dashboards in SharePoint 2010
  13. SQL Swiss Army Knife #9 - Fixing VLFs
  14. SQLPort – XI Event – Don’t Miss it !!!
  15. Can log files growth affect DML? Post-CU Update
  16. Metro Early Adopter Program for SQL Server Code Name “Denali”
  17. SQL Swiss Army Knife #8 - Find a Maintenance Window
  18. SQL Swiss Army Knife #7 - Adaptive Index Defrag
  19. Loose notes on FILESTREAM…
  20. Best Practices on FILESTREAM implementations
  21. Latest updates available are…
  22. SQL Server 2008 R2 – New White Papers
  23. The SQL Swiss Army Knife #6 - Evaluating compression gains

2010 18

  1. The SQL Swiss Army Knife #5 - Checking Autogrow times
  2. SQL Server vNext – Codename “Denali” and much more …
  3. The SQL Swiss Army Knife #4 - Making sense of FILESTREAM containers
  4. Can log files growth affect DML?
  5. SQL Server 2008 SP2 is out!
  6. SQL Swiss Army Knife #2.1 - Scripting Logins - Updated
  7. SQL Server and Log File usage
  8. SQLPort – 1st Event – Summary
  9. SQL Server Setup Portal–Released Today!
  10. SQLPort – 1st Event – May 11th @Microsoft, Taguspark
  11. Operations Day (T-26 days) – May 31 – @Microsoft
  12. The SQL Swiss Army Knife #1 - Scripting Securables - Updated
  13. SQLPORT – Launched Today – Registration is Open!
  14. SQL Server 2008 R2 – RTM
  15. TechDays 2010 – Thanks
  16. SQL Server 2008 R2 – Free Ebook
  17. SQLPORT – SQL Server Portuguese Community
  18. TechDays 2010

2009 22

  1. Microsoft SQL Azure
  2. SQL Server 2008 R2 – November CTP
  3. Latest Cumulative Updates for SQL Server
  4. Project “Gemini” or just PowerPivot 2010
  5. Information about the SNAC package and Cumulative Updates
  6. Security Update – MS09-062
  7. New white papers for SQL Server were released
  8. SQL Server 2008 Failover Clustering White Paper
  9. SQL Server 2005 – Performance Dashboard installation steps
  10. SQL Server 2008 - Slipstream
  11. SQL Server 2005/2008 – How to know which are the latest builds available?
  12. SQL Server 2008 - Cumulative Update 4
  13. SQL Server 2008 - White Papers
  14. SQL Server Tools - Extended Events Manager & Partition Management
  15. TDS Parser for NetMon 3.2 and 3.3 (Beta)
  16. SQL Server 2008 SP1 (CTP)
  17. New Cumulative Updates in SQL Server 2005
  18. SQL Server 2005 and 2008 System Views Posters
  19. SQL Nexus 2.5.0.7 released
  20. SQL Best Practices for Biztalk
  21. SQL Server 2005 - SP2/SP3 and Cumulative Updates
  22. SQL Server 2008 Cumulative Update - #3

2008 11

  1. SQL Best Practices for MOSS
  2. Cumulative update package 11 for SQL Server 2005 Service Pack 2
  3. RML Utilities, version 9.01 Released
  4. How to script all my database objects? Here is the answer.
  5. CPU Drift and SQL Server timing values
  6. SQL Server - Performance Counters, Thresholds, etc.
  7. SQL Server & Disk Partition Alignment
  8. New Update of the SQL Server Management Pack (supports SQL Server 2000/2005 and now 2008)
  9. Minimal Logging for SQL Server 2008
  10. SQL Server 2005 SP3 CTP
  11. Ezequiel's Blog Launch