SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2012

Using Invoke-WebRequest

The website PowershellCommunity.org is moving to a new site poweshell.org and I wasn’t sure the old forum posts will be brought over. Well, I kind like some of the answers I provided in the SQL Server forum and wanted to download them into a text file in case I ever… Read more

0 comments, 2,440 reads

Posted in Chad Miller on 26 October 2012

DBA Question of the Day

When I used to work in an office I had a stack of flash cards and occasionally I'd grab a few, see if I still knew them and the answers and I'd walk around and discuss them with some of the other DBA's.

At Pragmatic Works I do this on…

Read more

1 comments, 762 reads

Posted in SQLBalls on 25 October 2012

Using PerformancePoint against tabular data

PerformancePoint (PPS) is typically used against multidimensional data sources (i.e. Analysis Services), but it does have the ability, albeit limited, to work against tabular data sources such as SQL Server tables, SharePoint Lists, Excel Services, Import From Excel Workbooks, and even PowerPivot (with its xVelocity engine).

Data sources serve as… Read more

2 comments, 2,749 reads

Posted in James Serra's Blog on 25 October 2012

PASS 2012 Countdown – 2 Weeks To Go

I’m not sure how we got to 2-weeks until this year’s PASS Summit.  If you haven’t registered yet it’s really getting to be time to do that.  It’s really easy to do, click on the banner below and enter your information and your neighbor’s credit card, but I didn’t… Read more

0 comments, 748 reads

Posted in StrateSQL on 25 October 2012

The SQL PASS Summit countdown has already started!

As a SQL Server professional, I consider it an absolute must to attend the SQL PASS Summit each year. Last year was my first year attending the SQL PASS Summit 2011, and I must say, it changed my life. The community around SQL Server is quite possibly the greatest draw… Read more

0 comments, 913 reads

Posted in Technobabble by Klee from @kleegeek on 25 October 2012

You don’t like SQLTreeo price

Today is the first day when we turned SQLTreeo into a commercial product and your emails continue to flood into our mailbox, with the overall message that you don’t like price. We are listening and we want to respond. SQLTreeo is not an entirely business-driven project and we are able… Read more

0 comments, 1,390 reads

Posted in SQL Treeo on 25 October 2012

SQL won't start because there's not enough space to create TEMPDB

SQL Server will not start.

You open up the ERRORLOG (...which I would only do with a text editor like gVim that creates a cache of the files it opens and can safely read files that have the possibility of being written to while you are reading it...) and you… Read more

0 comments, 1,313 reads

Posted in @chuckboycejr on 25 October 2012

Denali –Memory : Memory Error Recovery in SQL Server 2012

  Continue on What’s new in Denali and Memory enhancement, come across another great article by SQLCAT and Glenn Berry a new feature of Sql server 2012 in association with windows server 2012 called Memory Error Recovery in SQL Server … Continue reading

Read more

0 comments, 811 reads

Posted in Vinay Thakur on 25 October 2012

PASS DBA Virtual Chapter Deck and Demo's Live

Hello Dear Reader, I wanted to say a quick Thank You to the PASS DBA Virtual Chapter for having me  today.  My Deck and Demo's are up on the Resource Page.  Thank You to the 150 people who took the time to attend as well!  We couldn't do this…

Read more

1 comments, 510 reads

Posted in SQLBalls on 25 October 2012

Windows 8 First Impressions

I haven’t worked with Window 8 at all. I’m not a big beta tester, and it’s been a busy few months for me, so I haven’t bothered to mess with any of the previews. My Win 7 desktop works well for me, and I haven’t bothered to think about doing… Read more

0 comments, 1,255 reads

Posted in The Voice of the DBA on 25 October 2012

SQL Server Service Broker error database cannot be enabled


The SQL Server Database Engine returns the following error message after a service broker enabled database is restored to the same SQL Server instance with a different database name and the T-SQL command (ALTER DATABASE ‘DatabaseName’ SET ENABLE_BROKER) is issued to enable the Service Broker for this restored database. Read more

0 comments, 1,748 reads

Posted in Basit's SQL Server Tips on 24 October 2012

Getting Started with Partially Contained Databases

Before SQL Server 2012, when we move or restore databases to a different SQL Server instance, then any logins associated with the database users do not automatically relocates to the new instance. As a result of this, we end up having orphaned users inside databases and these databases do not… Read more

0 comments, 829 reads

Posted in Basit's SQL Server Tips on 24 October 2012

SQLSat153 Recap

You may not know that this past Saturday ( October 20, 2012) was SQLSaturday 153 in Salt Lake City.  If you knew about it, awesome.  If you attended – even better.  You probably don’t know that I was there presenting this year.  I was a huge slacker in getting the… Read more

0 comments, 689 reads

Posted in SQL RNNR on 24 October 2012

Reported: VMware’s Oracle support goes 24/7 starting Q1 2013

Michael Webster from longwhiteclouds.com reported that VMware Global Support Services told him a few days ago that the Extended Oracle Support Policy is going to be running 24 hours a day, 7 days a week as of Q1 2013.

The original post is here. This is fantastic news for… Read more

1 comments, 627 reads

Posted in Technobabble by Klee from @kleegeek on 24 October 2012

Virtualizing Your Business Critical SQL Servers Anthology

This week I completed a six-part blog series (more like five plus one) on the path to virtualizing your business-critical SQL Servers at the blog series at my employer, House of Brick Technologies. Every day I fight the fight in my day job for database virtualization in the enterprise. I… Read more

2 comments, 2,214 reads

Posted in Technobabble by Klee from @kleegeek on 24 October 2012

Policy-Based Management, How Sweet It Is

I have just recently changed employers and in doing so, I’ve changed my role from Data Architect to DBA/BI Developer.  I had been doing heads down development work for the last 4 plus years and not a lot of admin work.  Given that, I missed out on something that I… Read more

0 comments, 1,783 reads

Posted in SQL Swimmer on 24 October 2012

Discovering Binary Pages In Sys.Indexes

In a previous post, we looked at how to take the the binary page values in sysindexes and convert the values into file id and page id for the first and root index page and first IAM page for each index.  This information can be useful when you need to… Read more

0 comments, 1,069 reads

Posted in StrateSQL on 24 October 2012

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call to discuss and plan upcoming WIT activities, be it SQL Saturday WIT panels or the WIT luncheon at the annual PASS Summit. To help promote women in technology, I’m declaring… Read more

0 comments, 1,000 reads

Posted in Cleveland DBA on 24 October 2012

SQLTreeo now supports SQL Server 2012

New version of SQLTreeo SSMS Add-In was released. We fixed few bugs and include also one major change – SQL Server 2012 support. SQLTreeo Add-In also became commercial product which will help us to give more attention to further development and support. We are now working on local storage support Read more

0 comments, 877 reads

Posted in SQL Treeo on 24 October 2012


This is one of my most closely held DBA secrets.

Do you use PAL? You should.

Clint Huffman is a golden god and the wonder he has brought forth to the world in PAL is worthy of a statue in his honor.

...but this post isn't about PAL. Lots… Read more

0 comments, 1,220 reads

Posted in @chuckboycejr on 24 October 2012

Newer posts

Older posts