Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: February 2012

How to remove new line character from string using SQL ?




In a varchar column some of the entries were showing space in the left side and even after using the LTRIM it was not getting removed. When I tried to  print the first character using the ASCI function it was showing 13 which is a new line character. it can be…

Read more

1 comments, 4,016 reads

Posted in PracticalSQLDba on 26 February 2012

The Daily Status Meeting

For the past six months or so I’ve hosted a daily status meeting for a large project. It started out scheduled for 15 minutes and as the team grew, I found that we often ran out of time – not due to idle chit chat, but because we spent 3… Read more

3 comments, 1,448 reads

Posted in SQLAndy on 26 February 2012

SQL Saturday 108 in Redmond was a great success

Thanks to the organizers and volunteers for making SQL Saturday #108 an overwhelming success.  I’m just wrapping up the day following the Redmond SQL Saturday held in the Commons on the Redmond Microsoft campus.  Greg Larsen and all of the organizers did a fantastic job to make this a successful… Read more

1 comments, 475 reads

Posted in SQL Server BI Blog on 26 February 2012

SQL Saturday 108 (Redmond, WA) Session Files

SQL Saturday 108 (Redmond, WA) Session Files

SQL Saturday 108 Replication Magic

Session files are now available for download. The zip file contains the PowerPoint slide deck and demo code.

Zip file: ReplicationMagic.zip (5.2 KB)

    Included files:

  • Demo: Initializing replication from a log backup
    • InitializeFromLogPub.sql
    • InitializeFromLogSub.sql
  • Demo: Initializing replication from…

Read more

A Script A Day - Day 20 - User Database VLF Count

Today’s script will execute DBCC LOGINFO for all user databases.  This is a script I use to monitor the number of Virtual Log Files (VLF’s).  Kimberly Tripp has a great article on VLF’s here.

/*
      -----------------------------------------------------------------
      User Database VLF Count
      -----------------------------------------------------------------
     
      For more SQL…

Read more

0 comments, 1,115 reads

Posted in SQL Server 365 on 25 February 2012

A Script A Day - Day 19 - Remove Virtual Subscriptions

Today’s script is to help replication performance.  It was something I learned from my resident replication expert Paul Anderton.  Below is a description of virtual subscriptions.

If Immediate_Sync is set when a publication is created then virtual subscriptions can occur.  These can affect the "Distribution Clean Up: distribution" SQL job…

Read more

0 comments, 1,220 reads

Posted in SQL Server 365 on 25 February 2012

Powershell Get-EventLog and Event Log messages

This post explains how to list Event Log Messages with Powershell Get-EventLog  , on multiple servers and output the results to a HTML file.

It is only one extra step to send an email attachment.

This example iterates through a list of servers and returns Error messages from the System… Read more

0 comments, 702 reads

Posted in SQLServer-DBA on 25 February 2012

New Cumulative Updates For SQL Server 2008 R2

On Feb 22, 2012, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 5, which is Build 10.50.2806. This CU has 16 fixes listed.

If you are still on the SQL Server 2008 R2 RTM code branch, you would want to take a look at SQL Server 2008 R2… Read more

3 comments, 630 reads

Posted in Glenn Berry's SQL Server Performance on 24 February 2012

SQL Server 2012 (“Denali”): Spatial Features

SQL Server 2012 introduces several significant enhancements to spatial types, such as support for new subtypes of circular arcs, new and updated methods and aggregates for all subtypes, improved precision, and updates to the geography type.

More info:

New Spatial Features in SQL Server Code-Named “Denali”

Video Microsoft SQL… Read more

0 comments, 1,159 reads

Posted in James Serra's Blog on 24 February 2012

Re-blog – February 17 – February 23

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may not have had a chance to see.  Also a chance to bring back to the forefront posts that some may have seen but forgot about.

If you have… Read more

0 comments, 259 reads

Posted in StrateSQL on 24 February 2012

Speaking at the SQL Lunch UK

Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change.  Unlike the SQL Lunch that I host online here in the U.S., the SQL Lunch UK, which is hosted by Dave Bally (@davebally), will be held at a physical location.  Well except for the… Read more

0 comments, 487 reads

Posted in SQLDownSouth on 24 February 2012

Speaking at the SQL Lunch UK

Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change.  Unlike the SQL Lunch that I host online here in the U.S., the SQL Lunch UK, which is hosted by Dave Bally (@davebally), will be held at a physical location.  Well except for the… Read more

0 comments, 170 reads

Posted in SQLDownSouth on 24 February 2012

No MVP Summit for Me

On the corner of my rather messy desk is little recognition item in the image to the right. It’s a 5 year marker, representing my 5 years as a Microsoft MVP. I’m honored that they think I’m doing enough for the community to be recognized.

Next week is the annual… Read more

0 comments, 375 reads

Posted in The Voice of the DBA on 24 February 2012

SQL Server - DBA Team FAQ

Developers constantly ask about placing the latest code\feature\process\third party applications onto  Production Database Servers.

I’m building an FAQ  to supply Developers – as this could save me having very similar conversations .  

 Some other reasons for retaining a process is :

a)       Maintain database standards such as ISO-11179 Naming… Read more

0 comments, 576 reads

Posted in SQLServer-DBA on 24 February 2012

A Plea: Have your guidance documentation reviewed

Today one of my auditors sent me her matrix for auditing Microsoft SQL Server. I had seen part of it and some questions about some of the technical details I saw. In the email thread I discovered that some of it was taken from a guidance document from our professional… Read more

A Script A Day - Day 18 - Viewing System Configuration

Today’s script is something I’ve learned today, it’s cool learning new stuff!  When viewing server configurations in the past I’ve used the below;

EXEC sp_configure 'show advanced options',1;
GO
RECONFIGURE WITH OVERRIDE;
GO
EXEC sp_configure;
GO

This is all fine when making changes to the…

Read more

0 comments, 334 reads

Posted in SQL Server 365 on 23 February 2012

A Script A Day - Day 17 - Possible Poor Indexes

Today’s script is one I’ve taken from a job I use to collect possible poor indexes.  I’ve tweeked it slightly so you can choose the database to run it against. 

It goes without saying that you should never just remove an index without some considerable investigation doesn't it???!!!

/*
      -----------------------------------------------------------------
     …

Read more

0 comments, 329 reads

Posted in SQL Server 365 on 23 February 2012

PlayBook OS 2 Update Awesome, Why Pay Three Times the Price for an IPad?

I have become dependent on my tablet, here is why, thanks to a great summary from the Globe and Mail. Read more

0 comments, 671 reads

Posted in The Database Hive for SQL Server DBAs on 23 February 2012

Linchpin People LLC Announces Two New Partners - Press Release

February 23, 2012 – Today, LINCHPIN PEOPLE, LLC, offering technical advisory, consulting and training services in the Microsoft SQL Server Space, announces the addition of two key partners to the firm.

Mike Walsh, SQL Server MVP (blog|twitter) Founder and Owner of StraightPath IT Solutions,… Read more

0 comments, 1,671 reads

Posted in Pearl Knows on 23 February 2012

There is another.....LinchPin People names its new partners!

I wanted to follow-up on the partner announcement of the great new concept and venture, started by my friends and sql compatriots , Andy Leonard and Brian Moran, who have added two new Partners to the LinchPin People lineup.  Fresh from the first official Linchpin Summit,  Mr. Mike Walsh has pulled the LinchPin out of… Read more

0 comments, 515 reads

Posted in Pearl Knows on 23 February 2012

Newer posts

Older posts