Browse by Tags

• access
• ADA
• agent
• analysis
• autoshrink
• Backup
• backups
• best practices
• binary
• books online
• catalog views
• cdc
• comments
• community
• computing
• connect
• cpu
• create database
• CTEs
• cumulative updates
• cursors
• CUs
• data
• data entry
• data files
• database
• database list
• date formats
• date handling
• dbcc shrinkdatabase
• dbcc shrinkfile
• deadlocks
• debugger
• defaults
• deferred name resolution
• deprecation
• Disaster Recovery
• disks
• dmv
• DMVs
• Documentation
• encryption
• enhancement
• enterprise manager
• error
• error handling
• error messages
• execution plan
• express edition
• F4
• F8
• field
• filegroups
• Filtered Indexes
• full-text
• functions
• grid results
• habits
• Hardware
• high availability
• hotfixes
• index maintenance
• indexes
• Integration
• intellisense
• Katmai
• kba
• large fonts
• Licensing
• locking
• log size
• login
• management
• Management Studio
• next version
• Open Table
• performance
• presentations
• property
• Screencast
• security
• shrinkfile
• Speech Recognition
• sql express
• SQL Saturday
• SQL Server
• SQL Server 2008
• SQL Server 2011
• ssas
• ssis
• ssma
• SSMSE
• ssrs
• statistics
• string
• surface
• synonyms
• sys.dm_exec_requests
• table
• T-SQL

• SQL Saturday #33 : slide deck, recap and shout-outs

  [Sorry I have been a little absent over the past couple of weeks. Returning from the Olympics just a little over a week ago meant some busy catch-up and a heavy lead-in to today's event.] Today I spoke at SQL Saturday #33 in Charlotte, NC. My presentation...( Read More... Posted Sunday, March 07, 2010 12:14 PM from Aaron Bertrand | (Comments Off) Filed under: community, SSMS, Management Studio, presentations, SQL Saturday

• Speaking at SQLSaturday #33 in Charlotte, NC : 2010-03-06

  I've been invited to speak at SQLSaturday #33 in Charlotte at the beginning of next month. There are 9 tracks and a total of 54 sessions, with a great variety of sessions and a superb speaker lineup. You can check out the schedule here: http://www.sqlsaturday.com/33/schedule.aspx...( Read More... Posted Sunday, February 21, 2010 3:48 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, SQLSaturday

• Connect Digest : 2010-02-16

  Simon Sabin has asked for better usability in the SQL Server Agent log viewer: specifically, to allow you to get to job / step properties directly from the history viewer. #531889 : Allow access to job details from the log file viewer to improve manageability...( Read More... Posted Tuesday, February 16, 2010 2:52 PM from Aaron Bertrand | (Comments Off) Filed under: SSMS, tempdb, CTEs, QUALIFY, ram, NOEXPAND

• Connect Digest : 2010-02-06

  Upgrading a database with read-only filegroups Earlier today, I complained that I should be able to upgrade a database with read-only filegroups. In this case an upgrade from, say, 2000 to 2005 is blocked because the engine can't update the system schema...( Read More... Posted Sunday, February 07, 2010 9:32 AM from Aaron Bertrand | (Comments Off) Filed under: Backup, SSMS, connect, restore, error messages, read-only filegroups, sorting

• Management Studio Tips & Tricks, version 1.0

  Today I presented "Management Studio Tips & Tricks" at SQL Saturday #34 in Waltham, MA. I had an audience of close to 100 (my biggest talk yet!), and unless they were stroking my ego, I achieved my primary goal for the session: to make sure that every...( Read More... Posted Sunday, January 31, 2010 8:00 AM from Aaron Bertrand | (Comments Off) Filed under: community, SSMS, Management Studio, presentations

• Connect Digest : 2010-01-22

  Give us easier to read execution plans Michelle Ufford ( @SQLFool ) recently asked for help pinpointing the most expensive node(s) in a complicated execution plan. Mladen Prajdic ( @MladenPrajdic ) has a useful workaround; he coded up a quick query to...( Read More... Posted Saturday, January 23, 2010 5:47 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, execution plan, connect, metadata, error handling, plan cache, UDFs, functions

• Connect Digest : 2010-01-11

  Control over procedure cache We are still waiting for more control over procedure cache. Adam Machanic wrote up this blog post highlighting a Connect item which he opened in 2007. It is currently closed as "won't fix" but it's been shown time and time...( Read More... Posted Tuesday, January 12, 2010 8:01 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, connect, Policy-Based Management, PBM, books online, usability, Filtered Indexes, UI, procedure cache

• Quick poll : what is your favorite Management Studio tip or trick?

  I am putting together a presentation on SSMS Tips & Tricks, which I will debut at SQL Saturday #34 . I already have a pretty full slide deck, but I am not the be-all and end-all of SSMS, so in the interest of distributing this information as widely...( Read More... Posted Tuesday, January 05, 2010 10:01 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, tips, Management Studio, tricks

• November CTP of SQL Server 2008 R2 : Download now

  For those of you that have been wanting to try out SQL Server 2008 R2, you can download the November CTP of Express here (posted yesterday) and the full version of the November CTP here . This is version 10.50.1352.12. The full version is an evaluation...( Read More... Posted Thursday, November 12, 2009 8:44 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, Management Studio, express edition, SQL Server 2008 R2, SSMSE

• Connect digest : 2009-10-25

  Here is your weekly helping of Connect goodness. I added two items from the Connect connection, and an item from the Visual Studio connection. ================================================= #500228 : Default Data Location Not Being Written To Registry...( Read More... Posted Sunday, October 25, 2009 10:17 PM from Aaron Bertrand | (Comments Off) Filed under: SSMS, connect, shrinkfile, visual studio 2010, data files

• Bad habits to kick : using the visual designers

  In my last post in this series , I talked about abusing triggers. This time I thought I would focus a bit on using the visual designers in SSMS. Table Designer My biggest problem with the Table Designer : many changes you make can force SQL Server to...( Read More... Posted Thursday, October 15, 2009 7:08 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, best practices, habits, visual designers

• Connect Digest : 2009-10-02

  Welcome to October! This week I have five SQL Server items to point out to you, and two Connect-specific issues. /*------------------------------------------------------*/ SQL Server /*------------------------------------------------------*/ #331220 :...( Read More... Posted Saturday, October 03, 2009 1:56 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, indexes, backups, connect, Management Studio, filegroups

• Connect Digest : 2009-09-18

  It sounds funny, but I'm running out of things to say in this intro. I wonder if I should introduce the list the way David Letterman is introduced differently on every episode of his late night TV show? Anyway, one of these items was suggested to me,...( Read More... Posted Saturday, September 19, 2009 12:46 AM from Aaron Bertrand | (Comments Off) Filed under: Licensing, SSMS, connect, deadlocks, F8, SELECT INTO, comments, F4, deprecation

• 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

• Connect digest : 2009-08-29

  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 throug more tests,...( Read More... Posted Sunday, August 30, 2009 4:36 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, connect, DMVs, sys.dm_exec_requests