The Curious Engineer

All blogs / Databases

The PFE Chronicles

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

Some advice and experience for you from SQL Server PFEs

DatabasesDev tools / editors / IDEsMicrosoft blogsMSDN archive

’15’16’17’18’19’20’21’22’23’24’25’26
Posts
60 from 7 Dec 2015 to 7 Jul 2018
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/dataplatform/feed.xml

2018 22

  1. Variables, Literals, Procs and Stats
  2. Previewing file content
  3. Keeping your important files safe and secure
  4. Somewhere to put that data while your script runs
  5. How to find out what you need to know
  6. Fill Factor and Data Compression
  7. Microseconds Or Milliseconds
  8. You really need to look out for msdb security
  9. Troubleshooting Using Ring Buffers
  10. Advantages and Annoyances of Filtered Indexes
  11. Instant File Initialization–Do You Know It’s Value?
  12. Install SQL Server Books Online - Offline
  13. SQL Data Discovery & Classification in SQL Server Management Studio (SSMS) 17.5 [Behind the Scenes]
  14. SQL Data Discovery & Classification in SQL Server Management Studio (SSMS) 17.5
  15. Assess an Enterprise With Data Migration Assistant–Part 4: Report on an Assessment
  16. Assess an Enterprise With Data Migration Assistant–Part 3: Loading an Assessment
  17. Assess an Enterprise With Data Migration Assistant–Part 2: Running an Assessment
  18. Assess an Enterprise With Data Migration Assistant–Part 1: Prerequisites
  19. Presenting with SSMS
  20. SELECT *, Indexes, Data Access, and the Optimizer!
  21. VSCode custom snippets
  22. Implicit Conversions – Ouch!

2017 17

  1. New in SSMS 17.4 - Vulnerability Assessment
  2. SQL Server 2017 GA Announced!
  3. Recover the SSISDB to a New Machine Without a Database Backup
  4. SQL Performance Counters are Missing
  5. SQL Azure DW – What is it? How it works?
  6. SQL Azure troubleshooting, some ideas and scenarios.
  7. SQL Server 2016 new features to deal with the new CE
  8. Report on your consolidated Data Migration Assistant Assessments With PowerBI
  9. Oh it's that time again ! - SQLBits!
  10. Database Startup Times
  11. xp_cmdshell - Naming, Shaming and Taming
  12. How to Consolidate Data Migration Assistant JSON Assessment Reports
  13. Query Store: How it works? How to use the new Query Store Catalog Views?
  14. Deconstructing Extended Event XML
  15. SQL Server 2016 HA Series Part 2 – SSIS and Availability Groups
  16. The mysterious case of why your procedure has two query plans & the bitwise AND
  17. Query Store: How it works? How to use it?

2016 20

  1. Query Data Store Size Cleanup Retention
  2. Set your PowerShell session to automatically log into Azure
  3. SQL Server 2016 HA Series Part 1 – 3 Auto Failover Targets
  4. Query Store - Settings and Limits
  5. How To: Use the Azure Key Vault to Manage the Key for a TDE enabled Database
  6. Using ‘R’ Services within SQL Server 2016
  7. Log Ship SSISDB in SQL Server 2012
  8. Incremental Statistics and Trace Flag 2371 in SQL 2014
  9. Incremental statistics ... How to Update Statistics on 100TB Database
  10. SSMS March 2016 Now Doesn’t Fail to Install
  11. SSMS March 2016 Fails to Install
  12. Restoring the master database, but not in this way!
  13. AlwaysOn Secondary with Out-Of-Memory Errors…
  14. Performance Monitor counter search
  15. SQL 2012 Latest Update Confusion
  16. SQL 2016 Load Balanced Readable Secondary Replicas
  17. See you at SQL Bits!
  18. IT Innovation Series - free tech events in the UK
  19. SQL Server 2016 DTC Support In Availability Groups
  20. SQL Server 2012 Cumulative Updates

2015 1

  1. Hello world!