You can use row_number() to sort and number the results. This can be useful for creating a view that shows a custom sorting order. But first, here are some different ways you can work with this function.
So you downloaded the AdventureWorks2012 database, and want to know what to do with the 190MB MDF file. You cannot just go to New Database or Attach Database in the GUI. Instead you need to run a query to create the database using the MDF file.
If you are new to certifications and are also new to taking Microsoft exams, and you want to get into Database Administration and already know a bit, well this exam is the perfect way to get the ball rolling. It doesn’t count for your MCSA but it builds confidence.
Reading the book alone will get boring. You have to apply and test your knowledge to make it stick. Today I bought some Practice Test questions from MeasureUp – one for the 98-364 Exam, and one for the 70-461 Exam. They each come with approximately 120 questions and an exam simulator.
How boring is it to learn a page full of data types inside out just to get tested on it? That’s like a chemist learning the periodic table inside out. You can always look these things up when the time comes but if you want to be a real database professional you should knows these things blindfolded.
What’s the difference between the Decimal and Numeric data types?
If you are studying for the 70-461 exam like myself, reading the book (Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012) from Microsoft is undoubtedly the way to go. So far I have waddled through the first 150 pages, some parts requiring more time to absorb than others. I’ve been stuck on chapter 4 for quite some time as the concepts start to build on each other slightly, but nevertheless moving forward.
Here we are going to learn a little more about how queries are written and processed. Please note that SQL queries should be written in a certain order of operation (known as “keyed-in order”), and this order is not the same as the order the query is processed in.
SQL was based on the Relational Model, but is not necessarily confined by all the rules of the relational model. Here are some of the key points I recorded while reading up on this.
SQL evolved from two branches of Mathematics – Set Theory and Predicate Logic. Here are some key points to understand.
Now that SharePoint 2013 is out it’s a bit harder to find the link to download SharePoint 2010. Some of the links on Microsoft’s site seem to take you right back to the 2013 page.
Usually the trial version and full installation packages are the same, and you get the option to skip this step and use the trial. However, in SharePoint 2010 you get a rather bold screen that forces you to enter a key. If you are wandering, yes there is a Trial license key that you can use. In fact, there are about 4 to choose from.
If you are downloading the prerequisites for SharePoint 2010 manually, you will most likely pull your hair out (and scream a few times) trying to find the right version of Microsoft SQL Server 2008 Analysis Services ADOMD.NET. You have probably already tried several different versions and still cannot pass the check. What’s going on?!!
Here are the links to download the SharePoint 2010 prerequisites manually. This is useful if you don’t have an Internet connection during the SharePoint setup process and need the standalone installers.
Here is a basic overview of what a Windows Server 2008 Service Pack 1 upgrade to Service Pack 2 should look like. Download the ISO, mount it, and run the setup. – http://www.microsoft.com/en-us/download/details.aspx?id=5104.