The Database Weekly Update for June 30, 2008
Steve Jones looks back at a week of news on data center infrastructure, the EF war, and SQL Server 2008 news.
The Database Weekly Update for June 30, 2008
Steve Jones looks back at a week of news on data center infrastructure, the EF war, and SQL Server 2008 news.
The Database Weekly Update for June 30, 2008
Steve Jones looks back at a week of news on data center infrastructure, the EF war, and SQL Server 2008 news.
Log Shipping vs. Replication
SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.
The Multiple Instance Dilemna
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
Many-to-Many Dimensions in Analysis Services 2005
See an example of using the Many-to-Many dimension in SQL Server 2005 Analysis Services to analyze sales data, and get ideas for other uses such as treating medical conditions, software testing, and more.
SQL Server memory configurations for procedure cache
SQL Server expert Denny Cherry explains how SQL Server determines how much memory is used for procedure and buffer cache and how you can allocate available memory.
Return Query Text Along With sp_who2 Using Dynamic Management Views
This article describes how to generate the sp_who2 results including the query text for the spid.
SQL Know How
Training in the UK this fall from a variety of SQL Server experts. If you are in the area, I'd recommend one of these classes.
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 Finance Batam Layanan Mobil & Motor Call Cs: (+62 821°3111°179
Unnamed Road, Sungai Panas, Kec. Batam Kota, Kota Batam, Kepulauan Riau 29444
BCA KCP Daan Mogot Baru Tlp.cs 087878229292
By Buffalo's Best Roofing Company LLC
Wa 087878229292 Rukan Pusat Bisnis, Jl. Daan Mogot Baru No.9 & 10 Blok KJF,...
BCA Finance Belitung Layanan Mobil Call Cs: (+62 821°3111°179
Jl. Jend. Sudirman, RT.016/RW.006, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten Belitung, Kepulauan Bangka Belitung...
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