Basics of XML and SQL Server, Part 1: Streaming XML
This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.
Data Gravity
Does data have gravity? Will the law affect how applications are built and deployed? Steve Jones has a few thoughts.
Three Attack Vectors in SQL Server 2005
This article outlines three different tried and tested methods of obtaining access to databases in SQL Server 2005 where no database-level administrative access exists.
SQL Server 2012 - The Virtual Launch Event
Microsoft has scheduled a virtual launch event for SQL Server 2012 on Mar 7. Register now to learn about the next version of SQL Server.
Large table cleanup with minimal locks
How do you delete millions of rows with minimal impact to the business? This article gives you a way to accomplish the removal of old data.
Zettabyte
Today we have an editorial originally published on Mar 13, 2007 that is being re-run as Steve is on vacation. This one looks at all the world's data.
SQL Saturday #114 - Vancouver
A free day of SQL Server training in Vancouver, BC, Canada on Mar 17, 2012.
SQL Saturday #115 - Portugal
A free day of SQL Server training in Lisbon. Register and come if you can.
Code Scanning
Today Steve Jones talks about code scanning and the analysis that tools can do for us today.
TSQL Challenge 77-Transform monthly resource efforts to weekly actuals
The challenge is to transform monthly resource efforts into weekly actuals.
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
Alamat BCA KCU BUKIT BARISAN Telp/WA:0817629933
Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera Utara 20111
BCA KCP Kas Narogong Tlpn/wa:085373737551
Jl. San Francisco Narogong - Cileungsi; No. 6 & 7, Limus Nunggal, Kec. Cileungsi,...
BCA KCU THAMRIN. Tlp:(+62) 823-72744391
Menara BCA, Grand Indonesia, Jl. MH Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
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