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

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

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

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

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

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

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

  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

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

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

Problem

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

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

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

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

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

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

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

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

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

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