This article brings us an SSIS package that reads an XML file and sequentially displays each XML record in a MessageBox before inserting it into a staging table. You can use this to get XML data into your SQL Server database for further processing.
Indexes help your application find your data quickly and provide users with a well performing application, while minimizing server resources. This article discusses indexing guidelines related to join tables and covering indexes.
If you want to speak at SQL Saturday #38 in Jacksonville, FL on May 8, 2010, there's still time to submit a session.
With the launch of SQL Server 2008 R2 almost upon us, DBAs need to start planning in some time to see what it has to offer. Brad McGehee reviews some of the available resources.
Log shipping is a tool that has more benefits than just recovering from a major disaster. Steve Jones thinks this might be a tool that DBAs should use for all their critical databases.
We are working on the migration to SQL Server 2008 and have geospatial data that we would like to move over as well. As part of our application we house information on locations across the globe. Which data type should we use?
For this Friday's poll, Steve Jones asks if there is a set of essential software that every DBA needs to have installed on their machine.
This article examines the various methods for retrieving data from an Audit table.
Fabiano Amorim is hooked on today's Integrated Development Environments with built-in Intellisense, so he looked forward keenly to SQL Server 2008's native intellisense. He was disappointed at how it turned out, so turned instead to SQL Prompt. Fabiano explains why he prefers to SQL Prompt, why he reckons it fits in with the way that database developers work, and goes on to describe some of the features he'd like to see in it
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Comments posted to this topic are about the item Checking the Error Log II
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers