The Curious Engineer

All blogs / Databases

SQL Server Premier Field Engineer Blog

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

This is a shared team blog of the SQL Server Premier Field Engineer team

DatabasesDevOps / SRE / infrastructureMicrosoft blogsMSDN archive

’10’15’20’25
Posts
129 from 27 May 2009 to 25 Feb 2019
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sql_pfe_blog/feed.xml

2019 2

  1. Physical_Device_Name Not Updated On Restore
  2. Automate Azure VM Storage

2018 8

  1. FileStream Backup and Restore
  2. AlwaysOn Availability Groups unable to query against readable secondary replica database: Wait Type HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING
  3. Configure SQL Server Failover Cluster Instance on Azure Virtual Machines with MSDTC
  4. Domain Independent Cluster and Availability Group
  5. Read-Scale Availability Group Setup
  6. MSDTC Supported Configurations
  7. Migrating Symmetric Keys Between SQL 2016 and SQL 2017/Azure
  8. Monitoring Azure Analysis Services with Log Analytics and Power BI

2017 26

  1. How to Upgrade an AG Cluster to Windows 2016
  2. SQL Server 2017 Read-Scale Availability Groups
  3. Implementing Buffer Pool Extension
  4. Microsoft Excel, TLS & SQL Server – Important Considerations
  5. Sync SQL Logins and Jobs
  6. Trace Flag 1117 Growth and Contention
  7. Query Store Questions From The Field
  8. SQL Server Workgroup Cluster FCM Errors
  9. SQL 2016 - Temporal Tables - Triggers and Historical Data Tidbits
  10. Troubleshooting CDC enabling failure – Part 2
  11. Troubleshooting CDC enabling failure – Part 1
  12. Login Failed for xxx – Who’s Keeps Trying to Connect to my Server?
  13. SSISDB Reporting with Power BI
  14. Quick Tip - Shift+Alt for multiple line edits
  15. SSIS: Capturing PerfMon Counters During Package Execution
  16. Split a file group into multiple data files
  17. SQL Diagnostics Project Part 2 – Custom SQL Nexus Imports
  18. Trouble shooting Availability Group Listener in Azure SQL VM
  19. SSIS: Setting the same variable in multiple projects in the catalog
  20. Increasing the Number of SQL Server Error Logs – My Automation Journey – Part 2
  21. Azure RM: Configure a second Availability Group with a Listener using the External Load Balancer
  22. APS Blocked Partition Switch
  23. The EXECUTE permission was denied on xp_msver
  24. SQL 2016 - Temporal Tables - How do you drop a Temporal Table?
  25. Incremental Statistics – My New Favorite Thing
  26. APS 2016 External Object Changes

2016 33

  1. CREATE INDEX Monitoring Progress
  2. SQL 2016 - Temporal Tables - Can you change the schema?
  3. Recover database without LDF file
  4. Tempdb misconfiguration when SQL Server fails to create a secondary data file
  5. Troubleshooting intermittent connection timeout
  6. SQL 2016 - Temporal Tables - What are they and how do you set one up?
  7. Increasing the Number of SQL Server Error Logs – My Automation Journey – Part 1
  8. Performing transaction log backups using AlwaysOn Availability Group read-only secondary replicas-Part2
  9. Performing Transaction Log Backups using AlwaysOn Availability Group Read-Only Secondary Replicas - Part 1
  10. Finding Which Connections Have Been Read Only Routed
  11. Create a Quick and Easy Performance Baseline
  12. TCP Port Is Already In Use
  13. SSIS version number is not valid error
  14. SQL 2016 Backup Compression with TDE Enabled Databases
  15. DBCC CHECKDB Fails on a Database with files in Azure Blob Storage
  16. CPU_ID Gaps in SQL Server sys.dm_os_schedulers
  17. Where is a record really located?
  18. Finding What Availability Group Listeners Applications Are Using To Connect
  19. Learn SQL 2016 Polybase with HDP - Part 2 – Learning Polybase along with Hadoop Tutorials
  20. Learn SQL 2016 Polybase with HDP - Part 1 - Build the Environment
  21. What Does Installing Polybase Add to My SQL Server?
  22. Azure SQL Database Migration Performance
  23. Quickly create A LOT of SQL Instances
  24. SSDT BI Gotcha on VS2015 – New Target Server Version Added to Project Properties
  25. Find users under a specific database role for all the servers in my environment
  26. Azure RM: SQL Server AlwaysOn Availability Groups Listener configuration with Azure External Load Balancer
  27. Easier SQL Server Cluster Upgrades with Windows Server 2016!
  28. Load Testing SSAS with PowerShell
  29. Getting Started with Always Encrypted Part 2
  30. Getting Started with Always Encrypted Part 1
  31. SSIS Tip: Using a Filepath Parameter for Multiple Flat Files
  32. SSRS Subscriptions (What goes on “under the hood”)
  33. Recover database without LDF file

2014 2

  1. SQL PFE has a Pre-Con at the PASS Summit!
  2. Generating a trusted TDE Certificate in the proper format from a Certificate Authority

2013 38

  1. SQL Diagnostics Project Part 1 – Configuring Custom SQL Data Collections
  2. Inadvertently Promoting a Local Transaction to a Distributed Transaction
  3. SQL PFE PASS Content Now Available!
  4. SQL PFE @ PASS Summit
  5. Connection Pooling for the SQL Server DBA
  6. SecurityException / ‘The process was terminated’ errors installing SQL 2008 when .Net Framework 4.0 is installed
  7. An Approach to SQL Server Index Tuning
  8. Forced Parameterization Can Lead to Poor Performance
  9. Back to Basics: SQL Parameter Sniffing due to Data Skews
  10. Correlating XE query_hash and query_plan_hash to sys.dm_exec_query_stats in order to retrieve Execution plans for high Resource statements.
  11. Oops… I forgot to leave an empty SQL table partition, how can I split it with minimal IO impact?
  12. Timeout Error from Excel Services - “Unable to refresh data for a data connection in the workbook”
  13. Adding mount points to a WSFC SQL Cluster ( FCI ) Instance
  14. How to: Restoring SQL File stream Data
  15. Monitoring SQL Server 2012 AlwaysOn Availability Groups Worker Thread Consumption
  16. Slice on a Calculated Member that uses the Aggregate function
  17. Are my actual worker threads exceeding the sp_configure 'max worker threads' value?
  18. Lazy Log Truncation – Clearing of SQL transaction log VLF status deferred
  19. SQL Server Resource Governor Monitoring reports
  20. An overview of High Availability and Disaster Recovery solutions available for SQL Server
  21. SQL Server Analysis Services Multidimensional Model – Merging Partitions with Slice
  22. Flow Control in Always On Availability Groups – what does it mean and how do I monitor it?
  23. Implications of the SQL Server Bulk Logged recovery model on point in time restores
  24. Compare SQL Failover Cluster Instance SQL and OS Node Versions using PowerShell
  25. Identifying the cause of SQL Server IO bottlenecks using XPerf
  26. SQL 2012 System Health Reporting Dashboard – Visualizing sp_server_diagnostics results.
  27. Get the Active Power Plan of Multiple Servers with PowerShell
  28. SQL 2012 AlwaysOn Availability groups Automatic Failover doesn’t occur or does it – A look at the logs
  29. Viewing SQL Server Non-Clustered Index Page Contents
  30. SQL FileStream Restore and Anti-Virus
  31. Observing SQL Server Transaction Log Flush Sizes using Extended Events and Process Monitor
  32. Troubleshooting SQL Server High CPU usage using Xperf
  33. Dissecting SQL Server physical reads with Extended Events and Process monitor
  34. SQL Server 2012 Partially Contained Databases Part 2 - Collation
  35. SQL Server 2012 Partially Contained Databases Part 1 - Contained Logins
  36. Use PowerShell Script via startup Agent Job to balance Memory between two instances on a cluster on a Failover
  37. MDX: SET overwrite and the use of EXISTING function
  38. SQL Collation and related performance impact, viewing collation in query plans

2011 1

  1. Merge Replication Conflict Detection vs Conflict Resolution Part 2: Custom Business Logic Handler

2010 3

  1. Backup compression behavior when appending backups to an existing Media Set
  2. Merge Replication Conflict Detection v/s Conflict Resolution
  3. Last Known Good Backup/DBCC

2009 16

  1. SQL Server memory models (Part II)
  2. How and Why to Enable Instant File Initialization
  3. Deadlock Troubleshooting in SQL Server Analysis Services ( SSAS )
  4. SQL Server memory models (Part I)
  5. Side effects of storing an Analysis Services partition data in a non-default location
  6. How to use Partition Processing Destination Task to pump data into a SSAS partition via SSIS
  7. SQL High CPU scenario troubleshooting using sys.dm_exec_query_stats and RING_BUFFER_SCHEDULER_MONITOR ring buffer in sys.dm_os_ring_buffers
  8. SQL High CPU scenario troubleshooting using sys.dm_exec_query_stats and RING_BUFFER_SCHEDULER_MONITOR ring buffer in sys.dm_os_ring_buffers
  9. Sum of a SQL Analysis Services calculated measure within a Reporting Services report gives #Error
  10. What needs to be done to be able to edit DTS 2000 packages on a Windows 2008 or Vista Machine ?
  11. The Case of the Phantom Spid: Troubleshooting and Resolving an Orphaned DTC Transaction
  12. Possible performance implications when using string parameters in Reporting Services
  13. Enabling/Disabling Report builder 2.0 on SSRS 2008 in SharePoint integrated mode
  14. Three Usage Scenarios for sys.dm_db_index_operational_stats
  15. Chart behavior difference in SQL Reporting Services 2008
  16. Introducing the SQL Server Premier Field Engineer Blog