Read Only Tables
Do you know how to setup a read-only table in SQL Server. Steve Jones takes a look at a few methods to achieving this and examines the pros and cons of choosing different methods.
Mastering Enterprise BI: Introduction to Perspectives
Support information consumers with easier navigation and more focused analysis choices. In this article, BI Architect Bill Pearson leads hands-on exposure to Perspectives, another new Analysis Services 2005 feature.
Windows and SQL Server 2005 Clustering Architecture
Before you start learning how to cluster, this video will show you the basics on how clustering in Windows 2003 and SQL Server 2005 works. Brian shows the basic architecture on clustering as well as the checklist that you would want to follow before starting to cluster.
Considerations for Data Warehousing
What type of things do you need to look at when setting up a data warehouse? Hardware is a big one as well as the settings for the server, which may be substantially different than transactional systems most DBAs work with. Warehousing expert Vincent Rainardi brings us the next installment in his data warehousing series with some advice on what you should be looking for.
XBRL or Master Data Management?
Master data management (MDM) and eXtensible Business Reporting Language (XBRL) are two key technologies that promise to address important information management issues. Ventana Research believes both will enable companies to reduce the cost, time and effort needed to collect, analyze and use information, whether for visibility, decision support or process execution. Some observers may see them as competing approaches, but in practice each has capabilities best suited to some applications and not others. Even where they overlap, the two may not be mutually exclusive. We advise companies that have not yet begun investigating XBRL and MDM to do so immediately, and all organizations should begin developing skills in using them.
SQL Server as an IDS Tool
Intrusion Detection Systems are a great tool for security, but they have suffered from information overload with security professionals struggling to dig through the data. New author Yaroslav Pentsarskyy brings us a look at how SQL Server helped him find security issues.
Maintaining SQL Server 2005 Databases - Backups
In this presentation for SQL Server newbies, you'll learn how to maintain your SQL Server databases by backing them up regularly and reindexing them. This topic assumes you know nothing about SQL Server and also covers some of the decisions you'll have to make when you decide you want to backup your database through maintenance plans.
The Joy of Numbers
Numbers are fascinating concepts in all types of mathematics, but they can be very helpful as well in your SQL Server queries. Guru Michael Coles brings us a look at how a numbers table can you and includes a bunch of code for both SQL Server 2000 and SQL Server 2005.
Automating SQL Express Backups
SQL Express has no mechanism to schedule backups and maintenance of your instance. In this video, Brian shows you how to automate and schedule backups of SQL Express with a simple scripted solution.
SQL Server 2005 – Unattended installation – Part V
In this section of this series, I am going to demonstrate how to install SQL server 2005 service pack 1, to update the server components using command line options.
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers