Browse by Tags
All Tags »
SQL (RSS)
As mentioned in the SQL Server Support Blog , you may find an issue installing SQL Server 2005 if you install MSXML Core Services 6.0 Service Pack 2 on Windows XP SP2, then upgrade to Windows XP SP3, then try the SQL install. Check out that post for more
Read More...
I know, I know - two announcements in a row? What's happening to this blog? This is big enough to warrant it though - SP1 is now available , and if you're using SQL 2008, you definitely want to look into this. No fancy new features, you'll get "it's just
Read More...
If you're following the PDC announcements, new, good things are coming for developers and business... MSDN is already showing some topics to get you started. Azure Services Platform . Includes Windows Azure SDK, Live Services SDK, Microsoft .NET Services
Read More...
As announced in the Data Platform Insider , the SQL Server 2008 Feature Pack has been released. This includes SQLXML 4.0 SP1, which provides support for the new date/time data types - some of the work that my team has been doing lately, all in the spirit
Read More...
What are some good XML specifications to get acquainted with? Here are the ones I find myself referring people to the most. Extensible Markup Language (XML) 1.0 (Fourth Edition) . Close to a must-read, although XML basics are simple enough that it's often
Read More...
Yes, it seems like short instructional videos are all the rage , everywhere . It's been growing for a while, of course. Still, I was happily surprised when I came across http://www.sqlservervideos.com/ today - that's a pretty specialized website! I'm
Read More...
Yes, it's available now , in all its yummy-licious editions. If you can't wait for your IT department to upgrade, you can always start building desktop / mobile applications with the free Express or Compact editions. Enjoy!
Read More...
Yay for interoperability! If you've got systems running PHP, you can now connect them to SQL Server 2005 with the PHP driver available for download at http://www.microsoft.com/downloads/details.aspx?FamilyId=61BF87E0-D031-466B-B09A-6597C21A2E2A&displaylang=en
Read More...
Steve Lasker has some very good explanations on the thinking and the trade-offs behind SQL Server Express and SQL Server Compact in this post . If you haven't kept pace with the free Express and Compact editions of SQL Server, you really are missing out.
Read More...
Not too long ago, I happened to write a post mentioning how good SQL Books Online is. Well, turns out that just today I discovered that the SQL Server User Education team has its own blog. Well, one of the highly nifty things they've already posted is
Read More...
A few days ago a friend of mine asked for some books I could recommend about developing databases. This is my personal list based on personal likes – to be extra clear, this is not an endorsement from my employer. An Introduction to Database Systems,
Read More...
The other day I was trying to drop a database , but I was getting an error because it was in use. Given that I was the only user of the database, I was a bit puzzled... I had a number of programs running, and I wasn't sure which one might be holding on
Read More...
The announcement is right here . ScottGu has a recap of the articles he's posted so far here . For those who fell like they can't wait for the download, the "What's New" page is available on MSDN here . As you can see, there's a lot of developer love
Read More...
Big decimals getting you down? Vardecimal is coming to town! OK, I couldn't come up with a smarter way to begin this post. But if you have I/O bound operation in SQL Server in tables with many decimal/numeric values, you owe it to yourself to read the
Read More...
After my DataView.RowFilter post , the next obvious step is of course a short post on using the DataView.Sort property. This property is simpler, as it simply takes column names, with a possible ASC or DESC modifier. You cannot use expressions directly
Read More...
