SSIS Issues : A Day of Learning
Seldom are the days when you run into complex issues but resolve them in the shortest interval of time.
Thanks to...
2017-11-24
477 reads
lokesh sharma
- Interests: Writing and troubleshooting SQL Queries obviously :-). Other than that a fitness freak
SQL Query Experiment - "WHERE" & "ON"
Sometimes the mistakes you make in the coding lead you to a better understanding of a particular concept.
This happened recently...
2017-11-14 (first published: 2017-11-02)
4,801 reads
Be Aware of CARTESIAN PRODUCT When Using Join Keys in SQL
I got a massive satisfaction last week when I was able to bring down the execution time of a sql...
2017-06-06
4,220 reads
Dump Data From SQL 2005 table to Excel 2016
By First looking at the topic name, does the task sound simple to you? Well, I thought so but it...
2017-06-01 (first published: 2017-05-22)
1,431 reads
Decrease Stored Proc Execution Time By Limiting the Table Size
Hi Guys,
Hope everyone is doing well. Last week, I was working on the most exciting task on which any database...
2017-05-30
835 reads
Run a Job on SQL Azure (Using SSIS Package)
Requirements: A valid azure account, Local Instance of SQL Server (>= 2012), SQL Server Data Tools, Excel 2007 or above
Scenario: Dump...
2017-03-23 (first published: 2017-03-11)
2,032 reads
SQL QUERY NIGHTMARE
Last week, we faced a basic and yet the only major problem that sql developers/admin had to deal with and...
2016-10-07 (first published: 2016-09-23)
4,321 reads
SSRS 2005 Bug - Percentage calculated column when Exporting to Excel
Nature of the Issue Faced :- Say you have 3 columns in a tablix/table on the report. There are 3 textboxes...
2016-05-30 (first published: 2016-05-20)
1,119 reads
Possible PARAMETER SNIFFING Scenario in SQL
When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to...
2016-05-11 (first published: 2016-04-29)
3,681 reads
ALTERNATIVE TO DISABLING A SQL JOB STEP (FOR SSIS PACKAGES)
For relational data-warehouses where you have the data load scheduled during off hours, timing of different steps in a sql...
2016-05-06
1,286 reads
Blogs
AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
Monday Monitor Tips: AI Alert Analysis
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Forums
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For
Comments posted to this topic are about the item Vector Search in SQL Server...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers