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
2015-03-31
1,321 reads
Articles
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.
2015-03-31
9,734 reads
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.
2015-03-31
6,894 reads
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.
2015-03-30
3,056 reads
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.
2015-03-30
9,858 reads
Cumulative sum of previous rows
I had an update statement that took 3 minutes to run after this code change it took 6 seconds.
2015-03-27 (first published: 2014-05-08)
34,180 reads
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.
2015-03-27
7,596 reads
Self-maintaining, Contiguous Effective Dates in Temporal Tables
'Temporal' tables contain facts that are valid for a period of time. When they are used for financial information they have to be very well constrained to prevent errors getting in and causing incorrect reporting. This makes them more difficult to maintain. Is it possible to have both the stringent constraints and simple CRUD operations? Well, yes. Dwain Camps patiently explains the whole process.
2015-03-26
9,819 reads
SQL Saturday #372 - Exeter, UK
SQL Saturday, organized by SQL South West, is coming to Exeter, England on April 25. This is sure to be a special event, and as always, offers a free day of training and networking. Register while space is available.
2015-03-26
7,920 reads
Exploding the Myths of Big Data
As big data application success stories (and failures) have appeared in the news and technical publications, several myths have emerged about big data. This article explores a few of the more significant myths, and how they may negatively affect your own big data implementation.
2015-03-25
11,670 reads
Blogs
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Start with the FabricTools PowerShell module
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Forums
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
lookup error
I am using ssrs in visual studio 2022, I work on a report, there...
Question of the Day
Celebrating Tomorrow
Which of these is more appropriate for tomorrow?
See possible answers