wagnerblog.com

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 […]

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 = […]

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 […]

This lady rocks !
Summary: Although partitioning tables and indexes has always been a design tactic chosen to improve performance and manageability in larger databases, Microsoft SQL Server 2005 has new features that simplify the design. This whitepaper describes the logical progression from manually partitioning data by creating your own tables to the preliminary features, which […]

Jimmy Nilsson blogs about the new NEWSEQUENTIALID() function in SQL Server 2005 (Yukon) which provides an incremental GUID generator and hence the long overdue answer to uniqueidentifier as a primary key. While the importance of this may well be lost on non database oriented people, this function alone will revolutionise our choice of table primary […]

As I understand it (and I havent run this tool as yet) you are required to define your own best practices. The tool then scans all selected db’s and reports to you. Get the code here.
Personally I have used FMS’s SQL Analyzer Pro. It does a very nice job of documententing every nook and […]

I must say, I really enjoy Jasper’s SQL site. There are many useful scripts and great ideas. Like this one. A utility to help w. SQL 2005 Express. Check it out here