Comparison of Business Intelligence Strategies between SQL and Oracle
Dinesh does a good write up on research he did investigating the BI market and doing a feature comparison between Oracle 9i and SQL 2000. Simple bullet point format, worth a look.
SQL Server Security: The db_executor Role
Brian will be writing a monthly column for us on SQL Security, definitely a hot topic these days! He starts off by discussing the need for a built in db_executor role and how to grant permissions manually to achieve the same effect. Terrific concept, as granting table access can lead to bad things! If there is a security topic you'd like to see more info on, post a note to the article or email us at articles@sqlservercentral.com.
A Sneak Peak at Windows 2003
Microsoft has been running 2 day seminars on Windows 2003 across the country as well as at selected Enterprise Partner sites. Steve Jones recently attended one and has a first look at the next generation of Windows Servers.
Webcast: 0 to Cluster in 60 Minutes-Clustering Windows and SQL Server
In this session we’ll rapidly discuss the MSCS clustering architecture and deploying the system into your environment. We’ll then jump into a demo where we actually cluster a Windows and SQL Server system in under 60 minutes. We’ll discuss the administration tools and best practices on clustering and walk you through completing a cluster and fixing problems along the way. After this session, you should have just enough information to build you own SQL Server that is highly available.
SQLInserts 2.0 Released
LockwoodTech has released a new version of SQLInserts with an entirely redesigned interface that supports client-side WHERE clauses, column level scripting, table level row maximums and much more.
Integrating SQL LiteSpeed in your existing Backup Infrastructure
This articles makes the case for using SQL LiteSpeed over other backup solutions and presents some notes about why the DBA should manage backups rather than offloading to network administration.
Economies of Speed Whitepaper
Seagate has a white paper out that discusses how faster (15k rpm) drives can lead to lower cost of ownership. Interesting, and worth looking into.
Handling The Text Data Type
Robert is back this week with a look at the text data type. Not the easiest thing to work with, but sometimes a varchar just doesn't give you the range you need.
An Automated Solution for Migrating Database Structures
This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.
Auto Close and Auto Shrink - Just Don't
New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers