Featured Article(s) Tips for using alerts in SQL Server 2008 In this article, you can find some useful tips to work with SQL Server 2008 alerts. Featured White Paper(s) Why and How You Should Find and Fix Index Fragmentation In a high-volume database you need frequent critical maintenance. If you skip this important task, index fragmentation may ca… (read more) […]

Featured White Paper(s) Free Poster – SQL Server Perfmon Counters of Interest When you’re looking for a reliable tool to diagnose SQL Server issues, Perfmon is often the answer. No more wasting time trac… (read more) Featured Script Oracle: Howto: Rename or Move data files with database open Datafiles can be renamed or moved while the database is open. However, […]

Welcome to SSWUG for 2011 Well, here is my first editorial for 2011. I’ve been doing the daily editorial now for SSWUG since July, and it has been a blast. I’ve tried a number of things this year such as career tips, how to tips, high level reviews of books, tools, blogs and web sites, as well as best practices. […]

Featured Script dba3_0To20ComputedTimeOnlyValueAndFullDateTimeOffset_demo — For a GivenFullDateTimeArgument display: — GivenFullDateTimeArgument, Random 0 – 20 MinuteOffSetValue, — ComputedTime… (read more) Case Sensitive Database There are times when you wish to have your database data perform in a Case Sensitive fashion. When a database performs Case Sensitive comparisions, "A" and "a" are not equal. This configuration is usually done by selecting a […]

Email In Your Database There are many ways to enable Email within a SQL Server database and ways to take advantage of Email. If I don’t have a third party database monitoring tool, I like to use Email from SQL Server to notify me of events I need to address such as disk space, database files becoming full, Expanding Data […]