Thanks for the community
It seems that taking care of the database servers is a responsibility that has always fallen to me wherever I’ve worked. Though I’ve never formally held such a position, I consider myself to be a …
It seems that taking care of the database servers is a responsibility that has always fallen to me wherever I’ve worked. Though I’ve never formally held such a position, I consider myself to be a …
Too often developers and administrators alike find an easy solution to providing data access is to give users more permissions than are truly required. In the development environments I’ve worked in, developers always worked with …
I attended a lovely lunch demo of Foglight by Quest Software earlier this week. As I was leaving and handing in my evaluation, I received a branded USB flash drive, the current hot freebie item. …
We publish datasets and documents that are specific to certain geographic areas of Alberta. The public comes to our website and wants to find all information that pertains to a town, city or area. We currently use Oracle Spatial to calculate where our publications are geographically, but with the move off of Oracle, we need a new method.
My Oracle to SQL Server 2008 migration is going well and is close to wrapping up. In an effort to make the transition as seamless as possible for the users, I wondered what kind of options were available to me to reuse the known name of the Oracle server, once it’s been taken offline. There has already been a DNS alias set up to obscure the actual name of the SQL Server, but the instance name still has to be added. Our SQL Servers are all named instances; can I refer to a named instance as DBPROD instead of PRDDB\PRD1?
I signed up for numerous sessions of 24 Hours of PASS not long after receiving notification of the event. It seemed like an ideal opportunity to preview some of the excellent speakers I was hoping …
A few months ago I was thrilled to get approval from my boss to attend SQL PASS Summit in Seattle in November. It would have been my first opportunity to attend such a large and …