Burning Out

• by Steve Jones

• SQLServerCentral

• Career

Burning out in an IT job is easier to do than it should be. Steve has a little advice today.

Setup SSIS Catalog Retention Policy and Partial Cleanup Strategy

• by ozkary

• SQLServerCentral

• Administration
• Integration Services (SSIS)

Learn how you can configure clean and size management for your SSIS catalog database.

Bloor scores SQL Provision 4.5 out of 5 for test data provisioning

• by Additional Articles

• Redgate

• provisioning
• SQL Provision
• Test Data

In this independent review of SQL Provision, the Bloor analyst finds that SQL Provision’s combination of database cloning and data masking stands out with “clear advantages over competing approaches, such as data subsetting or synthetic data generation.”

Oracle for Absolute Beginners: Problem-Solving as a New Developer

• by Additional Articles

• SimpleTalk

• Oracle

Learning programming logic and syntax is just the beginning. In this article, David Njoku talks about how to debug and troubleshoot errors as a new developer.

Small Experiments in Data

• by Steve Jones

• SQLServerCentral.com

• Editorial

Amsterdam is using data to try and improve their city.

Stairway to T-SQL DML Level 4: The Mathematics of SQL: Part 1

• by Gregory Larsen

• SQLServerCentral.com

A relational database contains tables that relate to each other by key values. When querying data from these related tables you may choose to select data from a single table or many tables. If you select data from many tables, you normally join those tables together using specified join criteria. The concepts of selecting data from tables and joining tables together is all about managing and manipulating sets of data. In Level 4 of this Stairway we will explore the concepts of set theory and mathematical operators to join, merge, and return data from multiple SQL Server tables.

Free eBook: SQL Server Backup and Restore

• by Press Release

• Redgate

• ebook

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.

Monitoring your servers and databases with SCOM and SQL Monitor

• by Additional Articles

• Redgate

• Monitoring

SCOM is good at monitoring the status of your servers. SQL Monitor give you a detailed view of your SQL Server instances, and databases, right across your network, however they are hosted. By using tools appropriately, for the tasks they do well, you benefit from a simpler and more comprehensive overall strategy.

SQL Server Subquery in Select Statement with Where Clause

• by Additional Articles

• SimpleTalk

• SELECT *
• Subquery

In this part of the temporary data store tip series we look at using subqueries to select data as well as how to use for inserts, updates and deletes.

DBA Walkthrough – Adding space on IBM AIX Power Machines

• by SOLVARIA

• SQLServerCentral

• IBM
• Storage Management

Learn how to manage storage/filesystems on IBM AIX - Power machines. Learn from this demo of expanding a filesytem on AIX so that your DBA's get a high level overview of how AIX storage management works.