Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Questions

Should I stay or Should I Go?

I'm writing this post on a bus headed towards the Seattle Convention Center, where the technical folks in the field meet once a year to hear from the product teams about all the new features coming in the future. I used to present at this conference (and

Help Me Help You

Before I start this post, let me say that it is not pointed at any one person - if you've asked me for help recently, this isn't about you! The programming and administration computer disciplines are fairly unique, in my mind, in one interesting way:

You have a Voice at Microsoft

When I was on the product team, I was asked by a few of you from time to time to make a change in SQL Server. Now that I'm in the field, I get asked to "chat with the development team" to make one change or another. But you actually have more

Mandelbrots and SQL Server

I was watching Nova last night and they talked to Benoit Mandelbrot, the man who codified some of the math that bears his name. This math branch deals with "rough" or repeating surfaces. You probably already know that Transact-SQL can be used
Posted by Buck Woody | 2 Comments
Filed under: ,

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

Is Multi-Server Query Parallelized? Yes and no...

I was asked about the post I did on the multi-server query feature we put in SQL Server Management Studio 2008. Because it seems to render on the screen in a sequential fashion, the user thought the queries were issued one at a time from the Registered

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

Simulating Multiple Connections

As I was giving a demo of the new multi-query capabilities the other day, I was asked how I had four Instances installed on one small, underpowered laptop. In fact, I don't - I have one instance of SQL Server 2005 and one Instance of SQL Server 2008 installed.

Why you should upgrade to SQL Server 2008

One of the readers recently asked about the blog post I made regarding the performance of replication being so improved in SQL Server 2008. We don’t have a formal study posted on that particular result yet, but we do have others that talk about speed

Where should the tools be?

I've got another question for you - where should the tools be? Let me explain. Most of the time when you connect to SQL Server, you open SQL Server Management Studio (SSMS) on a client machine and then type in the name of a server somewhere on the network.

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

Transport Systems

I’ve worked on a couple of SAP systems, both the “R” flavors and the BW product. Although I had my learning challenges with them, there was one construct there I really liked. It was the transport mechanism. Basically what this involved was setting up

Templates

I’ve run into quite a few DBA’s who aren’t using the Templates feature we provide with SQL Server Management Studio. If you spend a little time becoming familiar with them, I think you’ll find they are a powerful tool. Templates are really just a series

Task-based or object-based?

Some platform management system designs focus on Task-Based events. You'll see this in programs like the MySQL Admin tool, especially the version for the Mac. I installed this to manage the MySQL system on my Mac at home, and the top row of icons contain
 
Page view tracker