Mapping Database File Objects and Fragmentation
Chris proposes a tool that would allow you to graphically see the space utilized by objects in a SQL database. Good idea?
When Do You Pull Your Hair Out?
Another adventure in the real world. Steve Jones tracks down a problem with locks on a live system. Read along and see how he works through the issues.
Terminal Services - A Couple Tips
We agree with Andy that Terminal Services is definitely a tool to have in the DBA toolbox. Like most tools, everyone uses them differently. Andy starts the discussion with some comments on how he uses TS - what about you? Do you use TS at all? Use it differently than Andy does? Prefer a different solution? Read the article and post a comment.
Review of SQLDiff by Lockwood
Chris was kind enough to take some time to put this product through it's paces and ends up giving it a very good rating. Read the article to see a nice graphical walkthrough of how to use the product.
Fixed Database Roles
This article covers four of the fixed database roles (db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter). If you're new to SQL security (and maybe even if you're not) this article is worth reading.
Cluster That Index - Part 2
Chris does a follow up to his very popular article on clustered indexes. They seem simple, but in practice they are fairly complicated. Having a solid understanding of clustered indexes will definitely help you get the results you need.
xSQL Object Public Beta
xSQL Object for Microsoft SQL Server has been designed with the DataBase Administrator in mind. Scripting, Comparing and even Synchronizing different objects like tables, views, stored procedures etc. is fast and easy.
Auditing DTS Packages
In this follow up article, Haidong explains how to audit DTS packages. While parts of it are specific to DTS, the general technique has many useful applications.
SQL DMO Poster in PDF!
Last year we did a project with Lumigent to create a DMO poster. Part of the agreement allows us to now distribute the PDF version to our readers. It's about a 400k file, print size is 24x36. We hope you DMO users will find it useful.
White Board, Flip Chart, or Notepad?
Andy discusses the low tech tools he uses at the office to convey problems and describe solutions. He also provides some interesting links you will want to browse.
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Alamat kantor BCA KCU DARMO Telp:082144477715
Wa:0821-4447-7715 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
ALAMAT KONTAK BCA KCP Katamso Telp:08218154393
WA:08218154393 Jl. Brigjen Katamso No.183, Keparakan, Kec. Mergangsan, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55121
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers