About a belle

Who am I?
- Donabel Santos
- SQL Server Developer/DBA/Ninja at Black Ninja Software in Vancouver, British Columbia
- Instructor at British Columbia Institute of Technology (BCIT) School of Computing and Academic Studies. Currently teaching Web Development, MySQL and SQL Server
- MySQL Core, MySQL Professional
- MCP, MCTS, MCITP-Developer, MCITP-DBA and most recently, MCT!
Resident SQL Server Ninja at Black Ninja Software
I am the resident SQL Ninja at Black Ninja Software. Black Ninja Software is a forward thinking, proactive SharePoint/ASP.NET/SQL Server consulting company in Vancouver, British Columbia.
What does a SQL Ninja do, you ask?
As a SQL Ninja, I work on the SQL projects for clients – remote administration, configuration, reporting, optimization, profiling, and a whole lot of querying. I also do SQL Server training.
I enjoy working a lot with SQL Server. And at Black Ninja, I work with some of the coolest, smartest people around town.
Here is my shameless plug. If you need any SQL Server help, don’t hesitate to ask. Call me, email me, post a comment in my blog. Don’t worry, I don’t bite. Contact details at the Black Ninja Software Contact Page.
What is this blog for?
This blog contains some of the things I learn about SQL Server, some of the gotchas that got me, and some of the gotchas I escaped from thanks to other people’s blogs, articles and what nots.
These are my own discoveries as I work with SQL Server. Everyday, I learn a new thing or two about SQL Server. I learn a lot from colleagues, students, and other books and blogs. I am using this blog as a medium to retain a little fraction of this learning, and to share it in case it’s useful to someone else.
Geeky as it sounds, I *really* love working with SQL Server and I *really* love teaching SQL Server. I am excited to learn more about this product, be it development, reporting, administration, SQL on the cloud, SQL clustering – the sky is the limit.
In a previous job, I worked as a DBA for one of the biggest advertising companies in Canada (for their real estate and automotive vertical). I also used to work a lot with MySQL and SharePoint (both WSS and MOSS), so you will find tidbits about MySQL and SharePoint in this blog. I used to actively blog about SharePoint in sharepointmusings and have been involved in administration, customization (branding, web parts, features, BDC, SSRS integration) of SharePoint projects.
SQL Server Connection
Did I mention yet that I *love* working with SQL Server?
My experience in SQL Server 2000/2005 includes:
- user defined functions (UDFs), Stored Procedures, Triggers
- general administration
- security and user/permission management
- backup/restore
- general troubleshooting
- high availability strategies (log shipping, database mirroring, replication)
- query optimization, indexes
- Reporting Services and Notification Services (SSRS, SSNS)
- integration with SharePoint 2007
- training/teaching
Currently, I am engrossed with:
- Powershell
- SMO (SQL Management Objects)
- Windows Server 2003/2008
- SQL Server 2008
- SQL Server on the Cloud
- SQL Clustering
My previous positions include:
- SQL Server Developer/DBA (database administrator)
- SharePoint/SQL Server/C# developer/consultant
- MySQL/PHP/Perl developer
- Linux sys admin
- Web developer (HTML/XHTML/CSS/Javascript/XSL)
Previous Talks/Speaking Engagements:
I also like sharing what I learn either in classroom lectures, or speaking engagements within the development community.
Victoria Code Camp
SharePoint 101, Advanced SharePoint (Presentation Materials)
DevTeach/SQLTeach
SharePoint 2007 Integration (Web Parts, Business Data Catalog (BDC), SQL Server Reporting Services (SSRS), SQL Server Notification Services (SSNS), SQL Server) (Presentation Materials)
VANTUG
SharePoint 2007 Integration (Web Parts, Business Data Catalog (BDC), SQL Server Reporting Services (SSRS), SQL Server Notification Services (SSNS), SQL Server) (Presentation Materials)
SQLPASS
SQL Server Notification Services (SSNS) 101 (Presentation Materials – look for Sep2007)
Additional Stuff About Me:
belle’s BCIT Profile 1 2
belle’s SharePointMusings
belle’s LinkedIn

Microsoft Certified Trainer (MCT)

Microsoft Certified Information Technology Professrional (MCITP) - DBA, Developer

Microsoft Certified Technology Specialist (MCTS)

Microsoft Certified Professional (MCP)
*Postings in this blog are provided “AS IS” with no warranties
July 15th, 2010 by belle
Arnie Rowland just sent me an email informing me about this great give-back-to-the-community initiative. Many MVPs, including Arnie Rowland, Denny Cherry, Bill Graziano, Bill Simser, Paul Turley (whose sessions I attended last SQLPASS 2009)
Here is a quote from Arnie’s blog post :
“We are inviting unemployed or underemployed developers to propose a software project for a non-profit agency, school, or church.
The idea is that we will provide a package of the latest software, tools, and training resources to help you improve your skills, get up to date with current technologies, gain practical experience, potentially earn a recommendation for your efforts, and in general, enjoy the feeling of accomplishing something useful for others.
We are not giving out a ‘free lunch’, just supporting your efforts to personally gain from your own ‘sweat equity’.
The software, books, training and development tools are valued at over $15,000!
I think this is an excellent initiative, and will definitely help motivate developers to improve their skills and their toolsets. Think about it. If you’re an aspiring developer, you can also get the chance to have hands on practical experience – at the same time having the chance to get geeky feel-good goodies! C’mon, free books? Who can refuse that? (not me. I always have room in my bookshelf for free books. @BrentO (twitter | blog), by the way, I will need your autograph in my SQL Server Internals and Troubleshooting book. I will bring it in November!
So here’s what you need to do:
1. If you’re unemployed or underemployed, start looking for a non-profit project (see requirements in Arnie’s blog), and join.
2. If you’re neither unemployed nor underemployed – help spread the word.
3. If you’re neither unemployed nor underemployed – and you’re an MVP – sponsor 
4. If you’re not interested, or you don’t care – just spread the word too. You’ll earn brownie points – somewhere.
Details are in Arnie’s blog: http://sqlblog.com/blogs/arnie_rowland/archive/2010/07/02/there-will-be-no-free-lunch-just-great-feelings-of-accomplishment.aspx
VN:F [1.4.0_681]
Rating: 10.0/10 (3 votes cast)
Posted in musings | Comments
June 25th, 2010 by belle
Had a very long week, but nothing like some humor to end the week on a high note
penny arcade – girls dig RAM

by the way, the bigger girl geeks dig the Apple iPad and the macbook pros
sudo

xkcd – regex

this one’s for ya, @GFritchey – (ScaryDBA)
VN:F [1.4.0_681]
Rating: 10.0/10 (1 vote cast)
Posted in musings | Comments
June 20th, 2010 by belle
Just wanted to share some common “tips” or “tricks” I find myself using over and over again when creating reports.
I think I’ve had this draft for a while, and just never was able to publish it because things got so busy. Anyway, I will just publish in parts. Better late (and something) than never (and nothing!)
Common Report Tasks
Common page headers and footers
Report (reportname) generated by DOMAIN/User on 02/03/2010 4:51:03 PM
="Report (" & Globals!ReportName & ") generated by " & User!UserID & " on " & Globals.ExecutionTime"
Page X of Y
="Page " & Globals!PageNumber & " of " & Globals!TotalPages
If you have start and end date parameters, and want to display them in your header or footer, with date formatted as MMM dd, YYYY
="Report Details from " & Format(Parameters!StartDate.Value, "MMM dd, yyyy") & " to " & Format(Parameters!EndDate.Value, "MMM dd, yyyy")
Read more
VN:F [1.4.0_681]
Rating: 9.0/10 (7 votes cast)
Posted in Resources/References, SQL Server 2008 Reporting, SSRS, musings | Comments
June 20th, 2010 by belle
Posted in musings | Comments
June 13th, 2010 by belle
I would like to say a huge and warm thank you to all who attended my sessions for SQLSaturday#43 in Redmond. It was such a great event, and I hope you enjoyed the sessions – and enjoyed the whole day with all the wonderful speakers.

As promised here are the files for my sessions:
Read more
VN:F [1.4.0_681]
Rating: 10.0/10 (3 votes cast)
Posted in Powershell, SQL Server 2008, SQL Server 2008 Reporting, SSRS, Speaking Engagements | Comments
VN:F [1.4.0_681]
Rating: 7.7/10 (3 votes cast)