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
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
ALAMAT KONTAK BCA KCP Cikande WA {08218154393}
WA:08218154393 Kawasan Industri Modern Cikande, Komp. Ruko, Jl. Raya Jkt No.Km. 68 Blok C-6,...
ALAMAT KONTAK BCA KCP Ciceri Telp:08218154393
WA:08218154393 Jl. Jend. Sudirman No.38, Sumurpecung, Kec. Serang, Kota Serang, Banten 42118
Alamat Kantor BCA KCU SIDOARJO Wa(082144477715)
Wa:0821-4447-7715 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers