Some useful undocumented extended and stored procedures in SQL Server 2005  Read more...

or our first feature on working DBAs and their lives, we selected Grant Fritchey, the self-styled Scary DBA, who has been so successful in the past year with his books and presentations. How does he manage to pack so much into his life? We sent Richard Morris to find out.  Read more...

If your company needs to go through a SOX (Sarbanes–Oxley) audit or any security audit, the DBA has to provide security information to them. If you have purchased third party tools to provide this information that is great. If you don't have third party tools and need to go through many servers to provide this information it can be a hassle and very time consuming. So I put together a script to generate a report that I could just review. The script generates a report of all elevated level accounts and any possible security holes.  Read more...

It seems that the ownership of jobs is something that is often overlooked when articles explain   Read more...

The Worktamer conference is coming to a series of cities in Canada in early 2010. If you're near Vancouver, Toronto, or Montreal, read about this one day event to help you boost your professional development.  Read more...

You have a Windows 64-bit server and need to install the 32-bit version of SQL Server 2005 Reporting Services on this machine. In this tip I will walk through the steps you need to take for this installation.  Read more...

Continuing our discussion, this article covers the remaining tasks necessary to implement a full-text index in SQL Server 2005 Express Edition.  Read more...

Part 3 of a great series on the basics of indexes. This time MVP Gail Shaw examines the non-clustered index. Learn the structure, definition, and how to examine the use of these indexes in your queries.  Read more...

Somebody Has to Do It, Apparently  Read more...

The list of builds for SQL Server 2008 updated with Cumulative Update 5 for SP1 and CU8 for RTM.  Read more...

One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA....  Read more...

After several tries I think we finally have it working.  If you were unable to attend the last two SQLLunches,...  Read more...