SQL Server Reporting Services
Not yet in beta, MS is working on an add on product similar to Notification Services.
2003-06-06
4,010 reads
Administration
Importing And Analyzing Event Logs
Another new author! Gheorge shares some ideas about importing event logs and using OLAP to analyze the results. Not a bad idea at all. How many of use OLAP as often as we should? Read the article, see if it's something you want to try - and let Gheorge know what you think!
2003-05-28
13,073 reads
Changing Rogue Database Collations
Collations hard to sort out (I know, bad joke)? Mike did what a good DBA gets paid to do, figure out an easy way to fix something and remove the chance of a user mistake at the same time. Good explanation and a couple scripts show how to handle column level collations.
2003-05-26
12,824 reads
SQL Stripes 0.50 Build 180 Released
SQL Stripes is an application that helps you - the SQL Server DBA, to have complete control over your servers. From the high-level of monitoring essential components to the low-level of analyzing your various databases. SQL Stripes is an intuitive and easy to use application and is intended for SQL Server DBA who want to have an easier life. SQL Stripes is completely free! (Announcement, not reviewed)
2003-05-20
461 reads
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.
2003-05-12
5,523 reads
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.
2003-05-08
1,600 reads
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.
2003-05-06
2,750 reads
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.
2003-05-05
22,513 reads
Using Query Analyzer Templates
Greg returns with an article based on some practical experience using QA templates to save time and work. Good examples, good work through, good idea!
2003-04-28
10,438 reads
System RAM Comparison
Another link from Steve Jones, this page has a great breakdown of the different types of RAM.
2003-04-24
808 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
Alamat Telp BCA KCP Poris Indah (+62) 838-4945-0961
Wa:083849450961 Ruko Poris Indah, Komp, Jl. Poris Indah Blok K No. 2-3, RT.003/RW.003, Cipondoh...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers