I noticed Brent Ozar worked on a SQL book titled: Professional SQL Server 2008 Internals and Troubleshooting. This book is now available and I decided to ask Brent some questions about this book. This interview was conducted by email, enjoy. Denis: Is the book geared towards a beginner/intermediate level user or do you have to be an advanced user to really utilize the information in this book? I like to think that the reader is somebody who’s been managing SQL Servers for a year or two and is getting frustrated.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
Sometimes you want to quickly see the percentage of log spaced that each database is using on your server. In SQL Server 2005 and 2008 you can use the sys.dm_os_performance_counters dynamic management view to find out this information. The query below will list all database and the percentage of log spaced used. The cntr_value column will have the percent of the log file that is being used and instance_name will be the database name.
This is just a quick post letting you know that Microsoft has announced the SQL Server Migration Assistant for MySQL This tool is available for download now. Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure. SSMA 2008 for MySQL v1.0 CTP1 provides an assessment of migration efforts as well as automates schema and data migration.
I was tagged by onpnt in his 2010 Goals post. So here is my short list of goals that I would like to accomplish in 2010 Upgrade our servers to SQL Server 2008 This is an easy one since it already happened this week. We went to new machines from machines that were 6 years old. I now have 16 times more RAM than previously. Instead of 4 HT CPUs I now have 8 CPUs and finally I am no longer on SQL Server 2000 at all.
Review This is an extension of part 1 and the feasibility of mirroring a SQL Server 2005 Enterprise database to SQL Server 2008 Enterprise database in order to have a limited downtime upgrade path. In this part, we’re going to work through the actual test case and setup of the process. I recommend this type of upgrade only if downtime is extremely limited in your installation. Remember to always backup your databases and all associated sql agent jobs, scripts, logins and objects before going through with a complete upgrade of SQL Server.
Over the weekend I started writing my documentation and lab work for a few database servers that I will be upgrading to SQL Server 2008 in the first quarter of 2010. Upgrading SQL Server has benefits in having multiple ways to go about how you plan and execute the process. I can’t praise the SQL Server team enough for making the task of upgrading much less stressful than other database servers I have worked on.
The biggest problem you have as a webdeveloper is that you have to check everything in like a thousand different browsers. But the biggest few will do. Internet explorer is one of the most important ones since it is still the biggest and most used. And it comes in three flavors. The good (IE8), the reasonable (IE7) and your worst nightmare (IE6). Win 7 makes it real easy to run all three on the same machine.
I was tagged by onpnt in his Goals for 2010 post. One of my resolutions goals of this year is to read more books. Right now I am in the middle of reading Daemon by Daniel Suarez. According to his bio Daniel Suarez is an independent systems consultant to Fortune 1000 companies. He has designed and developed enterprise software for the defense, finance, and entertainment industries. An avid gamer and technologist.
Another DBA’s look at goals for 2010 Goals are an important part of any DBA. The first few days of the New Year there have been dozens of blogs going out from many of the people I follow along with about their own goals for the New Year. Tim Ford (blog / twitter) I think had the best blog out of all of them. He went over the difference between resolutions and goals and how he does not do resolutions.
According to a post on the SQL Azure Team Blog you can upgrade your CTP accounts to a paid commercial subscription starting today, below is an excerpt from that post Starting today you will be able to upgrade your Community Technology Preview (CTP) account to a paid commercial subscriptions. If you upgrade your CTP accounts during the month of January, 2010, all Windows Azure platform usage incurred during this month will be at no charge.