Wagnerblog

This could come in handy.
read more

I skipped over the details when I read Scotts post on 3Leaf. Here was a comment from another blogger that made me sit up and take notice:
“…My only response to this is “yup!” . SQL Server Express is one of the projects I’ve most enjoyed working on in this release. The ability to have a [...]

When you need to know which parts of your app to tweak in order to make it perform better, this is the tool to get. We briefly used Veritas InDepth to analyze database and proc performance and were very impressed. Its especially useful in determining which procs needed the most attention. Running the tool on [...]

I’m still not the biggest fan of xml. In my mind its a great replacement for EDI but thats about it. Yes I know there is sooo much more it can do. But I prefer good old objects to angle brackets. That said, here is a small note from Bob Beauchemin regarding XQuery validation of [...]

According to Early & Adopter You can actually attach a SQL Server 2005 database to VB 6. It looks like this:
Private Sub Form_Load()
Dim cn As ADODB.Connection
Set cn = New Connection
cn.ConnectionString = “Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;AttachDBFileName=” & App.Path & “\sales.mdf;Data Source=server1\sqlexpress”
cn.Open
Dim rs As Recordset
Set rs = New Recordset
rs.Open “Select * from monthlysales”, cn
Set MSHFlexGrid1.DataSource = rs
End [...]

Via Mike Gunderloy: Some folks have reported problems with the default installation of SQL Server 2005’s October release. Here are some suggestions noted by Wally.
Read them

Mike Gunderloy: If you’ve worked with Microsoft SQL Server at all, you’ve run across SQL Query Analyzer. Of course, this tool is essential for running ad hoc queries and executing SQL statements. But have you ever taken the time to really investigate its capabilities? The SQL Server developers built a lot of functionality into Query [...]

In a perfect world we wouldn’t need standby servers for our SQL Servers. Our hardware would never fail, NT Server 4.0 or Windows 2000 would never blue screen, SQL Server would never stop running, and our applications would never balk.
In a partially perfect work, we could afford very expensive clustered SQL Servers that automatically failover [...]

Red Gate Software has a free e-book.
“… This book is full of “essays and ideas from the SQL Server community,” and is a valuable resource for anyone working with SQL Server…”
Download here

Read80Trace is a command line utility for processing trace files generated by SQL Server 2000. As output, it generates RML files and/or a database populated with normalized data that can be useful for analyzing the performance of the system. Read80Trace requires that the destination database also run SQL Server 2000 or later.
OSTRESS is a multithreaded [...]