There is an old joke that upgrading to the latest SQL Server is wasted on some DBAs, because they will still stick mainly to what worked in SQL Server 2005. This type of DBA is becoming rare, in my experience, but there is still some truth in the idea that many of us don’t get the ‘full power’ from our SQL Server tools. We work with them as they come, ‘out of the box’, and use only a fraction of their features. The time to explore ‘new stuff’, at least as much as we’d like to, remains elusive.

Falling Behind and Digital Bankruptcy

by Steve Jones

SQLServerCentral

Career Growth

The challenges of information overload can weigh on technology workers.

Stairway to U-SQL Level 3: Processing Multiple Files With U-SQL

by Mike McQuillan

SQLServerCentral.com

In part 3 of the U-SQL Stairway, we look at how multiple files can be processed with a single U-SQL statement.

Splitting a SQL Server Table Over Multiple Files

by Additional Articles

MSSQLTips.com

tables

In this tip we look at how to move SQL Server tables from one filegroup to another filegroup.

Oops, I deleted that data

by MVDBA (Mike Vessey)

SQLServerCentral

T-SQL

We all have these days as a DBA, hopefully they are few and far between for most of us. This morning I walked into the office and found a stack of emails saying that a developer had responded to a support ticket and modified the values in one of our tables and got it wrong. OK, […]

Rogue Software Changes

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones wonders if software developers would make changes to software on their own, without direction from management.

Planning for SAP HANA Deployments in Public Cloud Environments

by Additional Articles

Database Journal

SAP HANA

Learn about the factors that should be taken into account if you are considering hosting SAP HANA in a public cloud.

Recreating Databases from Scratch with SQL Change Automation

by Additional Articles

Redgate

Phil Factor starts with the basics how to rebuild a set of development database from scratch, using SQL Change Automation, and then demonstrates how to check for any active sessions before rebuilding, import test data using BCP, and secure passwords if connecting to the target with SQL Server credentials.