Author: Ben Taylor

Editorials

Symptoms of a Database in Need of Normalization

Webcast: Understanding the new culture of SharePoint You have a sponsor for SharePoint development, you have a budget, now where are all the users? Online Collaboration powered by SharePoint is not only a new technology, but a new culture of doing work. In this session we’ll explore change management (the fluffy kind) strategies that can be tailored to your user […]

Editorials

A Little Normalization Goes a Long Way

Webcast: Using Log Shipping for High Availability Log Shipping has been around in one form or another since SQL Server 2000 and many “homegrown†and third-party solutions have recently become available. This session will cover all you need to know about log shipping to use it effectively for high availability. We will look at set up, maintenance, monitoring, and failover. […]

Editorials

Who Shares Your Database Server? – Readers Respond

Webcast: Understanding the new culture of SharePoint You have a sponsor for SharePoint development, you have a budget, now where are all the users? Online Collaboration powered by SharePoint is not only a new technology, but a new culture of doing work. In this session we’ll explore change management (the fluffy kind) strategies that can be tailored to your user […]

Editorials

Who Shares Your Database Server?

Webcast: Using Log Shipping for High Availability Log Shipping has been around in one form or another since SQL Server 2000 and many “homegrown†and third-party solutions have recently become available. This session will cover all you need to know about log shipping to use it effectively for high availability. We will look at set up, maintenance, monitoring, and failover. […]

Editorials

What is the best Temporary Table Object?

Featured Script dba3_Alter_ColumnInTable_Demo Demo: Alter a Column in an existing table using the Alter Table Statement… (read more) Did You See This? CLR-Based Tools… Very interesting tools and functions for SQL Server. These folks have released a set of CLR function libraries to help you with finance, statistics, math and string functions for SQL Server. Very cool way to address […]

Editorials

Is Microsoft Leaving the Small Business Behind?

Free Virtual Expo: SharePoint – 4 Great Sessions Register here today – The May SharePoint Expo from SSWUG.ORG is a free event, open to all. The expo will include sessions on SharePoint from top-name presenters. We’ve pulled together the best of the community-rated sessions and are presenting them here in the expo, just register, attend and learn. Check out the […]

Editorials

Cross Database Dependency

Featured Article(s) Molecular MDX: Change Across Periods and Periods-to-Date Aggregations, Part 1 Part 1: Understand the basics of comparing periods, and accomplish year-to-date and other time-based aggregations, across the Time dimension. Join author Bill Pearson in a practical introduction to the mechanics of time and the analysis of change from period to period, as well as period-to-date aggregation at multiple […]

Editorials

Smaller Procedures are Better Your Responses

SelectViews Show Available Now Kalen Delaney on the show today talking about her work with SQL Server, upcoming workshops and other thoughts. Also on the show, SQL Server 2008 R2, Mary Leigh Mackey from AvePoint and much more. [Watch the Show] SSIS Class – Online, 12 Hours/classes Eric Johnson’s class starts May 15 and you can register now to attend! […]

Editorials

When Writing Stored Procedures – Smaller is Better

Webcast Today The Balance of Powers, Understanding SharePoint Governance: Is it an application? Is it a website? Is it a functional tool? No, look it up on the internet, it’s SharePoint! With most technologies users are provided with a "how to" manual and understand that complaints go to the IT department. Online collaboration powered by SharePoint doesn’t follow the same […]

Editorials

What is the Role of a DBA Today?

Featured Script admin db – meaningful Agent job notification If you want to konw the real failure message when a job fails and you want to maintain a history of job failures (and succes… (read more) Interested in Learning About SQL Server Security? Check out our upcoming virtual workshop! In the workshop, we’ll be going through things to know, SQL […]