Browse by Tags

Tagged Content List
  • Blog Post: When you’re asking for help, make sure you explain what you’re trying to accomplish

    At some time, all of us need technical help with something. Whenever you do, make sure you try and frame the question not necessarily in terms of what you want to know, but what you're trying to do. Spending time on thinking through your questions will help you get better answers, and people will appreciate...
  • Blog Post: Make it Easy for People to Help You

    OK, there are probably a dozen or more of these kinds of posts, but I’ll dive in anyway. From time to time, people send me e-mails or comments on this blog asking for help. Sometimes it’s on the topic at hand, and other times the topic just jogs their memory about something else. Often I’m happy to help...
  • Blog Post: 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 in fact I still do), but today I'll be attending...
  • Blog Post: 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: we help each other a lot. Since the beginning of the...
  • Blog Post: 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 say than I do. There are 85,000 of us at Microsoft...
  • Blog Post: 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 to type almost any math formula. I've included statistical...
  • 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: 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 Server group. The answer is "No", sort of. So...
  • 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: 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. What I've done is to create two "aliases...
  • Blog Post: 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 increases in SQL Server 2008 – especially cool things...
  • Blog Post: 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. What you type on the client is then sent...
  • 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: 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 three instances of the system – one called...
  • Blog Post: 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 of Transact-SQL statements that live on your...
  • Blog Post: 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 what are basically a task list based on things...
Page 1 of 1 (16 items)