The Curious Engineer

All blogs / Databases

SQLPFE.IL

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

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’15’20’25
Posts
34 from 26 Jan 2012 to 27 May 2014
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqlpfeil/feed.xml

2014 3

  1. SQL Protocol How to secure and disable unnecessary protocol with a Power Shell script
  2. SQL Alias PowerShell script
  3. Using the proper login account for the correct SQL Service

2013 14

  1. Sys.Configuration
  2. LOG PARSER.
  3. SQL 2014 Beta
  4. Replication of indexed views
  5. Keep track of the DML changes:
  6. The scenario of a missing SA password:
  7. Discontinued and Deprecated features in SQL Server 2012
  8. SQL Server 2014 is here !
  9. Did you know , Dead locks can be track from the System Health in SQL 2012
  10. Where is the Help in SQL 2012? F1
  11. SQL 2012 System health–fast analysis
  12. Trace flag at query level is supported
  13. Check your SQL – default Trace
  14. How to avoid text-to-date conversion mismatches

2012 17

  1. the case of the unexplained - how we can get different execution plans and result sets for same query
  2. Working with SQLIO and analyzing it’s output
  3. SQL Server 2012 new feature The Snippets
  4. PERFMON & SQL Server - a small useful tip
  5. Stop using TOP to page for data from now on use the OFFSET
  6. SQL Server 2012 Audit Enhancements
  7. User-Defined Server Roles - new server option in SQL Server 2012
  8. HBA, Queue Depths and inflight IO.
  9. Four Tips for SQL Tuning for SharePoint Part 3 TEMPDB
  10. Target Recovery Time - new database option in SQL Server 2012
  11. Network bind order warning during SQL Server installation at failover cluster
  12. Startup parameters in SQL 2012.
  13. Recovery models
  14. Four Tips for SQL tuning for SharePoint Part 2 - Shrink DB
  15. SQL Server Service Packs and Cumulative Updates List
  16. SQL & SIDs why we need it and what the hell is it?
  17. Welcome to the SQL Server Israel PFE blog.