• Carpe Datum

    What's really important?

    • 2 Comments
    First it was "cyber-". Everything had to start with "cyber". Then it was "e-", and then "i-". Now it seems to be "My". While buzzwords are great marketing tools, what is really important? First, it matters that things work. I'm on the Management Platform...
  • Carpe Datum

    The Biggest Problem We Face

    • 1 Comments
    Last night I gave a presentation to the Pacific Northwest SQL User Group. I mentioned that we often think our biggest problems are lack of time, too much work, people we have to deal with or technical issues. But all of us get done only what we can, we...
  • Carpe Datum

    Table Diffs

    • 2 Comments
    I think one of the most asked and answered questions in SQL (not just SQL Server, but SQL engines in general) is "How do I find/get the data from table A to table B?" In fact, you've probably seen multiple variations of the question and the answer. I...
  • Carpe Datum

    Maintenance Plan MetaData

    • 1 Comments
    I was recently asked about which tables are involved in a maintenance plan in SQL Server 2005.The primary tables are: msdb.dbo.sysmaintplan_subplans msdb.dbo.sysmaintplan_log msdb.dbo.sysmaintplan_logdetail msdb.dbo.sysdbmaintplans msdb.dbo.sysdbmaintplan_jobs...
  • Carpe Datum

    Secure by design

    • 4 Comments
    Whenever you're developing a new application that hits SQL Server, make sure you design in security from the outset. In the new releae of the Community Tehcnal Preview (CTP) for SQL Server 2008, you'll notice that there are several new improvements in...
  • Carpe Datum

    Script of the day - Finding Foreign Objects in master

    • 1 Comments
    Have you ever forgot to set the database when you ran a query, filling the master system database with your user objects? And I'll bet you used the dbo user too, didn't you? Doh! Here's a quick way to ferret those out so you can clean them up: ...
  • Carpe Datum

    Ch..ch..ch..changes!

    • 0 Comments
    I've been with Microsoft for about a year now. It's an interesting place to work, and I've enjoyed it here. I started with the SQL Server "User Education" team, and I've written documentation for Books Online, whitepapers and other technical outlets....
  • Carpe Datum

    Copying the Favorites from Books Online

    • 2 Comments
    I get asked a lot if it is possible to copy the Favorites from Books Online to another Favorites folder on another computer. The answer is yes! The Help Favorites are stored by default in: C:\Documents and Settings\username\Application Data\Microsoft...
  • Carpe Datum

    Slicing Books Online

    • 1 Comments
    With all of the content in Books Online arranged into a single table-of-contents, it’s sometimes difficult to find information that “spans” topics. For instance, if you want to find out about general security topics, you’ll find they are spread across...
  • Carpe Datum

    Books Online Innovations

    • 1 Comments
    It's just documentation - right? Well, there's actually a bit more to it than that. Of course, we update the content of Books Online all the time, as I've mentioned before. But we've also innovated in the way that we present and deliver the content. I...
  • Carpe Datum

    The May 2007 Books Online Update is Available

    • 1 Comments
    You can get the latest crunchy SQL Server documentation goodness here: http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
  • Carpe Datum

    Translating Books Online References to Web Pages

    • 2 Comments
    Books Online is available in both a "full" client installation or on the web. In the URL bar of the client you'll see a reference for each topic. If you want to send that topic to a friend who might not have Books Online install, there's a way to translate...
  • Carpe Datum

    Microsoft Update Now Updates Books Online

    • 1 Comments
    I've mentioned before that we update Books Online several times a year, and we're moving to do it even more often. I m very happy to announce that SQL Server 2005 Books Online Doc Refresh 4 is now part of Microsoft Update. This means that customers who...
  • Carpe Datum

    Gee, there don't appear to be as many error codes in 2K5 BOL as there are in 2K BOL...

    • 0 Comments
    You’re right – we don’t document as many error codes in 2K5 as we did in 2K. Some don’t apply; others aren’t encountered as often. In fact, we didn’t document all of the 2K errors either, we just had more of them because there was so much time between...
  • Carpe Datum

    The Grand Unified Theory

    • 0 Comments
    I've mentioned before that Books Online isn't just a client install, but the same content is also available on the web. In fact, it's available in two places on the web: SQL Server 2005 BOL on TechNet: http://technet.microsoft.com/en-us/library/ms130214...
  • Carpe Datum

    Stupid BOL Tricks - #1

    • 2 Comments
    I just found this out today. If you have Books Online installed on your system, did you know you can look at the local content in a regular old web browser? At the top of a Books Online topic, you'll see a URL bar. The URL starts with ms-help:// , which...
  • Carpe Datum

    How Do I Do That?

    • 1 Comments
    Did you know you can quickly locate all kinds of topics that walk you step-by-step through a lot of the common tasks in SQL Server, from backups to creating a report in Reporting Services? In the local client (DExplorer) tool, just look on the top bar...
  • Carpe Datum

    Great new Learning Resource

    • 3 Comments
    We have a lot of content out there - a LOT. But how do you find it all? We have a great new resource that one of our team members put together. It’s a customized Windows Live search, that limits results to Books Online. Check this out, and make sure you...
  • Carpe Datum

    Is Books Online Online?

    • 1 Comments
    "Books Online" has become an industry standard for documentation, with a really long history. Before it became so large, it used to actually be a set of books, and you could read them electronically, hence the name. But Books Online is no longer published...
  • Carpe Datum

    Using the Search Feature

    • 0 Comments
    SQL Server Books Online is an absolutely huge resource. With over 58,000 pages that change several times a year, it's like getting all of the books at one time that you are ever going to use from Grade-School through College. Not only that, it is used...
  • Carpe Datum

    SQL Server 2005 Books Online is Updated!

    • 1 Comments
    As I mentioned in my last blog post , SQL Server is updated several times a year - our team calls this a "web refresh". Isn't it great that we come up with new words to describe things? Anyway, SQL Server Service Pack 2 just released , and Books Online...
  • Carpe Datum

    SQL Server Books Online

    • 15 Comments
    Most of us have stacks of books on our shelves about SQL Server. But you also have an amazing resource that you get for free with SQL Server, or even on the web: Books Online. Some of you might not know how SQL Server Books Online is put together and...
Page 40 of 40 (997 items) «3637383940