Integrating Profiler and PerfMon Log Files
In this article I'll show how to create a PerfMon counters log file and SQL Profiler Trace file, how to read them both and how to correlate the two files in SQL Profiler.
2008-02-19
2,933 reads
Additional Articles
SQL Server 2008 New DATETIME DataTypes
This article is going to cover the newly introduced data types in SQL Server 2008 July CTP, and will specifically discuss the DATETIME functions.
2008-02-18
4,431 reads
SQL Q&A: Non-Clustered Indexes and Retaining Permissions
Q What are non-clustered indexes, and what are the pros and cons of using them?
2008-02-18
2,161 reads
Designing and Delivering Rich Office Reports with SQL Server Reporting Services 2005 and SoftArtisans OfficeWriter
This white paper explains how to use SQL Server Reporting Services 2005 and SoftArtisans OfficeWriter to design and deliver full fidelity, data-driven Microsoft Excel and Word reports.
2008-02-15
3,078 reads
Implementing a Generic Data Access Layer in ADO.NET Part 3
The 3rd and final of the 3 Part Series discussing the implementation of a provider independent Data Access Layer in ADO.NET.
2008-02-15
2,789 reads
Parameter Support Objects, Pt II: Support OLAP Parameter Defaults with Datasets
Join BI Architect Bill Pearson as he continues his examination of parameterization within Analysis Services reports. In this article, we provide a solution for supporting parameter defaults that represent the last periods of data entry within our cube.
2008-02-14
1,850 reads
The Data Stewardship Approach to Data Governance: Chapter 5
Part 5 looks at beginning with a Data Governance Best Practice Assessment
2008-02-14
1,292 reads
Implementing a Generic Data Access Layer in ADO.NET Part 2
In Part 2 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.
2008-02-13
2,643 reads
Operational BI: Getting 'Real Time' About Performance
Operational business intelligence is about delivering information to people when and how they need it in the context of business need. Explore the five best practices best-in-class companies are using to drive faster, better decision making and higher customer satisfaction.
2008-02-13
2,436 reads
Change SQL Server stored procedures with batch editing
Learn how to change a group of SQL Server stored procedures (SPs) that perform tasks in your databases. Edit SQL Server SPs at one time with these steps.
2008-02-12
4,317 reads
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
What Are You Waiting For?
Comments posted to this topic are about the item What Are You Waiting For?
BCA KCU KELAPA GADING Tlpn/Wa:628213111185
Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya No.1 Lt. Dasar, 1, 9...
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
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