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: Windows Azure Security Review

    Current as of 08/01/2011 - Check the Resources listed below for more up-to-date information on this topic Background: Security for any computing platform involves three primary areas: Principals (users or programmatic access to an asset or other program) Securables (objects, data or programs that can...
  • Blog Post: PowerShell: Read Excel to Create Inserts

    I’m writing a series of articles on how to migrate “departmental” data into SQL Server . I also hold workshops on the entire process – from discovering that the data exists to the modeling process and then how to design the Extract, Transform and Load (ETL) process. Finally I write about (and teach)...
  • Blog Post: Using Perfmon with SQL Server – Part Two

    Yesterday I posted a header from a script that shows you some links for how to use “Logman”, a Windows command-line utility that can automate your collection of Windows Performance Monitor counters. Towards the bottom, you can see the logman command I use, and you can see that it points to a counter...
  • 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: SQL Server Management Studio Tips and Tricks

    Are you getting everything out of your SQL Server tools that you can? I’ve given you lots of tricks and tips here on my blog, but nothing beats an on-screen demonstration. My good friend and former teammate Bill Ramos did a session on SQL Server Management Studio at TechEd this year – and...
  • 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: Posting Comments to MSDN Blogs

    I had a ready respond to my post yesterday via e-mail. He asked why I didn't have "Anonymous" comments enabled on the blog, and told me that I would get a lot more responses if I did. And he is correct - I did have the settings on this blog where anyone could comment, and I got roughly 100...
  • 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: 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: Copy with Headers

    When you run a query in SQL Server Management Studio (SSMS), by default the results are sent to a grid. You can select the rows in this grid by clicking and dragging on the rows themselves and copy them to the clipboard with CTRL-C or using a right-click menu item. But there are a couple of other tricks...
  • 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: 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 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...
  • Blog Post: Sharing the Code

    I’ve worked in several multi-developer/multi-DBA shops in my day, and I’ve also taught a few DBA courses here and there. If you’re in the same situation, you know that it’s often important to be able to show your code to others. I have two tips for SQL Server Management Studio (SSMS) that have been helpful...
  • Blog Post: Why on earth are you working on that?

    Much of the development work at Microsoft is a mystery to the rest of the world. People ask me all the time why my team is working on X , when clearly what is needed is Y. Of course, everyone's definition of Y seems to be different, but that's another matter entirely! So I thought I would shed some...
  • Blog Post: Blogs, Blogs and More Blogs

    I subscribe to a lot of blogs - maybe too many! But I saw a thread the other day where someone was looking for more SQL Server Blogs. I've got a couple of links here that you might find useful: All SQL Server Blogs from Microsoft: http://msdn2.microsoft.com/en-us/sqlserver/bb671054.aspx SQL Server...
  • Blog Post: Out Out, Darn Database!

    Have you ever really needed to drop a database and you couldn’t? You’ve tried using the management tools, but you forgot you can’t drop a database when you’re in it, or you’re just fighting a process that just won’t seem to die? Fear not – the following script will do the job. Just replace DatabaseName...
  • Blog Post: Argh! Bring back Query Analyzer!

    Steve Jones, a friend of mine over at sqlservercentral.com, asked me a question the other day that is brought up quite a bit. In earlier versions of SQL Server, we had at least two management tools: Enterprise Manager (EM) and Query Analyzer (QA). EM did the "right-click" stuff and QA did the query stuff...
  • Blog Post: Table Diffs

    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 have a script or two in my toolbox just for that,...
  • Blog Post: How Do I Do That?

    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 for the "How do I" button and click it. From the...
Page 1 of 1 (21 items)