My TechNet Wiki Articles and TechNet Gallery Scripts

SQL Server Import/Export to Excel using Python script

T-SQL : Data profiling in On-premise SQL Server / Azure SQL database

T-SQL : Search for string or phrase in SQL Server database

SQL Server - Export SQL file output to Excel file

SQL Server Import/Export to Excel using R script

SQL Server Import/Export to CSV using R script

SSRS - Make common change in multiple reports in one click -

T-SQL Script to find Stored Procedures that Use DYNAMIC_SQL , TEMPORARY_TABLE -

SQL Server - Effects Of Renaming a Column Of a Table

SQL Server - Transact-SQL eBook by TechNet Wiki Community

SSRS - Sorting -

SSRS - How to calculate total of dynamic columns  -

SQL Server Performance tuning with Indexing

SQL Server - Display dynamically horizontal rows vertically

SSRS - Multi-valued Parameter as Stored procedure Input

SSRS - Compare two versions of the same report

SSIS - Import Excel to table - Cannot convert between uniocde and non-unicode string data types

T-SQL Script to generate Index Creation Scripts for all tables in a database

T-SQL Script to get information about Index settings

SSRS (Matrix) - How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling

SSRS: How to Repeat Headers on Each Page

T-SQL Script for inserting rows repeatedly based on particular count

SSRS - How to display multiple columns (header and value) horizontally stacked in one row cell -

SSRS - How to set Column Visibility property for many columns based on Parameter value -

How to Compare Two Tables Definition / Metadata in Different Databases -

How to Check the Syntax of Dynamic SQL Before Execution -

T-SQL Script to compare two tables definition / metadata in different databases -

T-SQL Script to check the syntax of dynamic SQL before execution -

SSRS - To group same row data with one column having varying data

SSRS - How to repeat headers for each group  -

T-SQL Script to Split a column with delimited string into multiple columns -

SSRS - Multiple ways to split a string into multiple lines -

 SSRS - Multi Font Color / Multi Font Size within Single Field / Textbox

SSIS - Move Folder from one Drive to Another Drive Using File System Task

 T-SQL Script to find the names of the StoredProcedure that has used dynamic SQL

SQL Server Management Studio : How to add Line numbers in SSMS -

Browser facility within SQL Server Management Studio (SSMS) -

SQL Server - Import/Shred XML from XML file placed in a folder into table -

Generate XML - Column names with their values as text() enclosed within their column name tag -

Avoid T (space) while generating XML using FOR XML clause -

Remove leading and trailing zeros -

Generate XML with same node names using FOR XML PATH -

T-SQL Script to update string NULL with default NULL  -

Passing comma separated values (SSRS - multivalued parameter) as input to the stored procedure -

SQL Server  - Split delimited string into separate columns -

SSIS - How to Add Missing Control Flow Items / Data Flow Items to the SSIS Toolbox

No comments: