Browse by Tags

Tagged Content List
  • Blog Post: Should I learn Cloud Computing Next?

    My previous role at Microsoft was in the SQL Server team. I spent quite a bit of time there, and had some really great experiences. I was able to travel and speak as well as doing my “regular” job in the programming team, so I got to meet a lot of people. I also teach at the University of Washington...
  • Blog Post: 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 a point in time? In other words, load it with some...
  • Blog Post: Win7 – Install SQL Server Native or go Virtual PC?

    I have Windows 7 on my laptop, and I also teach, demo and use SQL Server 2005 and SQL server 2008. Should I install this “native” on my outside operating system or use the Virtual PC (VPC) software that comes with Windows 7? Well, there are arguments for each. It’s far simpler to start up SQL Server...
  • Blog Post: The Mythical Silver Bullet

    Have you ever sat in a meeting where you either got the distinct impression, or were told directly that you should just use product X or Feature Y to solve a problem?  Sure, we have a lot of features in SQL Server, but I don't think any of them is a complete solution by themselves. Let's take a...
  • Blog Post: Consolidation Strategies: Profiling Your Systems

    Many shops are considering consolidating their SQL Server Instances onto fewer boxes, as I've blogged about before. There are lots of ways to think about consolidation, from placing more databases on one Instance (Database Stacking), putting multiple Instances on one server (Instance Stacking), and using...
  • Blog Post: SQL Server Chargeback?

    Whenever economic situations change, the IT department has to adapt. The situation in many shops is that IT is a recurring cost, carried by the entire business. What that means is that your IT department is asked to service the entire organization, no matter how much it grows or shrinks. But that...
  • Blog Post: Consolidation Strategies

    Can you run SQL Server on a Virtual Machine? Sure. Should you? Well..that's another story. You most certainly can run SQL Server in a virtualized environment - but in most of the cases that I deal with, simply having more Instances of SQL Server installed suits the purpose better. While virtualization...
Page 1 of 1 (7 items)