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,045 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,608 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
If you manage a server where you are not in complete control of the creation of databases, or you’re unfamiliar with what settings to change, you may miss things out or set them incorrectly. This metric could pick up on issues that affect performance in obscure ways, and saves you having to search for them when a system suddenly stops performing as you would expect.
2014-03-11
1,279 reads
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Comments posted to this topic are about the item Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers