Database Weekly - May 5, 2008
A look back at the news of the past week dealing with SQL Injection, slow SQL Server growth and two level security.
The Dedicated Administrator Connection
New to SQL Server 2005 is the Dedicated Administrator Connection (DAC), which provides a way to ensure you can always connect to your server. No more getting locked out of a busy server as could occur in prior versions. Wayne Fillis brings us a short tutorial on this handy new feature.
Getting Organized
As DBAs we should be very detail oriented, but Steve Jones talks about some challenges with keeping up with your tasks and projects and some software that might help.
Getting Organized
As DBAs we should be very detail oriented, but Steve Jones talks about some challenges with keeping up with your tasks and projects and some software that might help.
SQL Server 2008 (Katmai) Reporting Services Performance: Two Steps Forward, One Step Back?
In this article, David Leibowitz compares the performance of the prerelease of Microsoft's SQL Server 2008 Reporting Services to SSRS 2005. While it is clear performance improvements have been made for report automation, developers might have differing opinions on the new Report Designer.
SqlCredit – Part 15: The Cost of Distribution
Part 15 of this series examines what cost is paid when tables are separated into multiple databases on the same server.
The Shortage of Programmers
Steve Jones thinks that programmers should be able to negotiate any deal they can and Joel Spolsky has no reason to be upset.
The Shortage of Programmers
Steve Jones thinks that programmers should be able to negotiate any deal they can and Joel Spolsky has no reason to be upset.
The Shortage of Programmers
Steve Jones thinks that programmers should be able to negotiate any deal they can and Joel Spolsky has no reason to be upset.
Is XML the Answer?
New Author! Don Peterson writes his first article for us and explores why he considers XML to be...bad! There are some interesting points made here and if you've haven't thought about what XML means to you as a DBA, it's a subject worth spending some time on.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA Rukan Patria Call CSO; (+62 821°3111°179
Rukan Patria Park, Jl. DI. Panjaitan No.6 RK 05, RT.6/RW.11, Cipinang Cempedak, Jatinegara, East...
BCA Multifinance Cabang Kedoya Telpon/WA:.0851•8812•0691
BCA Multifinance Cabang Kedoya Telpon/WA:.0851•8812•0691 Citta Graha, Jl. Panjang, RT.5/RW.1, South Kedoya, Kebonjeruk, West...
BCA KCP MT Haryono Call CSO; (+62 821°3111°179
Gedung Patria Park Jl. D.I. Panjaitan Kav. 5-6-7, Rukan-MZ No.RK 01 Lt.G-01, RT.5/RW.11, Wil,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers