SQL Express Beta 2 is coming soon [http://blogs.msdn.com/sqlexpress] and the Internet Explorer Team blog [http://blogs.msdn.com/ie/archive/2004/07/21/190747.aspx] is buzzing. Talking of SQL Express, here are the Top 10 Cool Things about SQL Server 2005 Express Edition [http://lab.…
SqlHtml [http://thedailywtf.com/archive/2004/07/22/649.aspx] is an interesting but (IMHO) highly inefficient idea (a parody I assume) of generating HTML directly from the database tier. But the worrying part is that many “developers” still use crude methods like these while developing “enterprise level” applications. Its…
A few days back, my friend Pankaj was enquiring about a particular case where he needed to automate the backup (in the form of SQL scripts) of all SQL Jobs (schedules) on a SQL Server. DTS doesn’t support automatic scripting of SQL Jobs from what I could tell. I…
Bob Beauchemin gives an introduction on SQL Native Client (SNAC) … [http://staff.develop.com/bobb/weblog/PermaLink.aspx?guid=a7f64240-60ae-4031-9580-05bdc10e2c93] > If you’ve recently installed the SQL Express version of SQL Server 2005, you may or may not have noticed SQL Native Client (SNAC). If you want to use…
SQL Server 2000 Reporting Services, Service Pack 1 [http://www.microsoft.com/downloads/details.aspx?familyid=580febf7-2972-40e7-bccf-6cd90ac2f464&displaylang=en] is available now. Some interesting comments on how it compares to Crystal Reports 9 on my old .NET blog [http://weblogs.asp.net/ashben/archive/2003/11/21/39022.aspx]…
ADO.NET 2.0 Feature Matrix [http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnvs05/html/ado2featurematrix.asp] [via Scott Swigart [http://ea.3leaf.com/2004/07/adonet_20_featu.html]]…
Data Mining FAQ [http://msdn.microsoft.com/sql/sqlwarehouse/dmfaq.aspx] [via Christa Carpentiere [http://sqljunkies.com/WebLog/christac/archive/2004/07/12/3480.aspx]]…
SQL Server Express Edition [http://lab.msdn.microsoft.com/express/sql/default.aspx] (Technical Preview) is a version of SQL Server 2005 designed for building simple, dynamic applications. The next face of MSDE.…