Today I found myself in an odd situation where I wanted to access the SQL Server instance of a Windows Update Services (WSUS) instance, so I could perform some basic maintenance to reduce the DB’s disk and memory footprint. This instance of WSUS has been running for a few […]
SQL Server
7 posts
Recently I was asked about diagnosing deadlocks in SQL Server – I’ve done a lot of work in this area way back in 2008, so I figure it’s time for a refresher. If there’s a lot of interest in exploring SQL Server and deadlocks further, I’m happy to write an […]
Do you prefer offline help and documentation? Sometimes I prefer offline help, particularly when I’m travelling or when a stable Internet connection is not available. It is particularly useful if you work in an environment where external access is difficult, for example in a secure datacentre. I find offline documentation […]
Intro If you have used or are deciding on using an Azure hosted SQL Server database, you might also want the ability to govern the identities and credentials used to access your data. When you create a SQL Database in SQL Azure, initially credentials are created for you, but they […]
Intro If you want to manage your SQL Databases in Azure using tools that you’re a little more familiar and comfortable with – for example – SQL Management Studio, how do you go about connecting? You could read the help article from Microsoft, or you can follow my intuitive screen-based […]
Introduction Recently I began writing a series of articles demonstrating how you could take a blank Database schema and bring it all together with a fully integrated object relational mapping access model (Entity Framework) and then exposing the entire object graph via WCF web services in a completely detached mode. […]
Introduction Per my introduction article, I’m learning the hard way – with the latest from Microsoft. Yesterday I created a SQL schema from a Twitter archive which was “fun”, but didn’t provide me with a decent enough schema to model a complete end-to-end design for something meaningful. So I’m back […]