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

Archives: August 2011

Unleashing my inner Viking, SQLBits and more…

In case you didn't know SQLBits 9 ,”Query across the Mersey”, is taking place in Liverpool from September 21st to October 1st.  3 days of the usual excellent quality presentations, networking interspersed with the odd beer or two should all make for an informative and entertaining conference.  Rumor has… Read more

1 comments, 696 reads

Posted in Dave Ballantynes blog on 31 August 2011

Are You Willing To Relocate?

I've recently been talking to people looking for DBAs and one of the questions that always gets asked early on in the conversation is "Are you willing to relocate?". It's an easy question to ask but not always easy to answer.  I suspect most people would easily give a yes… Read more

12 comments, 1,278 reads

Posted in Kendal Van Dyke on 31 August 2011

Receive error #13119 in toolbox instead of tools in Visual Studio 2008

A couple of times over the past few months, while in Visual Studio 2008 working on an SSIS package, I went to the toolbox and saw this message:

There we no tools at all showing up.  Apparently the toolbox became corrupted, but fortunately it is easy to fix.  Here were… Read more

0 comments, 989 reads

Posted in James Serra's Blog on 31 August 2011

BI Battle Royale–Adam beats up a Hippie

Weekday Lunch RAW!

Welcome to the Smack-down ladies and gentleman. I couldn?t believe it when Brian walked into my office the other day and threw down this challenge. He actually thinks he can use one of his tired old webinar topics and get more attendees to show up for his… Read more

1 comments, 884 reads

Posted in Adam Jorgensen on 31 August 2011

Check the Default Database Setting for your Admin Accounts

Last weekend, as I was waiting for the start of the performance of the Cleveland Orchestra at its summer outdoor venue, Blossom Music Center, a client called with a problem. The databases on his principal production server had failed over to the mirror server, and now he couldn't connect… Read more

1 comments, 767 reads

Posted in Allen White on 31 August 2011

Presenting at Curacao SQL UG

On Thursday, Sept 1, 2011 at 7:15pm EST, I’ll be presenting via LiveMeeting to the Curacao SQL Server User Group. This will be my second time presenting to these great folks, and I’m really looking forward for this return visit.

The topic is Banish RBAR!, and the abstract for… Read more

0 comments, 695 reads

Posted in A Discussion of SQL Server-Related Topics on 31 August 2011

Bitwise and Derived Table revisited

Today I am going to revisit two posts from the past couple of weeks.  I want to revisit them just to make some minor updates and clarifications.  This is nothing earth-shattering but is good info to have.

The two posts to revisit are:

  1. Bitwise Operations
  2. Derived Table Column Alias

Bitwise…

Read more

0 comments, 715 reads

Posted in SQL RNNR on 31 August 2011

Convert EBCDIC to ASCII in SSIS

    Converting EBCDIC to ASCII in SSIS 2008 can seem like a daunting task. There is a lot of manual work involved in creating a data flow to move data from an EBCDIC system like AS400 or DB2, to an ASCII system like a SQL database. This can be accomplished,… Read more

6 comments, 2,850 reads

Posted in Mike Davis SQL on 31 August 2011

Sharon Dooley’s Lightening Talk and the WIT Luncheon

At the end of last week I received an email from my friend and colleague Sharon Dooley telling me her “Lightening Talk” had been accepted and she would be speaking at the Summit in October. Sharon has many years experience in the IT industry, a former SQL Server MVP, currently…

Read more

0 comments, 1,012 reads

Posted in The SQL DBA in the UK on 31 August 2011

SQL Server, EarthQuakes and the End…Of DBAs?

SQL Server, EarthQuakes and the End…Of DBAs?

What does the advent and integration of VMs, SSDs, and the Cloud mean for the traditional DBA?

These are very distinct and powerful emerging technologies that can and will have a direct impact on the future of the DBA.  Read on to… Read more

1 comments, 1,187 reads

Posted in Pearl Knows on 31 August 2011

Book Status #1: Indexing for Performance

As some of you may know, I am writing a book on indexing.  So far I’ve written and submitted four of the chapters to the publisher.  If anyone ever says, “Writing a book is easy” – kick them.  When they tell you – “it’s really hard” you might want to… Read more

0 comments, 565 reads

Posted in StrateSQL on 31 August 2011

Mobile Commerce and SQL Performance Tuning

I was reading through Gartners Top Predictions and one prediction captured my attention:

 “By 2014, over 3 billion of the world's adult population will be able to transact electronically via mobile or Internet technology”

 The reasons given are:

 1)   “6.5 billion mobile connections by 2014”

2)   “Global adult population to… Read more

0 comments, 715 reads

Posted in SQLServer-DBA on 31 August 2011

Shrinking Transaction Logs

I see questions on forums all the time about DBA’s or System Admins finding they are out of drive space due to a very large transaction log.  Post vary a bit on what the admin has tried but a common theme is that they have tried shrinking the file but… Read more

1 comments, 1,037 reads

Posted in Tim Radney - Database Professional on 31 August 2011

Computed Columns and UDFs

I wrote about the basics of computed columns and also using CASE in a computed column recently, but there’s a better way to implement a computation, and reuse the code. You can include a UDF in a computed column.

UDFs are a great way to encapsulate your code into an… Read more

0 comments, 1,782 reads

Posted in The Voice of the DBA on 30 August 2011

PASS Regional Mentor

Wow, how time flies by.  It seems like just a month ago I was made the PASS Regional Mentor for South Central US and now I have given up that position to join Jorge and Adam as Regional Mentors for South East US.  Being I live in GA, it is… Read more

0 comments, 577 reads

Posted in Tim Radney - Database Professional on 30 August 2011

Strong Manager or Weak Manager?

Here’s the link to my editorial on SSC last week. I was pleasantly surprised by the discussion, and was interested to see that rather than strong the word ‘brave’ popped up. That’s interesting to consider, it’s less about technical skills and more about personality, the willingness to fight the hard… Read more

0 comments, 636 reads

Posted in SQLAndy on 30 August 2011

Using PowerShell to Monitor SQL Server

By Ian Treasure

Over the past few years, I have used a number of approaches to monitor SQL Server. For example, I have configured jobs to e-mail the DBA team if they fail. I have written programs to check that everything is OK. I have used a number of third-party… Read more

3 comments, 2,935 reads

Posted in The SQL DBA in the UK on 30 August 2011

TRUNCATE_ONLY is not a recognized BACKUP option

Executing the code below in SQL Server 2008 will throw an error message:

 

BACKUP LOG ‘MyDatabase’ WITH TRUNCATE_ONLY

Msg 155, Level 15, State 1, Line 44
'TRUNCATE_ONLY' is not a recognized BACKUP option.

It was deprecated in SQL Server 2008.

 Some options for SQL Server 2008 are :

  Read more

0 comments, 2,644 reads

Posted in SQLServer-DBA on 30 August 2011

Datawarehouse Trends – In-memory

What does the emergence and growth of In-memory databases mean for  Datawarehouse? 

 1)  In-Memory database server systems are  fast.  Consideration should be given to hardware purchases, configuration and consolidation. I’ve been working with solidDB over the last few months and the speed differences are obvious. The Query response and commit times are… Read more

0 comments, 773 reads

Posted in SQLServer-DBA on 30 August 2011

T-SQL Enhancements: FIRST_VALUE() and LAST_VALUE()

A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I will show you guys a couple of new windowing functions, that goes along with the OVER clause. These new functions are FIRST_VALUE() and LAST_VALUE().

I’ll use the same setup… Read more

6 comments, 2,289 reads

Posted in SQL Server Notes from the Field on 30 August 2011

Older posts