Archives: October 2012
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…
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
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
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.
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.
...but this post isn't about PAL. Lots… Read more