[EN] New Book on the shelf. From James Bond.

Few days ago I got a present. The new book about Cloud Architecture. This book has been written by Bond. James Bond. But of course James Bond know everything about SPECTRE but have no experience with Cloud. The real James Bond is a Chief Technology Officer at Hewlett-Packard (Las Vegas, Nevada, USA) with a lot of experience with The Cloud. I found very good opinions about this book: 4,8/5 stars at O’Reilly and 4,7/5 stars at Amazon. As we can read on last page:

Despite the buzz surrounding the cloud computing, only a small percentage of organizations have actually deployed this new style of IT—so far. If you’re planning your long-term cloud strategy, this practical book provides insider knowledge and actionable real-world lessons regarding planning, design, operations, security, and application transformation. This book teaches business and technology managers how to transition their organization’s traditional IT to cloud computing. Rather than yet another book trying to sell or convince readers on the benefits of clouds, this book provides guidance, lessons learned, and best practices on how to design, deploy, operate, and secure an enterprise cloud based on real-world experience.

Author James Bond provides useful guidance and best-practice checklists based on his field experience with real customers and cloud providers. You’ll view cloud services from the perspective of a consumer and as an owner/operator of an enterprise private or hybrid cloud, and learn valuable lessons from successful and less-than-successful organization use-case scenarios. This is the information every CIO needs in order to make the business and technical decisions to finally execute on their journey to cloud computing.

  • Get updated trends and definitions in cloud computing, deployment models, and for building or buying cloud services
  • Discover challenges in cloud operations and management not foreseen by early adopters
  • Use real-world lessons to plan and build an enterprise private or hybrid cloud
  • Learn how to assess, port, and migrate legacy applications to the cloud
  • Identify security threats and vulnerabilities unique to the cloud
  • Employ a cloud management system for your enterprise (private or multi-provider hybrid) cloud ecosystem
  • Understand the challenges for becoming an IT service broker leveraging the power of the cloud

And of course few words about author – James Bond:

James Bond is a Chief Technologist for the HPCloud business unit.  He provides cloudbusiness strategy and technical guidance, solution architecture, and transitionplanning to Fortune 100 and Government customers in North America.  Bond’s role is to educate customers andindustry on the transition from legacy enterprise IT to private, hybrid andbrokering cloud environments.  He is acloud keynote presenter at numerous customer and industry conferences acrossthe U.S.

With more than 25 years experience in public andprivate sectors, Bond was an early pioneer in the design and deployment of Infrastructure,Software, and Platform as a Service offerings—long before the term cloudcomputing was coined.  His background indata centers, LAN/WAN systems design, software development, and ISP/ASPmanagement were precursors to his current focus on cloud computing.  Bond is well known on the industry and withinHP as an expert resource of real-world cloud design and deployment experiencehaving successfully deployed cloud environments for some of the largest U.S.Government customers.

Before joining HP, Bond was a Vice Presidentwith Apptix, a leading commercial Software as a Service provider, where hearchitected and managed some of the largest SaaS deployments in the UnitedStates.  Past industry experienceincludes Chief Technology Officer for IceWEB, Vice President of SteelCloud, andpositions with Electronic Data Systems, Computer Sciences Corporation, andComputer Data Systems.

Bond holds a Bachelor’s degree in ComputerScience from the University of Maryland. He authors numerous technical white papers and is finalizing his firstbook—on cloud computing.  He is avolunteer Emergency Medical Technician (EMT) in his spare time and currentlyresides in Las Vegas, Nevada.

I will start to read this book soon, and I hope to give five start after reading.

And here are links for:

  • O’Reilly bookstore page
  • Amazon bookstore page
  • Author’s LinkedIn profile

Post Scriptum:

Only one bad feeling about this book. And it is for O’Reilly: this book – even brand new doesn’t smell. And because I love Smells of The New Book – I’m really dissapointed…

[EN] How to DO IT? Using MAX MEMORY option in SQL Server {updated}

It’s nothing new, generally. You can find a lot of great posts abour MAX MEMORY option for SQL Server Environment from many experts, for example from my MVP’s Family Members: Glenn Berry {BLOG|TWITTER} and Jorge Segarra {BLOG|TWITTER}. You can albo find a lot of information about it on MSDN, TechNet and other media, such as books. But many times, many sql server administrators forgotting about this option. Option which should be a part of Your personal DBA’s list called: MUST DO IT FIRST.

I’m writing this post, because it could help You, and because it’s very helpfull option for me. OK not only helpfull, this option saved my speakers live few times. I have bad luck futh my standard laptop, The Old one have been damaged few times, The New One is not ready yet. And – with Murphy’s Law – as always crashed happened day before my session. Fortunatelly I’ve second one. Acer Aspire One. It’s small netbook, quadcore, 64-bits OS, and 320 GB HNN (unfortunatelly not SSD) and UNFORTUNATELLY with 2GB RAM only. Based on Glenn Berry’s post (hope he will not kill me of borrowing it) look for  this table:

image

Pict.1 | Max Memory Settings for 64-bit SQL Server 2008 Instances

imageI’ve five instances of SQL Server: 2005 Express, 2008 Express and Enterprise, 2008 R2 Express and 2012 Enterprise. I used they on my sessions and learning and sometimes training.  Memory on my laptop is a big problem. Especially that by default SQL Server Instance sizing memory to: 2147483647 MB (it’s about 2TB). But when my instances starting run, starting consuming memory too. As much as possible. Time of execution the query on this netbook is note Grand Goal, but execution is. So, I must limited each of my instances, for working on the same time and not kill my OS, and of course the instances.

What I can do? Setting Up MAX MEMORY option (LINK for MSDN). But remember about minimum limitations on right side. So what is the right way? We can use SQL Server Management Studio (SSMS) in two ways: via graphical user interface and clicking or via T-SQL options. For this case I preffer the second way. Lets do it quick:

Captura_SP_MAXMEMORY_01

Pict.2 | These are full T-SQL statement for configuration MX MEMORY option, but we can go step by step.

Captura_SP_MAXMEMORY_02

Pict. 3 | In phase one – first we must enabling advanced option (switching from “0” to “1”)

Captura_SP_MAXMEMORY_03

Pict. 4 | In phase two – secondly we must send RECONFIGURE statement to database engineCaptura_SP_MAXMEMORY_04

Pict. 5 | In phase two – first we shoould choos right value of memory (in MB). We received confirmation in Message Area.

Captura_SP_MAXMEMORY_05

Pict. 6 | In phase two – second part is the same, we must use RECONFIGURE option.

Captura_SP_MAXMEMORY_06

Pict.7 | Finally we can use it together with only one execution

As You see my MAX MEMORY option has been setting up to 196 MB for each instances. It’s not much, but all instances working pararelly, OS is working, internet and PowerPoint too. I’m ready for small show. There is no official information on MSDN for SQL Server 2012 MAX MEMORY, but they are for SQL Server 2005 and SQL Server 2008:

image

If You need more informationa about it, just go to very interesting, detailed posts:

 

UPDATE {January 2014}: if You preffer clickology than t-sql, You can use server properties like below:

Capturaupd1

Pict.8 | Right-Click on SQL Server and Properties.

Capturaupd2

Pict.9 | On first properties page we can look how much physical memory we have: here 5119 MB (available for SQL Server)

Capturaupd3

Pict.10 | On second page (if we never changed MAXMEMORY option) we will see default memoty: MIN: 128 MB and MAX 2147483647 MB

Capturaupd4

Pict.11 | Last step is changing memory for appropriate value: in this case MIN 256 MB and MAX 4096 MB