My TechNet Wiki Articles and TechNet Gallery Scripts

SQL Server Import/Export to Excel using Python script
https://social.technet.microsoft.com/wiki/contents/articles/53063.sql-server-importexport-to-excel-using-python-script.aspx

T-SQL : Data profiling in On-premise SQL Server / Azure SQL database
https://social.technet.microsoft.com/wiki/contents/articles/52865.t-sql-data-profiling-in-on-premise-sql-server-azure-sql-database.aspx

T-SQL : Search for string or phrase in SQL Server database
https://social.technet.microsoft.com/wiki/contents/articles/52793.t-sql-search-for-string-or-phrase-in-sql-server-database.aspx

SQL Server - Export SQL file output to Excel file
https://social.technet.microsoft.com/wiki/contents/articles/52624.sql-server-export-sql-file-output-to-excel-file.aspx

SQL Server Import/Export to Excel using R script
https://social.technet.microsoft.com/wiki/contents/articles/52528.sql-server-importexport-to-excel-using-r-script.aspx

SQL Server Import/Export to CSV using R script
https://social.technet.microsoft.com/wiki/contents/articles/52484.sql-server-importexport-to-csv-using-r-script.aspx

SSRS - Make common change in multiple reports in one click -
http://www.allaboutmssql.com/2015/11/ssrs-make-common-change-in-multiple.html

T-SQL Script to find Stored Procedures that Use DYNAMIC_SQL , TEMPORARY_TABLE -
http://gallery.technet.microsoft.com/scriptcenter/T-SQL-Script-to-find-772dc908

SQL Server - Effects Of Renaming a Column Of a Table
http://www.allaboutmssql.com/2014/02/sql-server-effects-of-renaming-column.html

SQL Server - Transact-SQL eBook by TechNet Wiki Community
http://www.allaboutmssql.com/2014/01/sql-server-transact-sql-ebook-by.html

SSRS - Sorting -
http://social.technet.microsoft.com/wiki/contents/articles/20587.ssrs-sorting.aspx

SSRS - How to calculate total of dynamic columns  -
http://social.technet.microsoft.com/wiki/contents/articles/20031.ssrs-how-to-calculate-total-of-dynamic-columns.aspx

SQL Server Performance tuning with Indexing
http://social.technet.microsoft.com/wiki/contents/articles/19815.sql-server-performance-tuning-with-indexing.aspx

SQL Server - Display dynamically horizontal rows vertically
http://www.allaboutmssql.com/2013/09/sql-server-display-dynamically.html

SSRS - Multi-valued Parameter as Stored procedure Input
http://www.allaboutmssql.com/2013/09/ssrs-multi-valued-parameter-as-stored.html

SSRS - Compare two versions of the same report
http://www.allaboutmssql.com/2013/09/ssrs-compare-two-versions-of-same-report.html

SSIS - Import Excel to table - Cannot convert between uniocde and non-unicode string data types
http://www.allaboutmssql.com/2013/09/ssis-import-excel-to-table-cannot.html

T-SQL Script to generate Index Creation Scripts for all tables in a database
http://www.allaboutmssql.com/2013/09/t-sql-script-to-generate-index-creation.html

T-SQL Script to get information about Index settings
http://www.allaboutmssql.com/2013/09/t-sql-script-to-get-information-about.html

SSRS (Matrix) - How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling
http://social.technet.microsoft.com/wiki/contents/articles/19505.ssrs-matrix-how-to-repeat-headers-on-each-page-and-keep-headers-fixed-while-scrolling.aspx

SSRS: How to Repeat Headers on Each Page
http://social.technet.microsoft.com/wiki/contents/articles/19398.ssrs-how-to-repeat-headers-on-each-page.aspx

T-SQL Script for inserting rows repeatedly based on particular count
http://gallery.technet.microsoft.com/scriptcenter/T-SQL-Script-for-inserting-f36b3dc1

SSRS - How to display multiple columns (header and value) horizontally stacked in one row cell - http://social.technet.microsoft.com/wiki/contents/articles/19363.ssrs-how-to-display-multiple-columns-header-and-value-horizontally-stacked-in-one-row-cell.aspx

SSRS - How to set Column Visibility property for many columns based on Parameter value -
http://social.technet.microsoft.com/wiki/contents/articles/19333.ssrs-how-to-set-column-visibility-property-for-many-columns-based-on-parameter-value.aspx

How to Compare Two Tables Definition / Metadata in Different Databases -
http://social.technet.microsoft.com/wiki/contents/articles/19133.how-to-compare-two-tables-definition-metadata-in-different-databases.aspx

How to Check the Syntax of Dynamic SQL Before Execution -
http://social.technet.microsoft.com/wiki/contents/articles/19132.how-to-check-the-syntax-of-dynamic-sql-before-execution.aspx

T-SQL Script to compare two tables definition / metadata in different databases -
http://gallery.technet.microsoft.com/scriptcenter/T-SQL-Script-to-compare-aaae99a7

T-SQL Script to check the syntax of dynamic SQL before execution -
http://gallery.technet.microsoft.com/scriptcenter/T-SQL-Script-to-check-the-935002e7

SSRS - To group same row data with one column having varying data
http://www.allaboutmssql.com/2013/08/ssrs-to-group-same-row-data-with-one.html

SSRS - How to repeat headers for each group  -
http://social.technet.microsoft.com/wiki/contents/articles/19040.ssrs-how-to-repeat-headers-for-each-group.aspx

T-SQL Script to Split a column with delimited string into multiple columns -
http://gallery.technet.microsoft.com/scriptcenter/T-SQL-Script-to-Split-a-308206f3

SSRS - Multiple ways to split a string into multiple lines -
http://social.technet.microsoft.com/wiki/contents/articles/18750.ssrs-multiple-ways-to-split-a-string-into-multiple-lines.aspx

 SSRS - Multi Font Color / Multi Font Size within Single Field / Textbox
- http://social.technet.microsoft.com/wiki/contents/articles/18748.ssrs-multi-font-color-multi-font-size-within-single-field-textbox.aspx

SSIS - Move Folder from one Drive to Another Drive Using File System Task
- http://social.technet.microsoft.com/wiki/contents/articles/18776.ssis-move-folder-from-one-drive-to-another-drive-using-file-system-task.aspx

 T-SQL Script to find the names of the StoredProcedure that has used dynamic SQL
http://social.technet.microsoft.com/wiki/contents/articles/18790.t-sql-script-to-find-the-names-of-the-storedprocedure-that-has-used-dynamic-sql.aspx

SQL Server Management Studio : How to add Line numbers in SSMS -
http://social.technet.microsoft.com/wiki/contents/articles/18601.sql-server-management-studio-how-to-add-line-numbers-in-ssms.aspx

Browser facility within SQL Server Management Studio (SSMS) -
http://social.technet.microsoft.com/wiki/contents/articles/18593.using-browser-from-within-sql-server-management-studio-ssms.aspx

SQL Server - Import/Shred XML from XML file placed in a folder into table -  http://gallery.technet.microsoft.com/scriptcenter/SQL-Server-ImportShred-XML-7f3baa40#content

Generate XML - Column names with their values as text() enclosed within their column name tag -
http://social.technet.microsoft.com/wiki/contents/articles/17816.generate-xml-column-names-with-their-values-as-text-enclosed-within-their-column-name-tag.aspx

Avoid T (space) while generating XML using FOR XML clause -
http://social.technet.microsoft.com/wiki/contents/articles/17817.avoid-t-space-while-generating-xml-using-for-xml-clause.aspx

Remove leading and trailing zeros -
http://social.technet.microsoft.com/wiki/contents/articles/17777.remove-leading-and-trailing-zeros.aspx

Generate XML with same node names using FOR XML PATH -
http://social.technet.microsoft.com/wiki/contents/articles/17778.generate-xml-with-same-node-names-using-for-xml-path.aspx

T-SQL Script to update string NULL with default NULL  -  http://social.technet.microsoft.com/wiki/contents/articles/17069.t-sql-script-to-update-string-null-with-default-null.aspx

Passing comma separated values (SSRS - multivalued parameter) as input to the stored procedure -
http://social.technet.microsoft.com/wiki/contents/articles/17104.passing-comma-separated-values-ssrs-multivalued-parameter-as-input-to-the-stored-procedure.aspx

SQL Server  - Split delimited string into separate columns -
http://gallery.technet.microsoft.com/scriptcenter/SQL-Server-2012-Split-bdbf6fc2

SSIS - How to Add Missing Control Flow Items / Data Flow Items to the SSIS Toolbox
- http://social.technet.microsoft.com/wiki/contents/articles/18796.ssis-how-to-add-missing-control-flow-items-data-flow-items-to-the-ssis-toolbox.aspx

No comments: