//
archives

SQL

This category contains 4 posts

PASS Summit 2013 – My Thoughts and Experience

It’s been a few weeks since The PASS Summit 2013 ended and after a few hectic weeks of playing catch up at work, I finally have some time to write down some of my thoughts and experiences of my very first PASS Summit experience. First, if you don’t have much time to read, you’ve never … Continue reading

How to Make Scalar UDFs Run Faster (SQL Spackle) – SQLServerCentral

Whenever I have time at work for to do something specifically for myself (not very often), I try to read up some of the latest articles and tips on SQL Server.  I ran into a very interesting one today that might make a big difference in some of the views and transformations that I have … Continue reading

No SA Password, Removed Builtin\Administrator, No Problem (Part 2)

In my previous post, I needed to get into a vendor SQL Server 2000 database that was locked down.  For this situation, I am trying to access another database from the same vendor, but for this system, they are using SQL Server 2005 Express Edition.  Again, due to the same draconian policies from the vendor, … Continue reading

BlackBerry Enterprise Server (BES) 5: Issues Deleting a User

As I mentioned in my About page, one of the advantages of my position is that I’m not pigeon-holed into only performing traditional DBA tasks.  One of my projects was to manage the implementation and roll-out of BlackBerry devices, which can query the police database, for officers that patrol on foot or bicycles. The other day, I had … Continue reading