Monthly Archives: January 2012

Microsoft Siri Competitor from 2003 – Microsoft is lightyears and decades ahead of their competitors.

This is an amazing article. Yes, I fully agree– I think that Microsoft is lightyears and decades ahead of their competitors. What Microsoft offers in Access Data Projects- it is the same thing that they offered in 1999, thirteen years ago- … Continue reading

Posted in Access, SQL Server | Tagged | Comments Off on Microsoft Siri Competitor from 2003 – Microsoft is lightyears and decades ahead of their competitors.

SqlClr rocks

http://msdn.microsoft.com/en-us/library/cc655659(v=sql.90).aspx Extending SQL Server Reporting Services with SQL CLR Table-Valued Functions         2 out of 2 rated this helpful Rate this topic             SQL Server 2005 Ryan Ackley Microsoft Corporation March 2007 Applies to:    Microsoft SQL Server 2005 Reporting … Continue reading

Posted in SQL Server | Tagged | Comments Off on SqlClr rocks

Developer's Guide to Collections in Microsoft .NET

I need to get this book on collections, I think that they are under utulized http://www.i-programmer.info/bookreviews/78-visual-studio-a-general-net/3585-developers-guide-to-collections-in-microsoft-net-.html

Posted in SQL Server | Tagged | Comments Off on Developer's Guide to Collections in Microsoft .NET

Cairo / WinFS was supposed to look like this.

SQL fileTable is probably my favorite feature in SQL Server. Cairo / WinFS was supposed to look like this. This will make it SO easy to manage my MP3s!!! http://www.geniiius.com/blog/sql-server-2012-filetable-part-1/ SQL Server 2012 FileTable – Part 1 januar 3, 2012 | … Continue reading

Posted in SQL Server | Tagged | Comments Off on Cairo / WinFS was supposed to look like this.

ConvertToBase – great TSQL UDF function

I’ve had to convert from base 10 to base 2 to base 2 to base 10 hundreds of times in my life.. Finally I was googling for a better answer, and I found this 🙂 From http://dpatrickcaldwell.blogspot.com/2009/05/converting-decimal-to-hexadecimal-with.html CREATE FUNCTION ConvertToBase … Continue reading

Posted in SQL Server | Tagged | Comments Off on ConvertToBase – great TSQL UDF function

Is ADP Deprecated?

I hear a lot of MVPs claim that ADP is deprecated.. It’s silly that there’s a religous war between SQL Server architects and developers who continue to be strangled by Jet. So I thought that it was time to explain… … Continue reading

Posted in SQL Server | Tagged | Comments Off on Is ADP Deprecated?

Sql server 2012 my favorite feature

Filetable is probably my favorite feature in sql 2012. http://www.geniiius.com/blog/sql-server-2012-filetable-part-1/

Posted in SQL Server | Tagged | Comments Off on Sql server 2012 my favorite feature

Q: My SQL Server database shows a very large size, but the sum size of all the tables is nowhere near the size of the database. What should I do?

How to backup to a null device.. interesting syntax I didn’t know that windows supported this notation nul: http://www.windowsitpro.com/article/sql-server/sql-server-database-shows-large-size-sum-size-tables-size-database-141833

Posted in SQL Server | Tagged | Comments Off on Q: My SQL Server database shows a very large size, but the sum size of all the tables is nowhere near the size of the database. What should I do?

SQL / CLR is the best thing since sliced bread

http://sqlserverperformance.idera.com/tsql-optimization/comparing-simple-efficiencies-tsql-udf-sqclr-udf-splitting-strings/ Comparing Simple Efficiencies: T-SQL UDF vs SQCLR UDF for Splitting Strings Donabel Santos (twitter (@sqlbelle) | blog) – February 21, 2011 Recap of T-SQL vs SQLCLR (pseudo) Debate There have been numerous posts about benefits of using T-SQL vs … Continue reading

Posted in SQL Server | Tagged | Comments Off on SQL / CLR is the best thing since sliced bread

Oracles Downward Spiral

I’m SO glad I chose to base my career on SQL Server.  It’s a LOT more affordable than Oracle. I ran into this quote, had to share: In Oracle’s core competency, databases, Microsoft’s SQL Server scored significantly higher satisfaction ratings … Continue reading

Posted in SQL Server | Tagged | Comments Off on Oracles Downward Spiral