Instead of using a custom SSIS-based project to upload content from an on-premise SQL Server database to Azure PaaS-based SQL Database, Marcin Policht presents an alternative approach. Using the bcp utility not only eliminates the need for any custom development, but also rivals SSIS in terms of its data transfer efficiency.
2014-03-17
3,582 reads
Part 2 of a series on how to automate partition management. In this article learn how easy managing and maintaining a sliding window partition scheme can be with PowerShell.
2014-03-14 (first published: 2010-12-21)
10,047 reads
One of the core components of the Hadoop framework and responsible for the storage aspect is HDFS. Unlike the usual storage available on our computers, HDFS is a Distributed File System and parts of a single large file can be stored on different nodes across the cluster. Here are some of the key concepts related to HDFS.
2014-03-14
4,123 reads
SQL Saturday #292 in Detroit, MI, is looking for speakers. The event is May 17, 2014, and there are still some speaking slots available.
2014-03-14
1,818 reads
SQL Server Integration Services does not provide native SFTP, encryption or archiving task components. This article presents a set of open source custom task components that provides these functions.
2014-03-13
8,610 reads
There are many useful command-line applications that are either associated with, or are distributed with, SQL Server. They all have their uses and several become important as part of script-based automation of tasks. It is definitely worth knowing what is lurking in your tools\binn directory.
2014-03-13
7,504 reads
SQL Saturday is coming to Madison on March 29, 2014. This is a free training event for SQL Server professionals and those wanting to learn about SQL Server. Steve Jones and many others will be presenting, so make sure you register early to secure your place.
2014-03-13
1,816 reads
The Change Data Capture feature of SQL Server captures DML changes happening on a tracked table. Arshad Ali demonstrates how this feature can be leveraged.
2014-03-12
2,429 reads
Survey - The DBA-Team wants to hear about your worst day as a DBA. Did a database restore fail due to corruption? Did you accidentally connect to Prod instead of Dev and truncate a table? Anonymity available. The best story will win a $50 Amazon voucher.
2014-03-12
4,076 reads
With the right tools, it is possible to rapidly deploy upgraded databases. By deploying early in development, it's easier to iron out any potential problems that the new deployment could cause in production long before it's time to actually release the software.
2014-03-11
4,431 reads
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers