SQL Server 2012 SSIS – Sending files using FTP Task
This article will show you how to configure the FTP task in SSIS send files to remote server using the FTP protocol.
Using SQL Test Database Unit Testing with TeamCity Continuous Integration
With database applications, the process of test and integration can be frustratingly slow because so much of it is based on manual processes. Everyone seems to agree that automation of the process provides the answer to accomodating shorter development cycles, but how, exactly? Dave Green describes a successful process that integrates third-party tools.
Database Storage Survey – win 3 x $50 Amazon vouchers
We’d like to find out about who handles SQL Server database storage at your organization. Enter our quick survey now for the chance to win one of three $50 Amazon vouchers.
SQL Server Reporting Services Image Source Report Options
Companies often need to generate reports and forms from scanned images and various government supplied formats. Proper knowledge of how to incorporate images in a report is a must.
Disaster Recovery: How to regain your lost sysadmin access
This article shows you the process which you require to regain your sysadmin access.
Unit Testing Myths and Practices
We all understand the value of Unit Testing, but how come so few organisations maintain unit tests for their in-house applications? We can no longer pretend that unit testing is a universal panacea for ensuring less-buggy applications. Instead, we should be prepared to actively justify the use of unit tests, and be more savvy about where in the development cycle the unit test resources should be most effectively used.
An Implementation of the FNV1a Hash Algorithm for SQL Server
Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
ALAMAT BCA KCU BUKIT BARISAN TLP/WA 08218200174
Telp Cs: 08218200174 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera...
ALAMAT KANTOR BCA KCU MEDAN TLP/WA 08218200174
Telp Cs: (0821)8200174 Jl. Pangeran Diponegoro No.15, Petisah Tengah, Kec. Medan Petisah, Kota Medan,...
Alamat Kantor BCA KCP Kartini Tlp/Wa 08218200174
Telp Cs: (0821)8200174 Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, RT.3/RW.2,...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers