THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server » DBA   (RSS)
Showing page 1 of 5 (50 total posts)
  • Updated File & Wait Statistics Procedures

              For many years I have been using a set of stored procedures to capture and report on both the file and wait statistics inside of SQL Server and I just recently did some minor modifications that I want others to be aware of. Since many of you have received copies of the past revisions ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 13, 2014
  • How Does the Cloud Change a Database Administrator’s Job?

    I recently posted a blog entry on how cloud computing would change the Systems Architect’s role in an organization. In a way, the Systems Architect has the easiest transition to a new way of using computing technologies. In fact, that’s actually part of the job description. I mentioned that a Systems Architect has three primary ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 29, 2013
  • A SQL Saturday in Cambridge – Buck Woody’s Ragtime Database Workshop

    The SQL Server community is really engaged. They are an active bunch on Twitter, Facebook and LinkedIn, they help each other on forums, they attend conferences. But that isn’t enough interaction – the community started a grass-roots effort to hold local conferences on a Saturday. Free conferences. Odds are there’s one near ...
    Posted to Buck Woody (Weblog) by BuckWoody on July 30, 2012
  • The Data Scientist

    A new term - well, perhaps not that new - has come up and I’m actually very excited about it. The term is Data Scientist, and since it’s new, it’s fairly undefined. I’ll explain what I think it means, and why I’m excited about it. In general, I’ve found the term deals at its most basic with analyzing data. Of course, we all do that, and the term ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 15, 2011
  • Big Data and the Cloud - More Hype or a Real Workload?

    Last week Microsoft announced several new offerings for “Big Data” - and since I’m a stickler for definitions, I wanted to make sure I understood what that really means. What is “Big Data”? What size hard drive is that? After all, my laptop has 1TB of storage - is my laptop “Big Data”? There are actually a few definitions for this term, most ...
    Posted to Buck Woody (Weblog) by BuckWoody on October 18, 2011
  • Back up a single table in SQL Server

    SQL Server doesn’t have an easy way to take a table backup, so I often use the bcp (Bulk Copy Program) to accomplish the same goal. I’ve mentioned this before, and someone told me when they tried it they couldn’t restore the table – ah the dangers of telling people half the information! I should have mentioned that you need to have a “format file” ...
    Posted to Buck Woody (Weblog) by BuckWoody on June 3, 2010
  • More Tables or More Databases?

    I got an e-mail from someone that has an interesting situation. He has 15,000 customers, and he asks if he should have a database for their data per customer. Without a LOT more data it’s impossible to say, of course, but there are some general concepts to keep in mind. Whenever you’re segmenting data, it’s all about boundary choices. You have ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 19, 2010
  • Use Those Schemas, People!

    Database Schemas are just containers – they aren’t users or anything else – think of a sub-directory on the hard drive. In early versions of SQL Server we “hid” schemas, placing all objects under “dbo”, which gave the erroneous perception that Schemas are users. In SQL Server 2005, we “un-hid” or re-introduced schemas within the database. Users ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 18, 2010
  • Do you have a data roadmap?

    I often visit companies where they asked me “What is SQL Server’s Roadmap?” What they mean is that they want to know where Microsoft is going with our database products. I explain that we’re expanding not only the capacities in SQL Server but the capabilities – we’re trying to make an “information platform”, rather than just a data store. But ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 13, 2010
  • SQL Server for the Oracle DBA Links

    I do a presentation (and a class) called ''SQL Server for the Oracle DBA''. It's a non-marketing overview that gives you the basics of working with SQL Server if you're already familiar wtih how Oracle works. This class and these links DO NOT help you with ''Why should I use Oracle/SQL Server instead of Oracle/SQL Server'' - I'll assume you're ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 28, 2010
1 2 3 4 5 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement