Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Walkthroughs

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

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

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

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

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
Posted by Buck Woody | 2 Comments
Filed under: , ,

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

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

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

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=U

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

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

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

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

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

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
More Posts Next page »
 
Page view tracker