|
|
|
|
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.
November 2010 - Posts
-
Microsoft's new data platform vision for BI is called BISM - Business Intelligence Semantic Model. While I focus primarily on manageability, availability and database engine features, I'd like to keep tabs on who can help you out with their input on the Read More...
|
-
Earlier, I documented the system objects that have changed in Denali . One that caught my eye was a slew of new columns made available through sys.databases, mostly to support a feature I also blogged about recently, contained databases . Consider the Read More...
|
-
I am not sure when it happened, but at some point, bit.ly marked all URLs to connect.microsoft.com as dangerous. So for example, I created this shortened link http://bit.ly/fKKQPT which just goes to http://connect.microsoft.com/sql/ . When you click on Read More...
|
-
I've seen a couple of reports where the SQL Sentry Plan Explorer installer fails to recognize .NET 4.0 on your system. In some cases this is because you really don't have the full .NET 4.0 installation - just the Client Profile or other components that Read More...
|
-
It's been a while since I hosted a true Connect pity party digest, trying to pimp your votes for the issues I think are worthwhile. And okay, some of these bugs haven't been filed in the Denali time frame - but those are still in Denali's version of SSMS. Read More...
|
-
While it's still only the CTP1 timeframe, getting a glimpse of the changes in system objects can start preparing you for what's coming - especially when there are potential breaking changes, as you'll see below. Sure, a few of these things can change Read More...
|
-
This afternoon, Adam Machanic ( blog | twitter ) reminded me how the current T-SQL debugger in Management Studio is ineffective. Sure, there are some enhancements coming in Denali (I mentioned them briefly yesterday ), but there are some real key elements Read More...
|
-
It's the day before American Thanksgiving, and Jason Strate ( blog | twitter ) has asked all of us to tell the SQL community what we're thankful for . While I seem to recall doing this before , I have gone through a lot of life changes in the past year, Read More...
|
-
In SQL Server Denali, Management Studio has been entirely migrated from its earlier incarnation. Previously SSMS had slight traces here and there that it was a distant cousin to Visual Studio; in this release, it is a full-fledged immediate family member. Read More...
|
-
Sadly, THROW is not mentioned on the Programmability Enhancements (Database Engine) topic of Denali's "What's New" section. So, unless you were at PASS or have been reading the various blogs from the keynotes and other Denali sessions, the presence of Read More...
|
-
[This is an overly verbose and self-centered entry into @MidnightDBA 's Un-SQL Friday .] I've been unintentionally building my current brand since 1996. This was the year I learned the wonders of desktop publishing (if you can call Corel Draw desktop Read More...
|
-
I guess the title should be, "You can't restore a SQL Server 2000 database on Denali." I had the occasion just today to recover some data from a backup I took way back in 2008 (!) for a colleague who was still on 2000 at that time (again, !). When I tried Read More...
|
-
On Monday, the SQL Server Release Services team released cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. The cumulative update for SP2 restores the fixes that were potentially undone by applying SP2 (or the SP2 CTP) after applying Read More...
|
-
A problem that has plagued SQL Server for a long time is that a database is not very portable. Sure, you can backup or detach a database and restore or attach it elsewhere, but when you do that, you are missing a lot of the pieces that make that database Read More...
|
-
There are posts elsewhere that go through the whole rigamarole (for example, this post from Don Gill , SQL Server's Group Content Publishing Manager). I just wanted to highlight the key bullet points: if you want to use Books Online locally, you will Read More...
|
-
It hasn't been 24 hours since I left behind a slew of new and old friends in Seattle, and I already feel - as someone else put it - that I've left summer camp for another long, cold winter. Okay, it's not going to be that bad - I'll soon be heading home Read More...
|
-
If you come across a SQL Server that is not running, it can be troublesome to determine what happened and when. You can run through the Windows event viewer, but this can be a real needle in a haystack problem on busy servers, especially if there are Read More...
|
-
SQL Server 2011 introduces a feature that Oracle professionals will certainly recognize: SEQUENCE. SEQUENCE allows you to define a central place where SQL Server will maintain a counter of values for you. The last-used value is stored in memory (ask about Read More...
|
-
Rick Heiges comes on stage and talks about the way the Board of Directors works. He sent off Lynda Rab, a director since 2007. He introduces the new Directors-at-Large: Douglas McDowell, Andy Warren, and Allen Kinsel. A PASS goal over the next 5 years Read More...
|
-
A very common request over the past, oh, 10 years, maybe more, has been better support for paging within T-SQL ( this Connect request dates back to 2005 ). Well, you will see some broader support for this within a year, give or take: the next version Read More...
|
-
It is the second day of keynotes at PASS, and we're gearing up for Quentin Clark's presentation. There are not as many kilts around as I would have expected, and I'm only noticing because this year I'm wearing one too . Actually, at the bloggers' table, Read More...
|
-
Just a quick note on how Denali creates #temp tables, as the behavior has changed slightly from previous versions, and could potentially break your existing scripts. You may be familiar with this syntax for checking for the existence of #temp tables: Read More...
|
-
After five tries, I've given up trying to install AdventureWorks on machines where Denali exists - even in cases where 2008 or 2008 R2 instances also exist, and when my goal is to install AdventureWorks on earlier releases. The installer crashes before Read More...
|
-
The next version of SQL Server (codenamed "Denali"), I suspect, will be released sometime toward the end of 2011; I will stress, however, that this is nothing more than a barely-educated guess. Please don't ask me the actual release date, because I don't Read More...
|
-
The keynote starts off with a tine Turner impersonator (or maybe it really was Tina?): Rushabh Mehta (donning the Tina wig) delivers the first segment of the keynote, telling the SQL Server community that we are "simply the best." He then introduces the Read More...
|
-
Kalen Delaney has called out to the altruist in each of us to help out a former student's mission trip to San Ramon, Nicaragua: Did You Know : SQL Geeks for Good I think it is a great idea, and I'm 100% on board. I also have commitments from the rest Read More...
|
-
Last February / March, I wrote several posts about an issue with MSXML6 on Windows XP which prevented the installation of SQL Server 2005, SQL Server 2008, and even service packs or cumulative updates in some cases: 2009-02-20 : The XP SP3 / MSXML6 SP2 Read More...
|
-
Yesterday, Microsoft released a Community Technology Preview (CTP) of SQL Server 2005 Service Pack 4. You can read about the release on the following blog post from SQL Release Services: http://blogs.msdn.com/b/sqlreleaseservices/...preview-available.aspx Read More...
|
-
Quentin Clark is on stage right now talking about high-level SQL Server stuff. I think I can take this time to explain how Connections is different from PASS (at least according to my first 15 minutes of experience here). Clearly, SQL Server is not the Read More...
|
-
Let's face it, there is a wide variety of skill out there. If you spend any time monitoring StackOverflow , MSDN forums , Ask SQL Server Central or twitter's #sqlhelp hash tag , you'll be very well aware that there are people out there barely managing Read More...
|
|
|
|
|
|