SQL Saturday #123 - Western Cape
Come to a free day of SQL training on Mar 3 in Tyger Valle, Western Cape in South Africa.
2012-02-27
1,265 reads
Articles
Using SSIS to Maintain the File System
Integration Services is one of the more flexible tools available on the SQL Server platform. Jason Brimhall shows us a way to remove old files, either backups or flat files, after a configurable period of time.
2012-02-24
7,248 reads
SSAS - Best Practices and Performance Optimization
There are several aspects that can take a toll on performance for your Analysis Services cubes. Some problems could be related to the source systems, some could be because of poor design of your cube and MDX queries and some could be related to network issues.
2012-02-24
3,549 reads
2012-02-23 (first published: 2010-10-13)
11,965 reads
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.
2012-02-23
7,639 reads
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.
2012-02-23
2,088 reads
2012-02-22
7,552 reads
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.
2012-02-22
1,528 reads
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.
2012-02-22
2,649 reads
Disaster Recovery: How to regain your lost sysadmin access
This article shows you the process which you require to regain your sysadmin access.
2012-02-21
19,771 reads
Blogs
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers