November 22nd, 2011 
Microsoft has release SQL Server 2012 RC0. http://www.microsoft.com/download/en/details.aspx?id=28145 You can also get the RC0 release of PowerPivot for Excel 2010. http://www.microsoft.com/download/en/details.aspx?id=28150
Posts Tagged ‘SQLServer’
Table Size History
When maintaining a data warehouse, it is import understand the size and disk requirements of your tables over time. My current client has asked that I generate a report showing table disk usage over time, so that we can predict table growth. I was looking around and found the procedure sp_spaceused. This returns the row [...]
Posted in SQL 
Tags: Dimesion, Disk Usage, Fact, sp_spaceused, SQL, SQL 2008, SQLServer, SQLServerPedia Syndication, SSIS, SSRS, T-SQL, Table 
No Comments »Table Auditing with XML
When working with meta data tables it can be very useful to track when people make changes to the data. How do you track any change against any number of columns for any table? I have implemented a fairly simple solution that uses triggers and stores all changes as XML into one change log table. [...]
Presenting @ Atlanta Microsoft BI user group
I will be presenting at the next Atlanta Microsoft BI user group. Monday, July 25th, 2011. http://atlantabi.sqlpass.org/ Topic: SSIS Logging and Auditing Framework Level: Beginer / Intermediate Meeting Place Matrix Resources 115 Perimeter Center Place Suite 250 (South Terraces Building) Atlanta, GA 30346 Overview: Proper logging in your SSIS packages can help save hours in [...]
SQL Custom Keyboard Shortcuts
Keyboard shortcuts play an important role to increase the productivity, in any development environment . There are tons of shortcuts that are beneficial in SQL Server Management Studio. SSMS 2005/2008 also allow you to easily add your own keyboard shortcuts. The two shortcuts that I always create are the SELECT TOP 1000 * FROM and [...]
Posted in General, SQL, SQLServerPedia Syndication Tags: Management Studio, SQL 2008, SQLServer, SQLServerPedia Syndication 2 Comments »Trusted Foreign Keys
Hey friends! Long time, no see. I know, you’re wondering where I’ve been. Lately, I’ve had the luxury of taking some time to work on Microsoft certifications. I just got through 70-448, Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Now, I’m working on 70-433, Microsoft SQL Server 2008, Database Development. I’ll admit… I [...]
Posted in Database Development, Performance, T-SQL Tags: Database Development, Foreign Key, SQLServer, T-SQL Comments Off