Microsoft SQL has always included a number of date and time functions. These results of these functions were always based on the operating system for the machine the SQL server was running on. But what results will you get when you’re dealing with SQL Azure? The server(s) are all virtual. They are all based on…
Month: May 2010
SQL Saturday #46, Raleigh, NC
Coming up Saturday, September 18th 2010, SQL Saturday is coming to Raleigh. I missed the one here in Charlotte, back in March. I’m not going to miss this one! If you’re not familiar with SQL Saturdays, they’re a chance to get a ton of information on what’s new with SQL Server, and what’s coming soon….
SQL 102-SELECT * Overhead
How many of you have heard me rant against using “SELECT * FROM tableName”? If you have I’m sure you’ve heard me mention the following reasons why SELECT * is evil. the more data you ask for, the longer it takes to return that data extra paging table locking hinders future attempts to create a…
Microsoft SQL Azure FAQ
I was searching for news on Microsoft SQL Azure when I cam across this new FAQ. It answers a lot of the questions you may have, and several that I hadn’t thought to ask yet, like “how can you approximate the ROWGUID identifier… turns out using NEWID() will accomplish the same thing. I hadn’t thought…
What is SQL Azure?
I’ve been getting this question or some variant of it for weeks now. Some people are confusing SQL Azure with SQL 2008 R2, and some are thinking it’s SQL 2010. It’s neither of those. It’s its own beast. SQL Azure is a cloud version of the database management system you’ve all come to know and…
May the Forth Be With You!
While the actual anniversary for the original release of Star Wars in 1977 is still 20 days and some hours away, I’d like to do my best to remind you “The Force is what gives a Jedi his power. It’s an energy field created by all living things. It surrounds us and penetrates us. It…
SugarCRM Announces SQL Azure Support
After the efforts Microsoft has put into supporting PHP, a major PHP development company has announced they are going to begin supporting Azure. This support, along with the ease of moving from Microsoft’s traditional SQL versions to SQL Azure “was simple and straightforward, taking just a couple weeks of development time, ” according to SugarCRM’s…