The objective was to configure SSL access to a SQL 2012 Reporting Services server in Native Mode. The Certificate Issuer was a Certificate Authority created in the domain. On SSRS 2005 this was a piece of cake, go into IIS (version 7), double click on the Server Certificates icon and… Read more
About one year ago I had a Microsoft Premier Field Engineer come out to perform a health assessment on our SQL environment, what Microsoft calls… Read more
I had some sales reports that were running poorly on SQL 2005 Analysis Services. The information on the reports was mostly the same, it listed customers and the items they bought, or just items sold. The measures on the reports were all calculations. For a given date I needed to… Read more
To have a ‘date picker’ report parameter on your SSRS reports the process works the same on all versions of SSRS from 2005 through 2012. When you add the Date dimension as a filter in Query Designer it creates a report parameter for you. But the report parameter has a… Read more
The new certification structure has been announced by Microsoft and the changes are rather broad and sweeping. MCITP is gone. In what appears to be an attempt to recapture the popularity of the MCSE acronym MCITP has been replaced with MCSE, Microsoft Certified Solutions Expert. MCSA has also been… Read more
Short version – Installed SQL Server 2012 RC0 onto a Server 2008 SP2 VM using an RDP connection from my iPhone with Wyse’s PocketCloud app… Just to say I did it.
Long version – Hardware used: white box PC with an AMD 3800 processor (dual core, 2 Ghz). Virtualization software… Read more
I tuned into the Third Thursday sessions for November and wanted to try boiling down the talks to what I thought were the most important takeaways.
The first was from Pete Harris about new SQL Server 2012 courses from Microsoft. Here are the highlights:
- Five courses have been funded and…
I was doing a database server migration for a client this week that involved a local database server with Access front end. And this was being kept in sync using merge replication with a database on a hosted, dedicated server that had a web front end. The client had originally… Read more
I recently did a VMWare/SAN assessment for a client. The expressed reason, or the reason relayed to me (not always the same thing), was they wanted me to review their configuration for best practices and look for performance enhancement opportunities. It was a multi-site SAN with close to a dozen… Read more
This is day one of my SQL Server blog so I’m not looking to write anything deep or insightful or even useful to the community at large. I just want to get my feet wet, make sure I know the basic mechanics of how this works, and leave wow’ing people… Read more