Featured Article(s) Troubleshooting SQL Server 2008 alerts In this article, Alexander Chigrik explains some problems you can have with SQL Server 2008 alerts. He also tells how you can resolve these problems. 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, […]

Have You Seen the Latest SQL Server Show? Check out SelectViews – it’s an online show about the database world, including tips, news happenings. [Watch the Show Here] Are You Working with New Database Platforms? There are so many different things happening with new database platforms. From cloud-based alternatives that look and feel like your existing servers to cloud-based systems […]

Featured Article(s) Installing and Configuring Reporting Services (Part 3 of 3) In this session, readers will learn the basics of installing Microsoft SQL Server Reporting Services. This session will cover common installation situations and will discuss some of the more common pitfalls that surround the installation. This session will also cover the basics of Reporting Services configuration options, including basic […]

New SelecTViews Show Available! More, smaller databases? Manage your checklists, our featured blog of the week for business intelligence…Also, the hotmail outage and SQL Server, 3rd party tools and more. [Watch The Show Here] Featured Article(s) Improving .NET Application Performance and Reliability with Managed Database Connectivity (Part 1 of 3) Whether your .NET applications are built using C# or VB.NET, […]

Featured White Paper(s) An Introduction to Workload Tuning Workload Tuning is just what it sounds like: tuning the performance of all processes that comprise a database workload in one… (read more) Featured Script dba3_fn_TableIdentityColumns_WithIdentCurrent_Article UDF, returns identity column names With Ident Current values for a designated table in the same database. Requires a paramete… (read more) Authentication vs. Authorization Authentication […]

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 […]