DatabaseJournal.com Staff

This script from Matthew L. Kearns quickly returns table and index disk space and row counts for all tables in the current database. Essentially, the script puts the table names into a cursor and then spits out sp_spaceused results into a temp table. The contents of the temp table can be displayed in the sort […]

[From The Register] Mainstream database management system (DBMS) technology faces a challenge from new approaches that reject the relational model. The battleground is set to be the market for business intelligence based on very large databases. Some main players in DBMS software are already jockeying for position with revamped database products aimed at recapturing ground […]

by Shaunt Khaldtiance One of the housekeeping challenges DBAs face is to keep track of their databases’ growth and how much space is being used by each table and index in those databases. To meet this challenge, I wrote a stored procedure, SpaceUsedAnalyzer, that extends the functionality of the spaceused system stored procedure to present […]

[From Blogs MSDN] SP3 for SQL Server 2005 has been in CTP for a while now (10/27/08) and all is appearing to be really good. I finally got around to installing the beta patch the other night on my home servers and experienced no issues at all. So… what is this going to give us? […]

[From SQL Server Magazine] With the arrival of SQL Server 2008 we gained access to a new feature called Change Data Capture (CDC). CDC enables you to constantly stream change data to a consuming process, most notably Extract, Transform, and Load (ETL) applications. In the SQL Server environment the ETL application used is of course […]

[From SQL Server Magazine] Developers don’t come to the Dev Connections conference for big announcements about major new products from Microsoft. They come for intense hands on sessions with experts in various Microsoft technologies. Some of the expert speakers are from Microsoft and many are not. Their candor about the products gives the conference its […]

[From OTN] Many security architects have the false impression that configuring two-way SSL is sufficient to verify the client and restrict access to only trusted clients. This is actually not the case. In fact, many people set up two-way SSL with Verisign and nothing else, despite the fact that Verisign is designed only for trust—not […]

[From small Business Computing] The basic forms and reports that Access creates automatically make a good starting point for your database projects. It is, however, likely that you’ll want to improve them so they look better and are more functional. In this article I’ll show you how you can use Access Design View to add […]

Here is a simple stored procedure for SQL Server 2000 (should work on SQL 7 as well) that lists users (like sp_who), locks (like sp_lock), and the input buffers of blocked and blocking users. Author: Mitch van Huuksloot Download Script: sp_activity-2k.sql Disclaimer: We hope that the information on these script pages is valuable to you. […]

[From WebReference] Now we have some ideas about database, we quickly run into another requirement. Many websites will want to control who has access to what. Once embarked on this route, it turns out there are many situations where access control is appropriate, and they can easily become very complex. So in this chapter we […]

>>Script Language and Platform: Oracle I stumbled on a problem with between values and wanted to share the issue. While using between operator, only values in ascending order are accepted. If values in descending order are given, you get no rows. However, if you use >= and <= operators, you have the privilege to use […]

by Breck Carter Overview SQL Anywhere 11 has a surprisingly large number of new features, especially when you consider the huge number of features introduced only two years ago in SQL Anywhere 10. This article presents a Top 10 list of new features in SQL Anywhere 11 that developers are likely to find most interesting. […]