Browse by Tags

• Administration
• Agent
• DBA
• Design
• Developer
• Development
• Management
• Microsoft
• Performance Tuning
• Planning
• PowerShell
• Process
• Scripts
• SQL Server
• SQL Server 2008
• SQL Server Management Studio
• Tips
• T-SQL
• Tutorials
• Virtualization
• Web

• Multi-Monitor Support in SQl Server Management Studio 2008

  Did you notice that there are a lot of "little" things that were improved in SQL Server 2008? One of those was done by one of my favorite developers and deals with multi-monitor support. In previous versions of SQL Server Management Studio you could open Read More... Posted Thursday, February 04, 2010 7:33 AM by BuckWoody | 0 Comments Filed under: SQL Server 2008, SQL Server Management Studio, SSMS

• Hovering Over the Titles in Activity Monitor

  I show this little-known feature in just about every perf tuning class I give, and it’s often a surprise to most of the folks there. It’s not earth-shattering or anything, but I do find it helpful. In SQL Server Management Studio 2008, start the new Activity Read More... Posted Thursday, January 21, 2010 7:16 AM by BuckWoody | 0 Comments Filed under: Performance Tuning, SQL Server 2008, SQL Server Management Studio, SSMS, Tips

• Tools and Processes for “Fitting it all in”

  Most data professionals I’ve met work in two modes: we plan for our day, and we react to the situations around us. I’m staring at my list of things that I need to do today right now, which is my planned work. Of course, I have no idea how much of that Read More... Posted Monday, January 18, 2010 7:42 AM by BuckWoody | 0 Comments Filed under: Agent, DBA, Design, Developer, Development, Management, Microsoft, Planning, PowerShell, Process, Scripts, SQL Server, SQL Server Management Studio, SSMS, Tips, Web

• Wizards are evil – wait, no they aren’t!

  SQL Server contains many “Wizards. Wizards are simply programs that collect information based on user choices. The Wizard’s screens explain each step and the choices on that screen. Based on those answers collected from the user, the Wizard performs some Read More... Posted Monday, December 14, 2009 8:55 AM by BuckWoody | 4 Comments Filed under: Administration, DBA, Developer, Process, SQL Server, SQL Server Management Studio, SSMS

• Code that Writes Code

  I have scripts that re-create my databases for testing and development purposes. But sometimes I want to take the data from a set of tables and move it as well – I could use SSIS, or a SELECT INTO statement, but what if I want to “re-set” the data to Read More... Posted Wednesday, November 25, 2009 7:01 AM by BuckWoody | 5 Comments Filed under: DBA, Design, Developer, Development, Scripts, SQL Server, SQL Server Management Studio, SSMS, Tips, T-SQL, Tutorials, Virtualization, Web

• Changing the Primary Key After You Have Data

  Yesterday I blogged about changing a Primary Key (PK) during the design phase, and before you have data in the database. Even then, it’s not trivial to change the data type or column(s) that make(s) up the PK. When you have data in that Primary Key and/or Read More... Posted Tuesday, November 24, 2009 6:25 AM by BuckWoody | 0 Comments Filed under: DBA, Design, Developer, Development, Microsoft, SQL Server, SSMS, Tips