Website stats for Thesqlgirl - thesqlgirl.com

Run a PowerShell Script from SSIS – The SQL Girl

- https://thesqlgirl.com/2018/06/13/run-a-powershell-script-from-ssis/

Jun 13, 2018 ... It can be confusing to know which tool in the SSIS toolbox to use when trying to execute a PowerShell script from within SSIS. The best task to ...

MDS Backup Strategies – The SQL Girl

- https://thesqlgirl.com/2016/12/08/mds-backup-strategies/

Dec 8, 2016 ... Can be automated via SSIS; Can be restore to a server version that is +1, 0 and - 1. Cons: If you want to save backups of different models, then the ...

Setting Up SSIS in SQL Server Management Studio – The SQL Girl

- http://thesqlgirl.com/2017/02/02/setting-up-ssis-in-sql-server-management-studio/

Feb 2, 2017 ... Before you can deploy a SSIS project you need to set up SSIS in SQL Server Management Studio. When installing SQL you will select to install ...

Creating a “Run As” Account for Scheduled ETL Jobs – The SQL Girl

- https://thesqlgirl.com/2016/06/07/creating-a-run-as-account-for-scheduled-etl-jobs/

Jun 7, 2016 ... Step 4: Next you will need to add the Credential to the SSIS Package Execution Proxy so that it can execute SSIS packages on the server.

Creating PowerBI Layouts – The SQL Girl

- http://thesqlgirl.com/2018/09/10/creating-powerbi-layouts/

Sep 10, 2018 ... You can create layouts in PowerPoint and then save them as images. Then insert them into your PowerBI report as an image and send the image ...

MDS “Service Unavailable” Error – The SQL Girl

- https://thesqlgirl.com/2017/11/22/mds-service-unavailable-error/

Nov 22, 2017 ... After restarting a server that has MDS on, I could no longer access MDS via the browser. This seemed very strange as I have restarted the ...

Pivot and Unpivot – The SQL Girl

- http://thesqlgirl.com/2018/08/02/pivot-and-unpivot/

Aug 2, 2018 ... One thing to note is the column identifiers in the unpivot clause follow the catalog collation. For SQL Database, the collation is always ...

Modifying Temporal Tables – The SQL Girl

- http://thesqlgirl.com/2018/07/23/modifying-temporal-tables/

Jul 23, 2018 ... Data in a temporal table is modified using regular DML statements with one important difference: the period column data cannot be directly ...

PowerBI – Table Heat Map – The SQL Girl

- http://thesqlgirl.com/2018/09/18/powerbi-table-heat-map/

Sep 18, 2018 ... Ever wondered how to create a heat map in PowerBI without having to use a custom visual? There is now a simple way to do this by using ...

SSIS Save to XML Output – The SQL Girl

- https://thesqlgirl.com/2018/06/12/ssis-save-to-xml-output/

Jun 12, 2018 ... There isn't much online about saving an output of data to an XML file. When trying with a file system task it throws errors. There is a workaround ...

Visual Studio 2017: "Extension Microsoft integration services ...

- https://superuser.com/questions/1405205/visual-studio-2017-extension-microsoft-integration-services-projects-2-2-likel

Feb 13, 2019 ... ... of ways to treat this ... http://thesqlgirl.com/2016/09/17/ssis-package-validation/ ...I like Validate External Metadata: False or Work Offline: True.

Possible to declare a variable within a View? - MSDN - Microsoft

- https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4db0cab0-05f4-46e1-aa27-de1dcc27857d/possible-to-declare-a-variable-within-a-view?forum=transactsql

Example: http://thesqlgirl.com/2018/07/16/inline-table-valued-functions-tvfs/ · If you just want to limit based on those "parameters", then define ...

Cape Town 2017 - SQLSaturday #637

- https://sqlsaturday.com/2017-09-09-SQLSat-0637/

Sep 9, 2017 ... In her spare time she can be found spending time with her animals, doing SQL puzzles and writing on her blog http://thesqlgirl.com/. Michael ...

The path for 'ISServerExec.exe' cannot be found when deploying a ...

- https://www.javaer101.com/en/article/34859481.html

Dec 6, 2020 ... This solved my problem immediately: http://thesqlgirl.com/2017/10/25/ssis-error- the-path-for-isserverexec-exe-cannot-be-found/. When I re-ran ...

SAN Eye for the SQL Girl/Guy Hue Holleran. Block Access versus ...

- https://slideplayer.com/slide/9472559/

Presentation on theme: "SAN Eye for the SQL Girl/Guy Hue Holleran. Block Access versus File Share Access Block Access File Share Access."— Presentation ...

stored procedure flow chart - Fanada

- https://fanada.pennsylvaniamesa.org/stored-procedure-flow-chart/

Stored Procedure The Sql Girl . Ibmmainframes Stored Procedure Flow . 47 Described Stored Procedure Flow Diagram . Flow Diagram Of The Experimental  ...

Who Is Jeanne Combrinck – Who Am I

- https://whoisjeannecombrinck.com/

Blogger. Enjoy blogging and sharing my knowledge with others. Blog about SQL and Business Intelligence. Check it out! http://thesqlgirl.com/ ...

Hue Holleran - Speaker Profile - SQLBits

- https://sqlbits.com/Speakers/Hue_Holleran

SAN eye for the SQL girl/guy. More and more senior roles require familiarity with SAN technologies - tricky for us, 'just' the DBA. This '90% practical' session wi...

The Homeless Conspiracy - Home | Facebook

- https://www.facebook.com/TheHomelessConspiracy

Les créations de Laura. Interest · Formerly Homeless Foundation. Nonprofit Organization · Uphold Act of Congress". Government Organization · The SQL Girl...

Temporal Tables – The SQL Girl

- http://thesqlgirl.com/2018/07/19/temporal-tables/

Jul 19, 2018 ... Let's start off with what is a temporal table? SQL Server 2016 introduced support for system-versioned temporal tables as a database feature ...

403 Forbidden

- figure8digital.co.za

  Not Applicable   $ 8.95