1 hour ago by pinaldave

Guide to Migrating from MySQL to SQL Server 2008 In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps necessary to convert a MySQL database to SQL Server. Guide to Migrating from Oracle to SQL Server 2008 This white paper expl ...

Journey to SQL Authority ... - blog.sqlauthority.com · Rank: 6,528 · 185 references

4 hours ago by Andy Grant

I read a post recently on The Grateful DBA that describes his analysis in testing different compression levels in LiteSpeed for SQL Server and their impact on both backup size and efficiency. In his own words this is a “non-scientific, ground-level look at LiteSpeed’s compression ratios”, but I thin ...

Inside Quest: SQL Server ... - questkb.com · 1 reference

6 hours ago by Chris Miller

We have a few applications that let the user select the database connection details. It’s for SQL Server 2005/2008 and they can pick the server protocol, server name, and the database. Once they select a database server, the user selects the database from a pick list selection. We filter that list t ...

Christopher Miller's ... - anotherlab.rajapet.net · 12 references

7 hours ago by Mike Walsh

A Great Idea – #SQLHelp hashtag on Twitter I was following a conversation today between Brent Ozar, who is @BrentO on twitter and Aaron Nelson, who is @SQLVariant on twitter. A great idea was discussed: A twitter hashtag that, as Jorge Segarra (or @SQLChicken on twitter) describes it in his blog pos ...

StraightPath Solutions SQL ... - straightpathsql.com/blog · Rank: 68,437 · 33 references

9 hours ago by letter2sanjay1

Many SQL books and tutorials recommend that you “avoid cross joins” or “beware of Cartesian products” when writing your SELECT statements, which occur when you don’t express joins between your tables. It’s true that you need to ensure that your join conditions are adequately stated so that you don’t ...

Sanjay's Blog - dotnettrick.wordpress.com

9 hours ago by David Edwards

Nicklas Westerlund has published the 173 rd edition of Log Buffer, the weekly review of database blogs, on SELECT mysqlgenie FROM lamp;. Log Buffer will be off next week for the holidays, and back early in 2010 to begin another year of presenting the best of database blogs. Please get in touch with ...

Pythian Group Blog - pythian.com/news · Rank: 64,890 · 21 references

10 hours ago by Nick Westerlund

Time keeps on moving and we’re now only one week from Christmas, when people spend time with their families and loved ones. But, that is in a week, today it is time for a new edition of Log Buffer, where we catch up on database blogs from across the world, starting with SQL Server. SQL Server Over a ...

SELECT mysqlgenie FROM lamp; - mysqlgenie.com/wordpress · 1 reference

12 hours ago by Chintana

Pointing WSO2 Identity Server to use user data stored in an external database has never been this easy. Once you complete the following it just works without having to do any other configuration or editing config files. All this can be done in few seconds using the excellent, intuitive web based man ...

Engwar - engwar.com · 6 references

12 hours ago by Brent Ozar

Yes, the guy who wrote that certifications are icing, not cake finally got himself some icing. I was an MCSE on Windows NT4 in 1999, but I let my certifications lapse over time because I just didn’t see the value in them. I’m not saying I do now – I only got them because they were a prerequisite to ...

Brent Ozar - SQL Server DBA - brentozar.com · Rank: 10,720 · 227 references

13 hours ago by Brent Ozar

You’ve got questions, we’ve got answers. No, not Radio Shack – Twitter. Right now, no matter when you’re reading this, there are people on Twitter who can answer quick questions for you. Thanks to an excellent idea by Aaron Nelson (@SQLVariant), it’s even easier now. In this post, I’ll show how to a ...

Brent Ozar - SQL Server DBA - brentozar.com · Rank: 10,720 · 227 references