sql server

Welcome to the 'sql server' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'sql server'.

Latest blogosphere posts tagged “sql server”

• The most-watched IT questions this week: Nov. 24, 2009

  
  IT answers — Authority: 458
  New Question Created by Michael Morisy
  7 hours ago

• You don’t think of them as human… You don’t think of them at all

  
  SQLServerPedia — Authority: 147
  OK maybe I’m feeling really good today… maybe it’s because it’s @Peschkaj ’s birthday… maybe it’s because I needed to find a way to work some Tina Turner into my next blog post…or maybe it’s because I successfully took care of both kids last night for the first time while wifey started some ...
  8 hours ago

• Taking advantage of Table Variables NOT being transactional - application logging files within a transaction and keeping whats happened

  
  Tony Rogerson's ramblings on SQL Server — Authority: 400
  Table Variables are not Transactional, that is to say BEGIN TRAN....ROLLBACK has no effect on them; we can use that to our advantage. Have you ever been in the situation where you use a log file within your application to log progress, unfortunetly because...( read more )
  9 hours ago

• Dew Drop – November 24, 2009

  
  Alvin Ashcraft's Morning Dew — Authority: 127
    Jump to: .NET / Visual Studio | Web Development | Design / Methodology / Testing | Silverlight / WPF | Podcasts / Screencasts / Videos | Community / Events | Database | SharePoint | Miscellaneous | More Link Collections | Book of the Day   .NET / Visual Studio Source Code for ...
  11 hours ago

• hardware requirement for sql 2005.

  
  IT answers — Authority: 458
  New Question Created by Infrastucture
  11 hours ago

• 
  eReleases Press Release Headlines — Authority: 538
  
  14 hours ago

• SQL Server Schema Automatic Revision History using DDL Triggers and SVN

  
  SQLServerPedia — Authority: 147
  SQL 2005 introduced DDL Triggers, where you could catch events on your DDL statements in SQL, and hopefully most DBA’s are catching them, at least to a table and have some kind of report on who is adding, changing and deleting what objects. What I wanted to do was capture that, but also keep and automatic running ...
  19 hours ago

• SQL Server Schema Automatic Revision History using DDL Triggers and SVN

  
  stevienova.com — Authority: 100
  SQL 2005 introduced DDL Triggers, where you could catch events on your DDL statements in SQL, and hopefully most DBA’s are catching them, at least to a table and have some kind of report on who is adding, changing and deleting what objects. What I wanted to do was capture that, but also keep and automatic running ...
  19 hours ago

• SQL Server Schema Automatic Revision History using DDL Triggers and SVN

  
  SQLServerPedia — Authority: 147
  SQL 2005 introduced DDL Triggers, where you could catch events on your DDL statements in SQL, and hopefully most DBA’s are catching them, at least to a table and have some kind of report on who is adding, changing and deleting what objects. What I wanted to do was capture that, but also keep and automatic running ...
  19 hours ago

• Tired of hearing “M” is to “T-SQL” what X is to Y…

  
  .Net Braindrops — Authority: 107
  I have heard a couple of variations of these analogies. I do not like them. I think they are simply absurd. At last PDC, “M” was to “SQL” what C is to Assembler. This year it was, what VB is to C. And now I even read this: The code name “M” language is like a more manageable (though more limited) form ...
  22 hours ago

• SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY

  
  Journey to SQL Authority with Pinal Dave — Authority: 529
  Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while creating any view: Msg 1033, Level 15, State 1, Procedure something, Line 5 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, ...
  22 hours ago

• Microsoft Data Development Technologies: Past, Present, and Future

  
  Douglas Purdy — Authority: 559
  http://msdn.microsoft.com/en-us/library/ee730343.aspx This is one of the best articles that I have read about the Microsoft data and modeling history and strategy.  Kraig wrote this piece and I love it. Below is at the end of the doc that talks about modeling… Data Development Futures: Modeling If we ...
  23 hours ago

• What Version of SQL Is That?

  
  MPECS Inc. Blog — Authority: 130
  We have a client that needs to update a Line of Business application that is using a SQL 2005 Express instance. The LoB has a major update coming down the pipe and the product developer has stated that we need to have SQL 2005 SP2 at the minimum to support the newest features in the update. The following SQL ...
  1 day ago

• Episode 40: Silverlight 4 and Behind the Scenes at PDC 2009 with Scott Guthrie

  
  Deep Fried Bytes — Authority: 100
  What better way to find out what is going on in .Net development than to get it straight from The Gu himself?  Keith and Woody were invited back to PDC 2009 to cover all of the announcements and get the scoop on what the future is for Microsoft developers. The guys sit down with Scott Guthrie, Corporate Vice ...
  1 day ago

• Replication Scripts: Show All Transactional Publications & Subscribers At Distributor

  
  SQLServerPedia — Authority: 147
  Anybody who has talked with me about replication or heard me present about it knows that I recommend using a dedicated remote distributor for anything beyond light replication workloads. Unfortunately neither SSMS nor Replication Monitor provide an easy "one view to rule them all" way at the distributor (or anywhere ...
  1 day ago

• Replication Scripts: Show All Transactional Publications & Subscribers At Distributor

  
  SQLServerPedia — Authority: 147
  Anybody who has talked with me about replication or heard me present about it knows that I recommend using a dedicated remote distributor for anything beyond light replication workloads. Unfortunately neither SSMS nor Replication Monitor provide an easy "one view to rule them all" way at the distributor (or anywhere ...
  1 day ago

• How do -you- install SQL Server? (Part 2)

  
  SQLServerPedia — Authority: 147
  Welcome to this series on a thought process around SQL Server Installation. In Part 1 , we started talking about some basic steps and a thought process for a repeatable success story with your SQL Server installations. Today lets continue that story and talk some more about installation planning and success. Well ...
  1 day ago

• Replication Bug with Partitioned Tables

  
  SQLServerPedia — Authority: 147
  Recently, we came across a bug in SQL Server 2005 on one of our production servers. Apparently, if you execute an ALTER TABLE statement on a replicated table with more than 128 partitions, the log reader will fail. A relatively obscure bug, I know. Microsoft has recognized this as a confirmed bug, but I couldn’t ...
  1 day ago

• DBA Thanksgiving

  
  SQLServerPedia — Authority: 147
  Last month I went to visit some friends in Montreal. It just so happened to be the weekend right before the Thanksgiving holiday in Canada. While there we happened to meet some new people, which is always nice while traveling. During the discussions with our new friends we came about the topic of Thanksgiving, how it ...
  1 day ago

• Consolidating SQL Server Environments

  
  Systems Engineering and RDBMS — Authority: 104
  Consolidation is one of the most important topics nowadays in IT/Dev/Production environments.  There are a lot of options available to sysadmins, DBAs and Developers to consolidate their environments with the key one being virtualization.  For SQL Server consolidation also, there are several different options – ...
  1 day ago

Comments about sql server