Browse by Tags

• agent
• autoshrink
• bad habits
• connect
• cumulative updates
• dbcc shrinkdatabase
• dbcc shrinkfile
• DBProj.com
• defaults
• DMVs
• indexed views
• Installation
• Management Studio Express
• MSXML6
• patches
• recovery model
• slipstream
• SQL Server 2008
• SQL Server 2008 R2
• SSMS
• SSMSE
• sysprocesses
• troubleshooting
• uninstall
• usability
• VMs
• VSDB
• VSDB2008GDR
• Windows 7
• Windows Server 2008 R2
• XP SP3

• Bad habits to kick : blind SQL Server installs

  In my last post in this series , I talked about some problems associated with relying on undocumented behaviors and commands. This time I wanted to touch on SQL Server configuration, and some of the items I see where more thought should be put into the...( Read More... Posted Thursday, February 11, 2010 8:48 AM from Aaron Bertrand | (Comments Off) Filed under: Installation, setup, defaults, bad habits

• Some tips on SSMS Express Edition setup

  I posted earlier that the Express Edition of Management Studio for SQL Server 2008 R2 (November CTP) is now available for download. During the first few pages in the setup wizard, I was certain that I had either downloaded the wrong version of the CTP,...( Read More... Posted Thursday, November 12, 2009 9:38 AM from Aaron Bertrand | (Comments Off) Filed under: setup, Management Studio Express, SQL Server 2008 R2, SSMSE

• Connect Digest : 2009-09-04

  I am heading to my home town for a week; we rented a cottage on Lake Nipissing , and are going to relax. No, really : no howling beagles, no computers, and no schedule. Sounds like a week of bliss to me. So, as you might imagine, there won't be a digest...( Read More... Posted Friday, September 04, 2009 9:30 PM from Aaron Bertrand | (Comments Off) Filed under: SSMS, connect, recovery model, agent, setup, slipstream, dbcc shrinkfile, autoshrink, dbcc shrinkdatabase

• Is SQL Server 2008 supported on Windows 7 / Windows Server 2008 R2?

  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... Posted Saturday, August 15, 2009 6:12 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, setup, Windows 7, SQL Server 2008 R2, Windows Server 2008 R2, VMs

• VSDB 2008 Version Numbers

  We frequently get asked how to identify the version a user is running with, so here is the list of Visual Studio Team System 2008 Database Edition releases. The information is retrieved using Help => About Microsoft Visual Studio inside the Visual...( Read More... Posted Thursday, July 30, 2009 8:37 AM from Home of the Data Dude | (Comments Off) Filed under: VSDB, setup, VSDB2008GDR, troubleshooting, DBProj.com

• Connect digest : 2009-07-04

  I know most readers are out polishing their grills, buying hamburger buns and preparing potato and macaroni salads. I am recovering from a pre-4th party, so here I am, groggy and online, finally not the host of Independence Day madness. :-) This week...( Read More... Posted Sunday, July 05, 2009 12:07 AM from Aaron Bertrand | (Comments Off) Filed under: connect, indexed views, DMVs, setup, usability, sysprocesses

• Connect digest : 2009-05-02 : please vote!

  Here are this week's set of Connect items that I wanted to bring to your attention to increase visibility (and, more importantly, vote count). Two are about SQL Server and two are about Connect itself. ==================== SQL Server ==================== Read More... Posted Sunday, May 03, 2009 3:36 AM from Aaron Bertrand | (Comments Off) Filed under: connect, DMVs, setup, usability

• DBPROJ vs. DBP

  Can the “real” database project please indentify itself? Life can be confusing and we did not help you making it much easier by having two types of Database Projects inside Visual Studio. For the longest time there has been a “Database Project” inside...( Read More... Posted Thursday, March 26, 2009 1:52 AM from Home of the Data Dude | (Comments Off) Filed under: setup, VSDB2008GDR

• One more post about MSXML6 SP2, XP SP3 and SQL Server : I've been duped!

  Microsoft delivered a KB article about this whole MSXML6 problem with XP SP3 (which I talked about recently here and here ), but it is NOT the KB article I was hoping for, nor anything resembling the article I had been promised. Instead of finally supplying Read More... Posted Saturday, March 21, 2009 2:17 AM from Aaron Bertrand | (Comments Off) Filed under: setup, MSXML6, XP SP3

• More info / good news : installing SQL Server on XP SP3 with MSXML6 SP2

  I have some good news about a problem I described a while ago, concerning attempts to install SQL Server on XP SP3 machines. The install would fail because XP SP3 places MSXML files under system protection, and so attempts by installation programs to Read More... Posted Tuesday, March 17, 2009 4:05 AM from Aaron Bertrand | (Comments Off) Filed under: setup, MSXML6, XP SP3

• Dealing with Confused Installations

  Is your Visual Studio Team System 2008 Database Edition GDR installation confused? Does you menu suffer from multiple instance disorder? Here is what you can do about it. Make sure that Visual Studio (devenv.exe) is closed. Start an elevated command...( Read More... Posted Monday, March 09, 2009 9:43 AM from Home of the Data Dude | (Comments Off) Filed under: setup, VSDB2008GDR

• The XP SP3 / MSXML6 SP2 / SQL Server debacle

  I see fingers pointing all over the place. The Windows team blames the SQL team for making setup packages that can't bypass when a newer version of a file already exists on the target system. The SQL team blames Windows for unceremoniously plopping the Read More... Posted Saturday, February 21, 2009 11:51 AM from Aaron Bertrand | (Comments Off) Filed under: setup, MSXML6, XP SP3

• More info about SQL Server 2008 Cumulative Update 1

  Bob Ward has posted a very thorough walk-through of the CU1 installation process. He talks about some of the things they've improved with the setup of patches, and gives a bit of a teasrer about about his next blog post, where he will discuss how they Read More... Posted Friday, September 26, 2008 11:57 PM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, setup, cumulative updates, patches

• Using System Restore for Cumulative Update Rollback?

  Just wanted to post a brief warning about expecting to be able to roll back a cumulative update or hotfix by reverting to a restore point. In short: don't do it! These two features are *NOT* designed to work together. There are various complications with Read More... Posted Friday, April 18, 2008 7:20 AM from Aaron Bertrand | (Comments Off) Filed under: uninstall, setup, cumulative updates