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
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers