Multi-Script, Multi-DB Deployments
A way to handle application releases involving multiple scripts and/or multiple databases.
Rating Bugs
How do you triage and rate the bugs that come in for software? How should Microsoft do this for SQL Server. Steve Jones has a few comments.
Tracy Hamlin elected Exceptional DBA of 2010
Congratulations to Tracy Hamlin, voted to be the Exceptional DBA of 2010.
TSQL Challenge 37 - Calculate the downtime and duration of servers bas
This is a challenge to identify the downtime of servers from the log data generated by a monitoring application.
How to execute a DOS command when xp_cmdshell is disabled
For security reasons many sites disable the extended stored procedure xp_cmdshell, which is used to run DOS commands or executables. When you really have to run a DOS command or an executable from a stored procedure how can you get around this limitation without a breakdown in security.
Linking to the Previous Row
One common problem in querying is to reference the previous row in a data set as part of a calculation. David McKinney brings us an interesting solution using SQL Server 2005.
Personal Investments
This Friday Steve Jones talks about your career, and training, and what you are doing about it.
Expert Analysis: A Case for Socialization of Data
It's time to integrate social data, enterprise analytics and enterprise data for better social-media strategy.
Beyond Automation
Are there some things that are beyond automation in your company? Steve Jones comments on the difficulty of changing things with automation in some cases.
Convert Mirroring to Log Shipping
Describes how to convert database mirroring to log shipping in SQL 2005/2008.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
BCA KCU KUNINGAN NO TELPON 087781685658
Cyber 2, Gedung Menara Karya,WHATSAPP 087781685658 Jl. H. R. Rasuna Said Ground Floor, RT.7/RW.2,...
We Are Eating Our Own Seed Corn
Comments posted to this topic are about the item We Are Eating Our Own...
BCA KCU BANDUNG
PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers