Using VBScript to Automate Tasks
This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.
Apply Test-Driven Development to your Database Projects
This article from MSDN discusses the benefits of TDD and bringing unit testing to your database development.
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
Extending SQL Server Reporting Services with SQL CLR Table-Valued Functions
This article describes how to take advantage of SQL CLR table-valued functions to combine different types of data sources to create rich and exciting SQL Server Reporting Services reports.
Dreams of the Future
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
How to Break Replication
David Poole is a regular author at SQLServerCentral.com, sharing many of his knowledge and experiences with us over the years. This time he examines some of the issues that you might have with replication.
Loading a 24x7 Data Warehouse
More and more companies are using data warehouses as a way of consolidating business critical information. And more and more of these companies want the warehouse available 24 hours a day, 7 days a week. This presents interesting challenges for the DBA involved in ETL processing. Longtime author Leo Peysakhovich brings us one solution for this problem.
Dimensional Model Components: Dimensions Part II
Business Intelligence Architect Bill Pearson continues his subseries surrounding components of the Analysis Services dimensional model. In the second half of this article, we extend our focus on dimensions to include property settings for Cube Dimensions.
Featured Blog: iFTS Performance – DocidMap
This next post from MVP Simon Sabin examines one of the major improvements in performance of search.
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 KCP Pondok Lestari Tlp.cs 087878229292
Wa 087878229292 Ruko Pd. Lestari, Jl. Raden Patah No.Raya Blok C/7-8, RT.001/RW.012, Karang Tim.,...
BCA KCU MENARA BIDAKARA,Telp/Wa 0821.3111.159
Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1, Menteng Dalam, Kec....
BCA KCP Graha Raya Bintaro Tlp.cs 087878229292
Wa 087878229292 Ruko Beryl Blok BR/D, Jl. Graha Raya Bintaro No. 02,03 & 05,...
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