Monthly Archives: January 2013

anyone use mysql proxy?

I’ve always been interested in this product, maybe today is the day I try it. http://dev.mysql.com/downloads/mysql-proxy/ MySQL Proxy is a simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication. Its flexibility … Continue reading

Posted in SQL Server | Tagged | Comments Off on anyone use mysql proxy?

MS Office and Ruby – The Next Level

Interesting, had to share http://www.dapaz.net/blog/blog/2013/01/21/ms-office-and-ruby/

Posted in SQL Server | Tagged | Comments Off on MS Office and Ruby – The Next Level

do views increase performance?

I’m a huge fan of views. I’m always understood that queries that hit a view are rewritten into simpler SQL Statements, but I wanted to demonstrate some examples where hitting a view is ~100 times faster than hitting the base … Continue reading

Posted in SQL Server | Tagged | 2 Comments

Datasets Archive

This is a great resource for getting sample datasets!! http://www.reddit.com/r/datasets

Posted in SQL Server | Tagged | Comments Off on Datasets Archive

Micron's new terabyte-class SSD is under $600

What’s amazing to me is how much we accomplished with AWFUL hardware 10 years ago.  I used to work on a 5tb database at Microsoft on a Pentium3… when I got there, users were writing SQL and waiting an hour.. … Continue reading

Posted in SQL Server | Tagged | Comments Off on Micron's new terabyte-class SSD is under $600

SQL Compression – sp_estimate_data_compression_savings stored procedure is available only in the Enterprise, Developer, or Datacenter

I don’t get it. There’s this feature – called Compression… that is like FANTASTIC for SOME of the times when you absolutely need more space (and can’t get more disk). What I don’t understand is this- why can’t STANDARD edition … Continue reading

Posted in SQL Server | Tagged | Comments Off on SQL Compression – sp_estimate_data_compression_savings stored procedure is available only in the Enterprise, Developer, or Datacenter

I love Visual Basic

I swear, 10 years ago.. VB was incredibly popular.  Microsoft invented some new language.. but I refuse to use it primarily because of two things: a) Case Sensitivity – it’s just STUPID for languages to be case sensitive, sorry… b) … Continue reading

Posted in SQL Server, Visual Basic | Tagged | Comments Off on I love Visual Basic

batteries are going bluetooth

Tethercell magically turns AA batteries into Bluetooth devices Traditional batteries may never be the same again since Tetherboard displayed its working Tethercell prototype at CES 2013. It embeds Bluetooth into a traditional AA battery form. by Amanda Kooser January 8, … Continue reading

Posted in SQL Server | Tagged | Comments Off on batteries are going bluetooth

Internet Explorer usage up about 5 percent this year

Microsoft’s Internet Explorer (IE) turned things around in 2012, posting an annual usage share gain for the first time in the last eight years, according to data published earlier this week by a Web analytics company. Net Applications, which tracks … Continue reading

Posted in Internet Explorer, SQL Server | Tagged | Comments Off on Internet Explorer usage up about 5 percent this year

Microsoft Roadmap – includes Expression Web 6

Looks to me like Maybe Microsoft _IS_ going to continue releasing new versions of expression web Now if we could get them to include ADP in Office 2013 Sp1, then maybe I’d stop migrating all my clients to mySQL. http://news.cnet.com/8301-1001_3-57562126-92/microsoft-may-be-stepping-up-the-delivery-pace/ … Continue reading

Posted in SQL Server | Tagged | Comments Off on Microsoft Roadmap – includes Expression Web 6