Posted by Mohammed Mawla on Mar 20, 2012
TEMPDB, is one of SQL server hot-debated topics; there’s always something to say about its sizing, file placement or datafiles count in Multi-core instances.
WHY TEMPDB is controversial ?
This is simply because TEMPDB is a global resource that’s heavily used and very critical asset in a busy instance; this makes any advice against TEMPDB fall in the “It depends” category.
Any generalizations ?
As a starting point, some advice is usually thrown around for tempdb:
- Place Tempdb on a fast array , preferably On RAID10.
- Better if Tempdb is on an array not shared by other files if possible.
- Create more than one datafile if instance uses more than one CPU/Core.
- In case of multiple datafiles, better if all files have equal size.
More info can be found under Optimizing tempdb Performance
Read the rest of this entry . . .
Posted by Fahd Mirza on Mar 16, 2012
In this Log Buffer Edition, March madness with method continues with plethora of blog posts from across different database technologies. Enjoy this Log Buffer #263.
Read the rest of this entry . . .
Posted by Fahd Mirza on Mar 9, 2012
This week is packed with conference news, birthdays, tutorials, awards, and much more. From Pythian proud recipient of HIO Employer Excellence Award to the health checks of SQL Server, and from hints in stored outlines to the birthday of Paul Vallee, this Log Buffer Edition has it all in Log Buffer #262.
Read the rest of this entry . . .
Posted by goswami on Mar 8, 2012
As we all are aware SQL Server 2012 virtual launch has arrived. Earlier I discussed what’s new in SQL Server 2012 setup, MS has released the SQL Server 2012 training kit and made it available for us to download. In the recent past, I have blogged about a free eBook for SQL Server 2012 written by Ross Mistry ( Blog | Twitter ) and Stacia Misner ( Blog | Twitter) .
You will see lots of new and insightful information on new and enhanced features introduced in SQL Server 2012, this includes:
- AlwaysOn
- Automating AlwaysOn management
- New backup and restore capabilities
- ColumnStore index
- Semantic Search
- User-defined server roles
- Data quality service
- StreamInsight for SQL Server 2012
- Big data analytics and Hadoop
- T-SQL Enhancements
- SQL Server Data Tools (SSDT)
- SQL Azure
Sounds interesting?
Get yourself register for the event, want to see full agenda for the event, click here.
– Hemantgiri S. Goswami
Posted by Edwin Sarmiento on Mar 7, 2012
High Availability Features to Watch Out For in SQL Server 2012
While there have been several discussions about the next version of SQL Server within the technical communities, most customers are still thinking about whether or not to upgrade. I can’t blame them, upgrading to the latest version of any software or hardware is no small feat and the cost of doing so is always a consideration to the overall IT expenditures of an organization. However, business requirements change overtime and with those changes come the challenges of addressing them. This is one of my arguments when discussing upgrade and migration projects with customers. High availability and disaster recovery is just one of those business requirements. With data becoming more and more critical to the business operations, it’s no surprise that for every IT project, high availability and disaster recovery is always on the plate. And this is where I have my eyes (and hands) on the next release of SQL Server. I’ve been playing around with SQL Server 2012, codenamed “Denali,” since the CTP days and am very happy with some of the features that they have introduced to address high availability and disaster recovery requirements. For me, these are more than enough reasons to consider upgrading to SQL Server 2012.
Read the rest of this entry . . .
Posted by Michelle Gutzait on Mar 2, 2012
The one million dollar question we get asked by clients…
“Why should we upgrade to the next version of SQL Server?”
The process of upgrading SQL Server is usually time consuming, costs money and requires availability of human resources. If you don’t see the immediate need…
Why bother?! Before deciding on upgrading, you should be aware of the new features and make sure you will really benefit by the upgrade. From our experience at Pythian with dozens of clients and hundreds of environments, what could be worth upgrading to SQL Server 2012? Read the rest of this entry . . .
Posted by Fahd Mirza on Mar 2, 2012
With new blog posts covering newest technologies, discovered bugs and anomalies, this Log Buffer Edition is presented for you. In this Log Buffer #261, you would savor posts from Oracle, SQLServer and MySQL arena. Enjoy
Read the rest of this entry . . .
Posted by goswami on Mar 1, 2012
Microsoft has released one more free eBook, this time it is on SQL Server 2012. This is the second draft of this book. SQL Server MVP Ross Mistry and Stacia Misner has covered Administration and BI part, there are 10 chapters in total divided in two parts, they are:
PART I Database Administration (by Ross Mistry)
CHAPTER 1 Denali Editions and Enhancements
CHAPTER 2 High Availability and Disaster Recovery Enhancements
CHAPTER 3 Scalability and Performance
CHAPTER 4 Security Enhancements
CHAPTER 5 Beyond Relational
PART II Business Intelligence Development (by Stacia Misner)
CHAPTER 6 Integration Services
CHAPTER 7 Data Quality Services
CHAPTER 8 Master Data Services
CHAPTER 9 Analysis Services and PowerPivot
CHAPTER 10 Reporting Services Read the rest of this entry . . .
Posted by Fahd Mirza on Feb 24, 2012
Nothing pleases the technology bloggers more than the moment when somebody thank them for a helpful blog entry. That is one of the many awesome advantages of the technology blogs. In database arena, the developers, DBAs and evangelists are sharing their tips and tricks through their blogs and this Log Buffer Edition is projecting them all in Log Buffer #260.
Read the rest of this entry . . .
