Learning any technology is easy when we have good documentation and sample database to play along with. When I have to learn any new technology, my first action is to install the trial software and look for sample database next. Once I get sample database, I try to find a video tutorial about the technology and continue to learn onwards. Let’s see PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples here.
SQL SERVER – Weekly Series – Memory Lane – #018
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…
Read More
SQL SERVER – Beginning SQL 2012 – Basics of CONVERT and FORMAT Function – Abstract from Joes 2 Pros Volume 5
This chapter is abstract from the Beginning SQL 2012 – Joes 2 Pros Volume 5. You can get the Five part SQL Server 2012 Joes 2 Pros Combo Kit for complete reference. Book On Amazon | Book On Flipkart OPENXML has been around longer than the XML data type in SQL Server.…
Read MoreSQL SERVER – Beginning SQL 2012 – Aggregation Functions – Abstract from Joes 2 Pros Volume 2
This chapter is abstract from the Beginning SQL 2012 – Joes 2 Pros Volume 2. You can get the Five part SQL Server 2012 Joes 2 Pros Combo Kit for complete reference. Book On Amazon | Book On Flipkart All supporting files are available with a free download from the…
Read MoreSQL SERVER – Cumulative Update Released in February 2013 for SQL Server Editions
I keep eyes on cumulative updates. I keep a watch that which one released and what they are impacting. If you are facing issues with SQL Server – Comulative Updates may have a solution for you. I suggest to install CU on Development Server first and later roll out the…
Read MoreSQL SERVER – Weekly Series – Memory Lane – #017
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…
Read MoreSQL SERVER – T-SQL Script to Keep CPU Busy
Never run this on your production server – you can just lose your job and can damage your organization. Now I am done with the disclaimer here is the subject I would like to discuss. How to keep your CPU busy? Well, actually there should not be any need of…
Read More