After all my messing around yesterday, I've decided to create this post in pocket word. I attended a securty session yesterday and was reminded of an issue that can send DBAs scuttling from the room when they learn of it's presence, the 'trojan report'. Reporting Services (RS) reports can use Windows...

If you were given an opportunity to create a “cubed” solution for 50,000 different users, would you create one cube with 50,000 roles? Would you create 50,000 cubes – one for each customer? What would you do? This is what Mosha Pasumansky and Dave Wickert from the product team suggest for SQL Server...

For 3 or 4 years I’ve been telling people how Microsoft has made security and privacy the number one priority. From this Yankee Group article (excerpt below) – it’s good to see perception change and that change based on customer experience. " In terms of security, The Yankee Group identified a...

Security – I find it very hard to get enthusiastic about security, after all it doesn’t visibly do anything; I’d far rather solve the world’s problems than avoid them. However this is such an important topic I thought I should blog on the topic sooner rather than later. The aim of this blog is to take...