SQL Server

This category contains 5 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

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

So I ran into a slight problem while I was trying to access a vendor database that was running SQL Server 2000 Desktop Engine (MSDE).  This database contained employee information that we wanted to use in automated batch jobs, hence why not just connect to it and access thed data in real-time and do what we … Continue reading

SQL Server Reporting Services – Back Up Encryption Key WMI Error

Reports are an important tool for law enforcement and at the agency I work at, we use SQL Server Reporting Services (SSRS) to manage our reporting needs from quick and dirty reports to full fledge strategic reports. One of the most important tasks of managing SSRS is to backup the encryption key that is used … Continue reading