Shredding Unicode Japanese characters using SSIS
This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS
Source Code Security
The code you use may contain security information. Be extra careful in this case, especially when you use encryption.
Getting Started with Database Engine Tuning Advisor in SQL Server – Part 2
Arshad Ali demonstrates how you can use the command line interface to tune SQL queries and how you can use SQL Server Profiler to capture the workload for tuning with Database Engine Tuning Advisor.
SQL Monitor Custom Metric: Hash Warnings (Last Hour)
This alert is raised when the number of hash warnings events in the last hour goes above a specified threshold. A hash warning event means that part of the data processed for a hash operation was written to tempdb during query execution, which can degrade SQL Server Performance.
Obedience Training For Databases: Cascading Constraints
In which Phil Factor illustrates in TSQL how it is possible to use foreign key constraints to enforce data rules, and illustrates some surprising consequences of using cascading.
One Rule, Umpteen Constraints
Despite being deprecated for many years, Phil Factor explains why RULEs are still hanging on in there in SQL Server 2014.
Identifying and Solving Index Scan Problems
When you're developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once you've identified the queries, what next? Dennes Torres gives some preliminary guidelines on how to find out why these index scans are being chosen for these queries and how to make the queries run faster and more efficiently.
Cumulative sum of previous rows
I had an update statement that took 3 minutes to run after this code change it took 6 seconds.
Azure Blob Storage Part 9: Shared Access Signatures
In this article, Robin Shahan talks about security and how to control access to containers and blobs using shared access signatures (SAS) and stored access policies.
Efficiency
This Friday Steve Jones asks about how you are tackling your career growth as you get older. Are you getting more efficient?
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Arundina Cibubur CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26 Blok A/24,...
BCA KCP Pondok Gede CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Raya Pd. Gede No.43, RT.1/RW.7, Lubang Buaya, Kec. Cipayung, Kota...
BCA KCP Kalimalang CSTelpon : 0853-73737551
Jl. Inspeksi Kav. PTB Blok A 2 No. 2 C-D, RT.1/RW.4, Pd. Klp., Wil,...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers