I have been taking advantage of my work break to develop new skills. This post is a reminder to myself about changes in SQL Server connection encryption and how it affects the PowerShell module dbatools. …
In the past year I’ve been working more with SQL Server on Azure virtual machines. I was initially excited about Marketplace images for SQL Server virtual machines, but having deployed them as a test, I …
I was recently frustrated by the plain Open File dialog box presented in SQL Server Management Studio. The Look in: options are limited to Desktop, My Projects, and My Computer. I make frequent use of …
I was very fortunate to get last-minute approval to attend the Summit. This is my third year attending, but the first time that I’ve represented my employer. I arrived late on Tuesday evening, so I …
Recently my install of Management Studio decided to reset itself back to the defaults. After a bit of hunting around for the blog posts that listed some great configurations, I decided to make note of …
With SQL PASS Summit 2009 now over, it’s time to return to the real world. Fortunately I booked a few extra days off; it’s time needed to recover from the cold I picked up in …
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 …
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?