|
|
|
|
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.
October 2011 - Posts
-
For those of you using the SQL Server 2008 R2 version of Management Studio, and have applied Service Pack 1, you have probably noticed that clicking on a ShowPlan in grid results no longer shows the graphical plan, but rather opens a new window with the Read More...
|
-
A year ago today, I made quite easily the best decision of my career, and joined the folks at SQL Sentry . I explained a lot of this process in a blog post last year, " Moving on up... but not to the East Side ." I knew then several reasons I thought Read More...
|
-
On Friday, we published a new version of our free query plan analysis tool, SQL Sentry Plan Explorer . As noted in the change list , we've added a couple of important features. SQL Server 2012 support With a whole slew of changes to the showplan schema Read More...
|
-
At the PASS Summit, one of the most anticipated announcements was the release date, and marketing label, for SQL Server code-named "Denali" - the release date is "first half of 2012" (which probably means somewhere around June 25th), and the official Read More...
|
-
I've seen a few people stymied by this one recently, even though @PaulRandal wrote a mythbuster article about it last April. (If you don't want a spoiler alert, don't click through just yet.) They want to use a dynamic management function with parameters, Read More...
|
-
Christina Leo ( @christinaleo ) asked this question on twitter today: So, if I ever needed a POSH script, today is the day. Having to inventory all prod databases to find tables missing primary keys. I have a query that returns what I need, but I need Read More...
|
-
I'll make no bones about it: BETWEEN is evil. For one, the meaning of the word in English does not always match the meaning of the operator in T-SQL. In T-SQL, BETWEEN is an *inclusive* range - not everyone gets that. Sure, in casual conversation when Read More...
|
-
The first cumulative update for SQL Server 2008 SP3 is available. Build number: 10.00.5766 KB Article: KB #2617146 19 fixes Please note: this update is not for SQL Server 2008 R2 or for SQL Server 2008 with @@VERSION < 10.00.5500. Read More...
|
-
Today Microsoft has released Cumulative Updates for SQL Server 2008 R2. Cumulative Update #10 for SQL Server 2008 R2 RTM Build number: 10.50.1807 KB article: KB #2591746 13 fixes Cumulative Update #3 for SQL Server 2008 R2 Service Pack 1 Build number: Read More...
|
-
This is a rough morning. Got in at 2:00 AM, then had no water in my hotel this morning. I doubt I will ever voluntarily stay at the Seattle Hilton again. Still, I'm very much looking forward to this keynote - the illustrious Dr. David DeWitt is going Read More...
|
-
VP Finance, Bill Graziano comes on stage in a great kilt (but white socks!). No Tina Turner this year. 1,000 people from 53 countries watched the keynote yesterday. He recognizes Tim Radney (@tradney) and Jack Corbett (@unclebiguns) for their outstanding Read More...
|
-
At PASS I am giving a presentation on Denali SQL Server 2012 - What's New in Engine and Tools. In previous blog posts I've compiled a list of resources and, now that CTP3 is out, I thought I'd compile a much larger list that flows somewhat like my slide Read More...
|
-
Before the lights came down, I had already hit what will probably be the highlight of my morning: having a brief conversation with Dr. David DeWitt. Rushabh Mehta , President, PASS Rushabh Mehta comes on the stage and welcomes us to PASS Summit 2011. Read More...
|
-
Since installing Juneau, I've had various issues accomplishing even the simplest of tasks. I would get errors saying that the SqlCeManager could not be initialized or "object reference not set to an instance of an object." Depending on what I tried to Read More...
|
-
After reading the headline, you're probably quite excited - but sadly, no, Denali does not introduce the ability to govern I/O. But there are some cool additions here that you will be able to take advantage of. For now I'll just talk about these enhancements Read More...
|
-
Today Microsoft released Service Pack 3 for SQL Server 2008. The build number is 10.00.5500. The announcement blog post from SQL Server Release Services team: http://blogs.msdn.com/b/sqlreleaseservices/archive/2011/10/06/sql-server-2008-sp3-is-now-available.aspx Read More...
|
-
Today on the #sqlhelp hash tag on twitter, @sqlsponge asked, I am trying to loop through each active spid for dbcc inputbuffer. How can I print spid with inputbuffer output? My response was that he should use sp_whoIsActive , or at least query the DMVs/DMFs Read More...
|
-
I wanted to lay out my rough schedule at PASS Summit 2011 , so you'll know where to find me. And this is as much for me as it is for you - this is an easy reference point for me to remind myself where I'm supposed to be. :-) To avoid trying to influence Read More...
|
-
I often see questions about searching stored procedures, functions, etc. for specific keywords. Maybe it's an object reference they're looking for, or all of the places where they use built-in functions like GETDATE() (I once had to replace all of these Read More...
|
-
This month's T-SQL Tuesday is a week early due to the upcoming PASS Summit . It is being hosted by Stuart Ainsworth ( blog | @codegumbo ) and the topic is a general one: JOINs. I had an idea for a very brief post showing the typical join operations we Read More...
|
-
At SQLBits this week, a colleague of Chris Testa-O'Neill ( twitter ) asked me a question about Policy-Based Management. Specifically, he wanted to know how to determine, programmatically, which execution modes are applicable to each facet - or, inversely, Read More...
|
-
Last week I went to Liverpool, UK - birthplace of The Beatles - to speak and to represent SQL Sentry at SQL Bits 9 . I have to hand it to these guys - James, Tim, Allan, Simon, Darren, Neil, Dave, Chris, and countless others that my jet-lagged mind is Read More...
|
|
|
|
|
|