Reading XML documents using LINQ to XML
As XML has become a popular means to store data for ease of interoperability, how do we use LINQ to query XML data?
2008-07-09
3,607 reads
Additional Articles
Professional Certification for DBAs
In this article, republished from Brad McGehee's book 'How to Become an Exceptional DBA', Brad explains why there are several advantages for DBAs in continuing to take exams throughout their careers.
2008-07-08
5,554 reads
Rebuilding the SQL Server master database - Part 1
So, how do you prepare for a master rebuild and what do you do afterwards? Hopefully this checklist will give you an idea.
2008-07-08
4,416 reads
Implementing Upgrade of SQL Server 2005 Express Edition
In the previous installment of our series, we presented a variety of reasons that might influence your decision to upgrade a full-fledged member of the SQL Server 2005 family. This article discusses the actual implementation of this process, pointing out additional factors that might affect its complexity.
2008-07-07
1,969 reads
SQL Server local disk storage to SANs
Storage area networks (SANs) improve SQL Server performance. Set up SANs on SQL Server with these best practices on migrating to, and configuring SANs.
2008-07-07
4,584 reads
How to Export Data to Microsoft Office Excel 2007 Using SQL Server 2005
This article provides a step by step guide on how to export data to Microsoft Office Excel 2007
2008-07-04
8,937 reads
Managed Data Access Inside SQL Server with ADO.NET and SQLCLR
Using the new SQLCLR feature, managed code can use ADO.NET when running inside SQL Server 2005. Learn about SQLCLR via basic scenarios of in-process data access, SQLCLR constructs, and their interactions.
2008-07-04
2,591 reads
Missing Date Ranges- the Sequel
Alex Kozak returns with another Date puzzle. A question from a Simple-Talk reader gives Alex the inspiration to see if is possible to list unused date ranges in one Select statement.
2008-07-03
3,048 reads
The Many Uses of Coalesce in SQL Server
Many times people come across the Coalesce function and think that it is just a more powerful form of ISNULL. In actuality, I have found it to be one of the most useful functions with the least documentation. In this tip, I will show you the basic use of Coalesce and also some features you probably never new existed.
2008-07-03
7,361 reads
Recursive Queries using Common Table Expressions (CTE) in SQL Server
The problem arises when the hierarchy level increases as SQL Server is limited to 32 levels of recursion. We need a better way to implement recursive queries in SQL Server 2005. How do we do it?
2008-07-02
5,894 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
BCA KCP Grand Mall Bekasi Tlpn/wa:085373737551
Jl. Jend. Sudirman No.99, RT.001/RW.007, Kranji, Kec. Bekasi Bar., Kota Bks, DKI Jakarta 17135
BCA KCU HARAPAN INDAH Tlpn/wa:085373737551
Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2 No. 1, Pusaka Rakyat, Kec....
BCA KCP Arundina Cibubur Telpon/WA:085188120691
BCA KCP Arundina Cibubur Telpon/WA:085188120691 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26...
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