sqlpfe

24 Topics

Split a file group into multiple data files
First published on MSDN on Mar 03, 2017 Periodically we are asked how to split an existing filegroup into multiple data files.
SQLPFE
Mar 15, 2019 Place Core Infrastructure and Security Blog
27KViews
3likes
2Comments
What Does Installing Polybase Add to SQL Server?
First published on MSDN on Aug 29, 2016 In this post, I want to show you some of the components that are added to your SQL Server when you install the Polybase feature and where they reside.
SQLPFE
Mar 15, 2019 Place Core Infrastructure and Security Blog
17KViews
0likes
0Comments
SSIS Tip: Using a Filepath Parameter for Multiple Flat Files
First published on MSDN on Jul 05, 2016 SSIS with SQL 2012 and above brought a lot of great enhancements to SSIS that ease deployment and reconfiguration of packages.
SQLPFE
Mar 15, 2019 Place Core Infrastructure and Security Blog
14KViews
1like
0Comments
Troubleshooting intermittent connection timeout
First published on MSDN on Nov 08, 2016 In this blog, we are going to take a deep dive into a connectivity issue my customer encountered a while ago.
SQLPFE
Mar 15, 2019 Place Core Infrastructure and Security Blog
13KViews
0likes
0Comments
Troubleshooting CDC enabling failure - Part 1
First published on MSDN on May 17, 2017 My customer had recently experienced 2 interesting CDC issues and I would like to share the troubleshooting process and root cause for these issues today.
SQLPFE
Mar 15, 2019 Place Core Infrastructure and Security Blog
11KViews
0likes
0Comments
Incremental Statistics - My New Favorite Thing
First published on MSDN on Jan 17, 2017 So many new features get added with each release of SQL it is hard to use them all.
SQLPFE
Mar 15, 2019 Place Core Infrastructure and Security Blog
10KViews
0likes
0Comments
Recover database without LDF file
First published on MSDN on Jan 12, 2016 I recently came across a missing LDF file case that I would like to share some interesting findings.
SQLPFE
Mar 15, 2019 Place Core Infrastructure and Security Blog
7.9KViews
1like
0Comments
Performing transaction log backups using AlwaysOn Availability Group read-only secondary replicas-Part2
First published on MSDN on Oct 19, 2016 Describe the log backup process on a ROSRThis is the second post in a planned series of articles relating to SQL Server transaction log backups of databases using a read-only secondary replica (ROSR).
SQLPFE
Mar 15, 2019 Place Core Infrastructure and Security Blog
7.2KViews
1like
0Comments
Recover database without LDF file
First published on MSDN on Jan 12, 2016 I recently came across a missing LDF file case that I would like to share some interesting findings.
SQLPFE
Mar 15, 2019 Place Core Infrastructure and Security Blog
6.2KViews
0likes
0Comments
Performing Transaction Log Backups using AlwaysOn Availability Group Read-Only Secondary Replicas - Part 1
First published on MSDN on Oct 19, 2016 This is the first post in a planned series of articles relating to SQL Server Transaction Log Backups of databases using a read-only secondary replica (ROSR).
SQLPFE
Mar 15, 2019 Place Core Infrastructure and Security Blog
5.4KViews
0likes
0Comments