|
|
|
|
Aaron is a senior consultant for SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.
August 2009 - Posts
-
A little over a week ago, I performed some initial investigation into what has changed between SQL Server 2008 and 2008 R2 . Steve Cooney quickly asked, "Where is all the schema for UCP and DAC?" It was a great question, and my initial response was that, Read More...
|
-
I had a pretty busy week, and did not come up with much. I know, I'm lame. I have a series of Connect items I'd like to file regarding AutoShrink, DBCC SHRINKDATABASE, and recovery models. And I also plan to put Unicode compression through more tests, Read More...
|
-
They call it their new, massively scalable data warehousing solution; they say it can load 1TB per hour and support data warehouses in the petabyte range, all on commodity hardware. Bold claims, for sure, and I bet you're thinking, "I'll believe it when Read More...
|
-
When SQL Server 2008 R2 was first released, I wrote a quick blog post discussing the additional space savings gained by Unicode compression . In one of the follow-up comments, Adam Machanic was quick to suggest that compression can bring significant CPU Read More...
|
-
We know what new features are available in SQL Server 2008 R2: data-tier applications (still with that unfortunate and poorly-chosen acronym, DAC), control point explorer, dashboard viewpoints, report builder 3.0, Unicode compression, StreamInsight, yada Read More...
|
-
I rounded up a few interesting items this week. Does "1/10/1900" mean January 10th, or October 1st? This item demonstrates that Microsoft isn't all that concerned about publishing sample code that uses ambiguous or troublesome formats for date literals. Read More...
|
-
Earlier this week, a hotfix was released that, among other thigns, addressed an issue where, if you restored a 2000 database from 2005 SSMS, it did not go well. The KB article ( KB #972687 ) says that only certain versions of SSMS are affected, and proceeds Read More...
|
-
Sleeping at the wheel again, I missed some big updates for SQL Server 2005 this past Monday. Cumulative Update #5 for SP3 brings you up to 9.00.4230 (the previous update was 9.00.4226). http://support.microsoft.com/kb/972511 Cumulative Update #15 for Read More...
|
-
I have a very short window to get this post out, so I apologize if I don't elaborate my justification for pointing out a lot of these issues to you. Check the feedback items out at your leisure, and if you agree or disagree with the assessment, vote! Read More...
|
-
Yes it is! See this blog post from Peter Saddow: http://blogs.msdn.com/petersad/archive/2009/08/11/sql-server-on-windows-7.aspx First, if you have User Access Control in full swing, UAC will generate the following prompt to make sure you're okay with Read More...
|
-
Fellow MVP Simon Sabin blogged today about one of the few engine enhancements we'll be seeing in SQL Server 2008 R2 : Unicode compression. You can read more about the topic in Books Online , but basically what is going to happen is that NCHAR / NVARCHAR Read More...
|
-
I was expecting more changes, but as Denis Gobo already pointed out, there is not a single new DMV in SQL Server 2008 R2. There have been some column additions, however, as well as a couple that have increased in size. You might think that I determined Read More...
|
-
Sorry, I've been trying to keep this to a regular Saturday installment, but it was a beautiful weekend here and I just couldn't pass up on non-computer-related activities. I have a short list of Connect items to draw your attention to this week. =============================================== Read More...
|
-
UPDATE - 2009-08-07 9:39 PM EDT - the SQL Server Release Services team has published a blog post that reflects largely what I've said below. However, many questions are still unanswered. For example, they say that the fix for SP2 is not available yet, Read More...
|
-
The other day, I showed you my approach (but not necessarily the best approach for everyone) to splitting a comma-separated list of integers . Some of the functions I threw up there catered to integers specifically, whereas I am sure many of you are splitting Read More...
|
-
It is a common problem... you need to pass multiple values into a stored procedure and, as a result, update multiple rows. Let's pretend we have a table of students: CREATE DATABASE School ; GO USE School ; GO CREATE TABLE dbo.Students ( StudentID INT Read More...
|
-
I had a fairly busy week, so I did not get to spend a lot of time rounding up old, nearly-forgotten Connect items. But I do believe I came up with at least one or two that you will want to vote or comment on... ======================================== Read More...
|
|
|
|
|
|