2020 @SQLSatLA presents: Loading SQL Server Data with PowerShell by Sean McCown | @SentryOne Room
3 years ago
71
Loading SQL Server Data with PowerShell by Sean McCown (@KenpoDBA)
PowerShell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using PowerShell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.
Prerequisites: Basic understanding of PowerShell syntax.
Loading comments...
-
1:08:23
Data.SQL.Saturday.LA
2 years ago2021 Data.SQL.Saturday.LA presents: PowerShell and DBATools
42 -
1:00:22
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: Getting Started with Amazon RDS for SQL Server
18 -
1:03:34
Data.SQL.Saturday.LA
2 years ago2021 Data.SQL.Saturday.LA presents: Lock Picking your SQL Server
35 -
59:32
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: Lightning-fast processing in a SQL Server
17 -
33:11
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: Delivering DW on Microsoft SQL Server
44 -
1:10:27
Data.SQL.Saturday.LA
2 years ago2021 Data.SQL.Saturday.LA presents: Developer Best Practices in SQL Server
44 -
45:17
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: SQL Server "SANless" failover using SIOS
18 -
55:43
Data.SQL.Saturday.LA
2 years ago2021 Data.SQL.Saturday.LA presents: Advanced ETL with Power Query
40 -
54:46
Data.SQL.Saturday.LA
3 years ago2021 Data.SQL.Saturday.LA presents: Getting Started with Extended Events
15 -
1:01:29
Data.SQL.Saturday.LA
2 years ago2021 Data.SQL.Saturday.LA presents: Building user interactions with chatbots
25