The Curious Engineer

All blogs / Databases

SQL Server Knowledge by Batuhan YILDIZ

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

Notes From The Field Experiences and Useful Scripts - By Microsoft Premier Field Engineer

DatabasesDevOps / SRE / infrastructureMicrosoft blogsMSDN archive

’15’20’25
Posts
13 from 16 Oct 2012 to 29 May 2013
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/batuhanyildiz/feed.xml

2013 12

  1. What size is suitable as an Initial Size for tempdb system database?
  2. Basic steps to setup Windows Server 2012 Cluster with Hyper-V
  3. How to identify and solve the fragmentation in SQL Server?
  4. Which one is better? PERSISTED Column or XML Indexes?
  5. How to find busy tables in SQL Server?
  6. Guest user account in SQL Server
  7. Autogrowth option for SQL Server database files
  8. SQL Server Builds
  9. Using Distributed Replay to load test your SQL Server–Part 2
  10. Using Distributed Replay to load test your SQL Server–Part 1
  11. TOP N Biggest Tables in every database
  12. TSQL for database size, data and log available size

2012 1

  1. How to enable/remove Transparent Data Encryption (TDE)