Monthly Archives: February 2014

SSAS Olap allows three partitions in Standard Edition?

I swear, this MUST be a change from SQL 2000 to 2005.  I just can’t fathom how this is true for so long, and I haven’t known about it. I would have been using partitions for every single cube I’ve … Continue reading

Posted in SQL Server | Tagged | 1 Comment

The LAST time I published VBA code for Access/SQL Server

The last time I published VBA code for MS Access (in 2001 I believe), I had nearly a quarter-million views of my code within about 5 years.  Unfortunately, FREEVBCODE.com no longer displays how many times people view the code.  http://www.freevbcode.com/ShowCode.asp?ID=4426 … Continue reading

Posted in SQL Server | Tagged | Comments Off on The LAST time I published VBA code for Access/SQL Server

Replace underscores in field names throughout SQL Server database

Use this script to generate the other scripts. Copy the results into a new query window, and execute. This method is called Psuedo-Dynamic SQL, and I learned about this from ‘SQL Server 7.0 Secrets’ about 15 years ago. select ‘EXEC … Continue reading

Posted in SQL Server | Tagged | Comments Off on Replace underscores in field names throughout SQL Server database

Replace Spaces in field names throughout SQL Server database

Use this script to generate the other scripts. Copy the results into a new query window, and execute. This method is called Psuedo-Dynamic SQL, and I learned about this from ‘SQL Server 7.0 Secrets’ about 15 years ago. select ‘EXEC … Continue reading

Posted in SQL Server | Tagged | Comments Off on Replace Spaces in field names throughout SQL Server database

Visual Basic.Net on the upswing with developers

Although programming languages such as Java, Objective-C, and JavaScript garner the lion’s share of attention these days, don’t count out Microsoft’s Visual Basic .Net (VB.Net), which has been on a mostly upward trend in the Tiobe language popularity index. For … Continue reading

Posted in SQL Server, Visual Basic | Tagged | 2 Comments

Mongo on Hadoop | Foursquare Engineering Blog

Mongo and hadoop are extremely popular. I have worked with mongo tools from codeplex.. but I havent gotten too far because it seems like hadoop is getting all the traction these days. Well.. now it looks like I can move … Continue reading

Posted in SQL Server | Tagged | Comments Off on Mongo on Hadoop | Foursquare Engineering Blog

When using HyperV

I finally diagnosed what is wrong with one of my development environments. I have been running Windows 2008 X86, for compatability with a bunch of old software.  I have had NOTHING but trouble, have not been able to remote desktop … Continue reading

Posted in HyperV, SQL Server | Tagged | Comments Off on When using HyperV

What is the BEST database solution for most mid-size enterprises today?

What is the BEST database solution for most mid-size enterprises today?

Posted in SQL Server | Tagged | Comments Off on What is the BEST database solution for most mid-size enterprises today?

The DBA, From Then To Now: The iDBA – Part 2 | ScaleBase | ScaleBase

Interesting article about the roles a database administrator may find themselves in. I’ve been all types of DBA over the years. http://www.scalebase.com/the-dba-from-then-to-now-part-2-the-adba/

Posted in SQL Server | Tagged | Comments Off on The DBA, From Then To Now: The iDBA – Part 2 | ScaleBase | ScaleBase