Additional Articles

All authors

Technical Article

International Features in Microsoft SQL Server 2005

This white paper introduces Microsoft SQL Server developers to the international features of Microsoft SQL Server 2005. Topics covered include an explanation of Unicode, added support for supplementary characters in SQL Server 2005, the changes in collation in different versions of SQL Server, changes in data types, performance, updates on data providers, and new international support features in SQL Server 2005 Analysis Services and Integration Services.

2008-04-25

3,058 reads

External Article

Reading the SQL Server log files using T-SQL

One of the issues I have is that the SQL Server Error Log is quite large and it is not always easy to view the contents with the Log File Viewer. In a previous tip "Simple way to find errors in SQL Server error log" you discussed a method of searching the error log using VBScript. Are there any other easy ways to search and find errors in the error log files?

2008-04-23

4,240 reads

External Article

Identify SQL Server 2005 Standard Login Settings

Gaining insight into my SQL Server standard and Windows logins has historically been a challenge in terms of determining password changes, failed login attempts, etc. I have noticed that you have experienced the same issue with your tip entitled 'When was the last time the SQL Server sa password changed' and I have noticed some information in the forums on the topic as well.

2008-04-21

3,407 reads

All authors

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Surabaya Tlpn/wa:085373737551

By horacio_navarro

Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara 20212

BCA KCP Iskandar Muda Tlpn/wa:085373737551

By horacio_navarro

Jl. Iskandar Muda No.123, Sei Sikambing D, Kec. Medan Petisah, Kota Medan, Sumatera Utara...

BCA KCP MT Haryono. Tlp:085373737845

By khalique.manyar

Gedung Patria Park Jl. D.I. Panjaitan Kav. 5-6-7, Rukan-MZ No.RK 01 Lt.G-01, RT.5/RW.11, Wil,...

Visit the forum

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