sql server 2008

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

Are you an expert about 'sql server 2008'? Do you want to be the Technorati authority on 'sql server 2008'? You can write a description that will appear right here: Join Blogcritics!

Latest blogosphere posts tagged “sql server 2008”

 

• Installing and configuring a SQL server 2008 R2 failover cluster

  
  — Authority:
  To understand what is the failover clustering and its general requirements you can go here. To install failover clustering solution, here are essential steps to remember: 2 servers based on Windows Server 2008 need to be installed At least two network cards required: a public card (with dedicated IP) to connect each ...
  1 week ago

• T-SQL – Get a Historical Record of SQL Statements Hitting a Table

  
  — Authority:
  Today I’ll review two useful queries that you can use to get information from SQL Server about what SQL statements are hitting one or more of your database tables. If you are interested in further T-SQL tips and tricks, please have a look through related articles I have written. The first query will check SQL […]
  2 weeks ago

• SQL Server Upserts – Using MERGE to INSERT or UPDATE Table Rows

  
  — Authority:
  The idea of an Upsert was added in the SQL 2003 standard for databases and is implemented using a MERGE statement in both Oracle and SQL Server. So You Might Ask: What is an Upsert? An Upsert does pretty much does what it sounds like: it runs an update on a row where a condition […]
  2 weeks ago

• SQL Saturday #200 - Philadelphia

  
  — Authority:
  If you read my post from yesterday you will know I will be spending some time on the US east coast at the end of May.Last week my friend and fellow Learning Tree instructor Sharon Dooley asked me if I would like to attend SQL Saturday #200 in Philadelphia which is being organised by the Philadelphia User group. Seeing ...
  2 weeks ago

• SQL Server 2008 Diagnostic Information Queries (May 2013)

  
  — Authority:
  Here is the May 2013 version of my SQL Server 2008 Diagnostic Information Queries , with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008. To go with it is an updated, blank 2008 results spreadsheet , where the ...
  2 weeks ago

• SQL Server 2008 R2 Diagnostic Information Queries (May 2013)

  
  — Authority:
  Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries , with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008 R2. To go with it is an updated, blank 2008 R2 results spreadsheet , ...
  2 weeks ago

• T-SQL – Replace Multiple Extra Whitespaces in a String with One Whitespace

  
  — Authority:
  In this article I will review three easy methods that can be used to replace extra spaces between words in a string. Note that if you want to remove extra spaces from the start and end of your string you will still need to encapsulate the output of the routines within the standard LTrim / [...]
  3 weeks ago

• T-SQL – Using the OUTPUT Clause to Get Identity Keys and Log Historical Data

  
  — Authority:
  The OUTPUT clause is a useful part of your T-SQL arsenal that has been added as of SQL Server 2005. You can use the OUTPUT clause in the same vein as @@IDENTITY, IDENT_CURRENT, or SCOPE_IDENTITY(), or even extend it to be a historical logging mechanism. Unlike @@IDENTITY, or SCOPE_IDENTITY(), you need to populate a ...
  3 weeks ago

• .NET Based CMS Alternatives To WordPress

  
  — Authority:
  .NET Based CMS Alternatives To WordPress In this article we will look at a few alternatives to WordPress, in particular we are looking for a Microsoft .NET based alternative. The WordPress Standard This website happens to use WordPress and I have been using it for several years, and have a good idea of what a good CMS ...
  4 weeks ago

• Elegant Random Number List in SQL Server

  
  — Authority:
  Coded using: Visual Studio Express 2012 for Web, .Net Framework 3.5, C#, SQL Server 2008 R2 SQL Server has limited functionality for generating random numbers. C# on the other hand has an elegant and easy-to-use function. Using SQLs Common Language Runtime (CLR)  makes it a snap to add this C# functionality to your ...
  4 weeks ago

Comments about sql server 2008