Browse by Tags

Tagged Content List
  • Blog Post: Windows Azure End to End Examples

    I’m fascinated by the way people learn. I’m told there are several methods people use to understand new information, from reading to watching, from experiencing to exploring. Personally, I use multiple methods of learning when I encounter a new topic, usually starting with reading a bit about the concepts...
  • Blog Post: Computer books are dead. Well, some of them, anyway.

    I read a lot. I mean a LOT. It seems that computer professionals have much in common with medical professionals – we have to read in order to stay on top of our game. For me, this used to mean web sites, magazines, and other print medium, and of course lots of books. I’ve even written several computer...
  • Blog Post: Challenge: Learn One New Thing Today

    Most of us know that there's a lot to learn. I'm teaching a class this morning, and even on the subject where I'm the "expert" (that word always makes me nervous!) I still have a lot to learn. To learn, sometimes I take a class, read a book, or carve out a large chunk of time so that I can fully grasp...
  • Blog Post: Can’t Travel for Training? No Problem

    Right now it’s tough to get businesses to loosen the purse a little and get you out to some training. But you have features in the product that you’re not even able to use because you haven’t been trained. What’s a Data Professional to do? Why, go to free or low cost training over the web, of course...
  • 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: Visio Video (killed the radio star)

    I teach a class at the University of Washington, and in that class I have the students create a few Entity Relationship Diagrams (ERDs). I’m still looking for a decent tool to do that, since the only ones I know that do a good job are WAY too expensive. Visio is about the best I’ve found for them, and...
  • Blog Post: Go To Find Combo

    A friend of mine – Bill Ramos – showed me a little-used feature in Management Studio that I’ve been using ever since. It’s a combo box that works in the Query Window and it allows you to find text quickly in a script, but it also has a hidden benefit. To put this box on your toolbar, right-click anywhere...
  • Blog Post: The SQL Server 2008 Developer Training Kit

    Want some free training? I think Microsoft does an amazing job of getting training out for free. If you need a boost for your career, are just starting out, or need to re-tool after a layoff, or if you just want to become more familiar with the latest version, you can access these resources to learn...
  • Blog Post: Moving Tables Between Filegroups

    I got an e-mail in response to the Best Practices blogs on Filegroups. I've gotten other e-mails similar to this one, so I thought I would answer (or try to) all of them here. Here's the e-mail:   " I recently started a new DBA job.   When I started the company had recently purchased new...
  • Blog Post: Versioning the Database

    If you write apps that hit a database that you own, then you probably want version control on the database itself. I always script out the initial database, and version that script. I also script the changes, and version those, and then script the entire DB again and version that as well. That allows...
  • Blog Post: SQL Server Management Studio Tutorial

    I've had a lot of folks ask me about inlcuding a new feature for SQL Server Management Studio, only to point out that we have it already. That's understandable - SSMS has a lot of features, and if you're not using it all day, it's impossible to learn them all. But if you have a few minutes, take the...
  • Blog Post: More SQL Server Videos

    I was sent this link by a reader: http://www.sqlservervideos.com/series/ Not sure about the content, but I thought I would pass these along. If you review them, let us know what you think.
  • Blog Post: Free SQL Server Videos

    Microsoft is now including video content along with Books Online for SQL Server. Check them out here: http://msdn.microsoft.com/en-us/library/cc952928.aspx
  • Blog Post: Quick Ramp-Up on SQL Server 2008 for the DBA

    Need to find out what's new in SQL Server 2008 for the DBA, even before you install it? We have a free on-line lab you can register for that will get you started quickly: http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032358030&EventCategory=3&culture=en-US&CountryCode...
  • Blog Post: SQL Server 2008 Improvements Practicals – Y Mucho Mas

    I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for midnight - "Eine kleine Nachtmusik ": I've shown you lots of new features that save you precious time at the office. So now you get to go home – on time for a change...
  • Blog Post: SQL Server 2008 Improvements Practicals – The Data Collector and the Management data Warehouse

    I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 4:00pm - "Need for Speed": Now it’s time to tune my systems. Before I can tune them, I need to track them. Sure, I can set up a bunch of Profiler Traces, queries...
  • Blog Post: SQL Server 2008 Improvements Practicals – New Wizards and Dialogs

    I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 1:00pm - "New and Shiny": There are a few features in SQL Server that can be complex to implement. That’s often due to the nature of the feature...
  • Blog Post: SQL Server 2008 Improvements Practicals – Object Search

    I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 1:00pm - "New and Shiny": Sometimes it can be, well, a bit challenging to locate the objects you want to work on in SQL Server Management Studio (SSMS). You have...
  • Blog Post: Free "Basic Training" for SQL Server

    I answer a lot of questions about SQL Server - on forums, in newsgroups, in presentations and so on - and many are "101", or basic questions. That's great! I don't have a problem with that at all - I enjoy helping someone that is new to SQL Server learn the ropes. Over the years I've collected some really...
  • Blog Post: SQL Server 2008 Improvements Practicals - T-SQL Debugger

    I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 1:00pm - "New and Shiny": With the stored procedure I created ready to go, I need to test it - in case it's long or complicated, or even spins off to another procedure...
  • Blog Post: SQL Server 2008 Improvements Practicals - Intellisense

    I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 1:00pm - "New and Shiny": In my DBA day I finally get a break to do something I really enjoy - new development. I decide I need to create a new stored procedure,...
  • Blog Post: SQL Server 2008 Improvements Practicals - Resource Governor

    I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 10:00am - "Panic Button": While I'm examining the state of performance on my system, I discover that one set of queries is monopolizing most of the CPU and Memory...
  • Blog Post: SQL Server 2008 Improvements Practicals - PowerShell - Activity Monitor

    I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 10:00am - "Panic Button": All of us get called from our cubes to come take a look at a performance problem. You've probably got a box of scripts somewhere that you...
  • Blog Post: SQL Server 2008 Improvements Practicals - PowerShell - Run a "Panic" Backup

    I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 10:00am - "Panic Button": Now that I've found there are a few databases that haven't been backed up, I want to run a "Panic Backup" on all of them. Here's a PowerShell...
  • Blog Post: SQL Injection Attacks

    You might have read recently that there have been ongoing SQL injection attacks against vulnerable web applications occurring over the last few months. These attacks have received recurring attention in the press as they pop up in various geographies around the world. These attacks do not leverage any...
Page 1 of 2 (38 items) 12