Magenic Technologies Community Blog

Last week I mentioned Brent was announcing a new solution to SQL Server training today. Well here it is!  Head over to Brent’s post which will fully explain it.  It’s currently a soft launch which will be fully launched at SQL PASS in about 3 weeks.  Quest was gracious enough to donate their KnowledgeXpert content (a previous paid ...

Just in case you are not reading Brent Ozar’s blog (why aren’t you?) you wouldn’t have heard that come Monday he’s going to be making an announcement on a solution to SQL Server Training.  He’s outlined the issue Database Professionals have with getting quality information as well as showed who he’s working with to solve the issue here and no ...

Well it might be a little biased, but it does make direct links to the Oracle web site in regards to pricing.  There is lots of great information with additional sources like InformationWeek, ComputerWorld,  Gartner, etc.  If you want to find out how the two database giants match up check out this site here.  There is also a whitepaper in regards ...

Just saw a post by Jason here about http://www.sqlservervideos.com/.  I immediately went to check it out and wasn't disappointed.  I especially liked the fact that they had 400 level videos.  So what are you waiting for?  Go check it out!

Share this post : Transparent data encryption (TDE) performs real-time I/O encryption and decryption of the data and log files. Encryption of the database file is performed at the page level. The pages in an encrypted database are encrypted before they are written to disk and decrypted when read into memory. TDE provides the ability to ...

The SQL Server 2008 product went RTM yesterday afternoon and everyone is extremely excited for the new release and the blogging really picked up all day yesterday.  The new August SQL Server 2008 Feature Pack has now been released here which has links to download the data mining add-ins for Office 2007 and the latest Upgrade Advisor.  The new ...

Well it looks like SQL 2008 RTM'd at TechEd in South Africa.  Take a look at Aaron Bertrand's post or sqlmag

The new Gauge data region is most often used to provide a high-level summary of your data by highlighting key performance indicator (KPI) values. The gauge uses a pointer to show a single value. You can add a range to highlight a subset of values on your scale and control the size and positioning of the scale on the gauge to create different ...

SQL Server 2008 includes Dimension Designer Enhancements, new attribute relationships designer, and additional Best Practice Alerts:) The Dimension Wizard within BIDS 2008 (VS 2008) for Analysis Service Projects has been simplified and introduces a new attribute relationship designer. The wizard has reduced the number of screens and includes an ...

Check out the details here - http://blogs.msdn.com/gerryo/archive/2008/07/01/sql-server-beta-exams-extended-open-invitation.aspx Only good through the end of July, so try and register before it is completely booked. SQL Server 2008 DBA 71-432 and SQL Server 2008 BI 71-448.