Author: Ben Taylor

Editorials

SQL Server DBAs Visionary?

Don’t Miss The Latest SQL Server Show, SelectViews > Watch here – this week’s show is about understanding SSIS. What is "Vision" And Do You, As A DBA, Participate? Last week I posted a request for questions to be included in our survey of database professionals. One of the question suggestions I received (Thanks Jeremy!) was about vision. Specifically, do […]

Uncategorized

How To SSIS SelectViews Show Is Live Now

Latest SelectViews SQL Server Show Posted We’ve had excellent feedback on our series of how-to shows that we started last week and are continuing this week. We’ll have our final in this series next week and are taking your feedback and suggestions on these as we go forward. Please keep the comments, suggestions, feedback and referrals coming! (Special Edition) – […]

Editorials

How To SSIS SelectViews Show Is Live Now

Latest SelectViews SQL Server Show Posted We’ve had excellent feedback on our series of how-to shows that we started last week and are continuing this week. We’ll have our final in this series next week and are taking your feedback and suggestions on these as we go forward. Please keep the comments, suggestions, feedback and referrals coming! (Special Edition) – […]

Uncategorized

What Would You Ask Other SQL Server Pros?

Last Day to Catch Last Week’s Show > SelectViews: SQL Server Show: Getting Started with Reporting Services Power-Up Your SQL Server by Up To 500% By using some excellent technology to drive your SQL Server better, moving the TempDB file onto a RamDisk and running optimization software. At a fraction of the cost of new servers and peripherals, you can […]

Editorials

What Would You Ask Other SQL Server Pros?

Last Day to Catch Last Week’s Show > SelectViews: SQL Server Show: Getting Started with Reporting Services Power-Up Your SQL Server by Up To 500% By using some excellent technology to drive your SQL Server better, moving the TempDB file onto a RamDisk and running optimization software. At a fraction of the cost of new servers and peripherals, you can […]

Uncategorized

Get to Know Your Data

Featured Article(s) Tips for using SQL Server 2005 Snapshot Replication (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 Snapshot Replication. Watch Now: Using SQL Agent to Automate Tasks with SQL Server Find out how to use the SQL Server Agent to run jobs automatically on your system. From maintenance to pulling information to […]

Editorials

Get to Know Your Data

Featured Article(s) Tips for using SQL Server 2005 Snapshot Replication (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 Snapshot Replication. Watch Now: Using SQL Agent to Automate Tasks with SQL Server Find out how to use the SQL Server Agent to run jobs automatically on your system. From maintenance to pulling information to […]

Uncategorized

Good Suggestions for Security

Featured Article(s) Risk Management — Prevention is better than cure [Part II] We have had a look at Risk Management in the earlier part of this series. This is the concluding part of this series of my articles on Risk Management and discusses the activities involved in the Risk Management process and the roles and responsibilities of a Risk Manager. […]

Editorials

Good Suggestions for Security

Featured Article(s) Risk Management — Prevention is better than cure [Part II] We have had a look at Risk Management in the earlier part of this series. This is the concluding part of this series of my articles on Risk Management and discusses the activities involved in the Risk Management process and the roles and responsibilities of a Risk Manager. […]

Uncategorized

Mass Data Management

Don’t Miss the Latest SQL Server Show Posted Friday, the show is a "Best Of" with information about getting started with Reporting Services > Watch Here Featured Article(s) Populating Sparse or Missing Series Data Using Partitioned Outer Joins This article describes how to populate sparse or missing serial data with Oracle’s partitioned outer join. This tool is essential for correct […]