Thứ Ba, 27 tháng 2, 2018
Thứ Bảy, 3 tháng 2, 2018
Thứ Hai, 15 tháng 1, 2018
SSRS Basic
Data Connections, Data Sources, and Connection Strings (Report Builder and SSRS)
Tables, Matrices, and Lists (Report Builder and SSRS)
Understanding Groups (Report Builder and SSRS)
Exploring the Flexibility of a Tablix Data Region (Report Builder and SSRS)
Tablix Data Region (Report Builder and SSRS)
Expressions (Report Builder and SSRS)
Expression Examples (Report Builder and SSRS)
Expression Scope for Totals, Aggregates, and Built-in Collections
Using Report and Group Variables Collection References in Expressions (Reporting Services)
Report Parameters (Report Builder and Report Designer)
Using Parameters to Connect to Other Reports
Using Query Parameters with Specific Data Sources (Reporting Services)
Adding, Modifying, and Deleting Linked Reports
Working with Chart Data Regions
Sparklines and Data Bars (Report Builder and SSRS)
Working with Gauge Data Regions
Indicators (Report Builder and SSRS)
Adding Interactive Features (Reporting Services)
Formatting Text and Importing HTML
Export Reports (Report Builder and SSRS)
Understanding Rendering Behaviors
Pagination in Reporting Services (Report Builder and SSRS)
Add a Page Break (Report Builder and SSRS)
Tables, Matrices, and Lists (Report Builder and SSRS)
Understanding Groups (Report Builder and SSRS)
Exploring the Flexibility of a Tablix Data Region (Report Builder and SSRS)
Tablix Data Region (Report Builder and SSRS)
Expressions (Report Builder and SSRS)
Expression Examples (Report Builder and SSRS)
Expression Scope for Totals, Aggregates, and Built-in Collections
Using Report and Group Variables Collection References in Expressions (Reporting Services)
Report Parameters (Report Builder and Report Designer)
Using Parameters to Connect to Other Reports
Using Query Parameters with Specific Data Sources (Reporting Services)
Adding, Modifying, and Deleting Linked Reports
Working with Chart Data Regions
Sparklines and Data Bars (Report Builder and SSRS)
Working with Gauge Data Regions
Indicators (Report Builder and SSRS)
Adding Interactive Features (Reporting Services)
Formatting Text and Importing HTML
Export Reports (Report Builder and SSRS)
Understanding Rendering Behaviors
Pagination in Reporting Services (Report Builder and SSRS)
Add a Page Break (Report Builder and SSRS)
Thứ Hai, 8 tháng 1, 2018
Reinstall NuGet packages
Update-Package -reinstall
Update-Package -reinstall -Project YourProjectName
https://stackoverflow.com/questions/6876732/how-do-i-get-nuget-to-install-update-all-the-packages-in-the-packages-config
Update-Package -reinstall -Project YourProjectName
https://stackoverflow.com/questions/6876732/how-do-i-get-nuget-to-install-update-all-the-packages-in-the-packages-config
Chủ Nhật, 26 tháng 11, 2017
Architecture of Integration Services
Architecture of Integration Services
Components of an Integration Services Package
Integration Services (SSIS) Connections
Control Flow
Integration Services Tasks
Data Flow
Integration Services Sources
Integration Services Destinations
Integration Services Transformations
Integration Services (SSIS) Expressions
Integration Services Data Types
Integration Services (SSIS) Variables
Extending Packages with Scripting
Using Variables in the Script Task
Creating a Custom Task
Developing a Custom Data Flow Component
Debugging Control Flow
Debugging Script
Debugging Data Flow
Implementing Logging in Packages
Error Handling in Data
Integration Services (SSIS) Event Handlers
Integration Services Transactions
Restart Packages by Using Checkpoints
Execute Package Utility (dtexecui)
SQL Server Agent Jobs for Packages
Thứ Ba, 21 tháng 11, 2017
[C#] How to read theme data of an excel file
//your excel file path
string filepath = @"C:\Users\xxx\Desktop\xxx.xlsx";
//an excel file is just a zip file
using (var zip = System.IO.Compression.ZipFile.OpenRead(filepath))
using (var stream = zip.GetEntry("xl/theme/theme1.xml").Open())
using (var rd = new StreamReader(stream))
{
var xml = rd.ReadToEnd();
}
Thứ Năm, 16 tháng 11, 2017
Check Last Restarted Time Windows
systeminfo | find /i "Boot Time"
https://superuser.com/questions/523726/how-can-i-find-out-when-windows-was-last-restarted
https://superuser.com/questions/523726/how-can-i-find-out-when-windows-was-last-restarted
Đăng ký:
Bài đăng
(
Atom
)