Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Browse by Tags

Tagged Content List
  • Blog Post: Evaluate This – Storage Spaces

    So far in this series I have used the new storage features of Windows Server 2012 as a  place to run VMs from, but there’s more to it than that.  Shared storage used to mean presenting SAN storage inside a cluster, and you relied on your SAN experts to provision the storage you needed. ...
  • Blog Post: MCSE for SQL Server

    I have to be honest I gave up getting certified before I joined Microsoft mainly because the exams didn’t keep up with the release of SQL Server specifically the Business intelligence exams. I then had the same problem as an evangelist I was working on the next release of the SQL or Windows Server. However...
  • Blog Post: Contain your Enthusiasm

    You may be aware that I am still keen on SQL Server and despite the changing nature of my role at Microsoft I still try and keep my hand in with the latest version.  One thing I overlooked until I did SQL Relay was contained database security which is easy to use and can make your life a lot easier...
  • Blog Post: SQL Relay Notes and Queries

    I wanted to something different for SQL Relay last week as this is a community driven event and I didn’t want to cover areas that the other experts on the Relay team would cover. This left some gaps and I have had several follow up questions via twitter and e-mail which I want to cover in this post....
  • Blog Post: SQL Relay 2012

    Four cities,  in four days makes for one tired evangelist, so why am I doing SQL Relay with the SQL community I hear you ask.  Well that’s your answer really -  I can’t hear you ask anything when I am sat in darkest Surrey blogging away so I am actually doing these events not so much to...
  • Blog Post: Drinking the Champagne – SQL Server 2012 on Windows Server 8

    Dogfood is the commonly described term for running your own beta software, however I prefer the term drinking your own champagne and to that end I have spent  a days leave today playing Window Server 8 .   Yes its very different to what you have seen before and rather like having the decorators...
  • Blog Post: System Center Advisor– now live

    I remember hearing about a Project Houston about a year ago, a cunning plan to allow Microsoft to check the heath of your SQL Server databases and the operating system it sits on. It is now live and it’s called System Center Advisor . It works by using an internet gateway server you setup which in turn...
  • Blog Post: Application Platform Knowledge Hub

    Albert Einstein once remarked that you don’t need to remember everything, you just needed to remember where to look.  When it comes to learning about Microsoft products this can sometimes be harder than it ought to be and what resources there are can be fragmented so you do have to remember where...
  • Blog Post: What’s good in SQL Server 2012 Integration Services

    This is a guest post by Allan Mitchell MVP, and one of the top speakers at SQL Bits   The launch of SQL Server 2012 is not too far away and the SQL Server team have been hard at work adding new functionality and also improving upon existing features.  I am lucky enough to have been working...
  • Blog Post: DTS RIP

    Data Transformation Services is the bit of SQL Server that helped pay for my house, car and some really nice holidays.  I first got to use it some 12 years ago and after working with BCP (bulk copy program) it was just so easy, I was sucking data out of AS400/RPG, Oracle and Sybase to create data...
  • Blog Post: Some SQL Server 2012 upgrade advice for ISVs

    I have spent a lot if time recently briefing Independent Software Vendors (ISVs) on SQL Server 2012,so I thought a consolidated post on the subject might be useful for those planning to develop solutions on top of SQL Server 2012. New Features that will just work By this I mean there are some new...
  • Blog Post: NO SQL Server

    I spent last Thursday at Black Marble’s Architect Forum and my slot was on SQL, NoSQL, some SQL. It went down very well but I used OneNote on my tablet not PowerPoint and like all modern art my drawing needs a bit of explaining.. Databases were originally used to  store transactions which are highly...
  • Blog Post: SQL Server 2012 – TSQL

    I have to confess I hadn’t paid too much attention to the changes to T-SQL in SQL Server 2012, and it was only a question at NextGenUG in Abingdon last night that prompted me to have a look.  It turns out there are some really useful new commands , which I could certainly have done with when I was...
  • Blog Post: SQL Server 2012 – Always On

    There have always been several ways to do high availability in SQL Server, but choosing the right one has always been difficult as each approach has obvious benefits coupled with unavoidable limitations: Clustering looks after a whole instance of SQL Server containing many databases and is completely...
  • Blog Post: SQL Server 2012 editions and dependencies

    You may have seen that there are going to be some changes to the way SQL Server 2012 is licensed and the editions available, if you haven’t then the detail is here . What I want to cover off in this post is what the various new features depend on so you are clear on what else you need besides the...
  • Blog Post: SQL Server 2012 and the private cloud

    Putting up a marketing slide that says SQL Server is a good private cloud citizen is good marketing, but what’s in the box to back the claim up? My top three would be: Windows Server core .  Patching is a major maintenance problem with lots of virtual machines, and server core cuts that in half...
  • Blog Post: SQL Relay

    I am in the middle of SQL relay this week, but I just realised that you might like to have a copy of my Denali slide deck, which I have now posted to SkyDrive . You are welcome to have a look at it even if you couldn’t make one of the four venues I am presenting at this week, but there isn’t a lot of...
  • Blog Post: SQL Bits 11 - Notes & Queries

    If you didn’t manage to fight your fight your way through the Everton & Liverpool fans to SQL Bits I thought you might like to see some of the random questions I got asked.. How do I manage SQL Azure? I think the key thing about developing for the cloud is to ensure that your application can handle...
  • Blog Post: SQL Server sprawl

    Normally the term sprawl carries an implied criticism, in the case of SQL server that DBAs have lost control of their infrastructure and users are install it willy nilly without regard for data protection or disaster recovery.  However when it comes to SQL Server user group meeting then sprawl is...
  • Blog Post: Beyond Relational– Semantic Search with SQL Server FileTable

    Semantic Search new for SQL Server Denali adds extra intelligence to the FullText search capability that has existed in SQL Server for several releases, by looking at the relationships between words and in and across each document.  For example you can find which documents are similar to a specified...
  • Blog Post: Beyond Relational– FullText indexing with SQL Server FileTable

    In my part 3 of my series on FileTable I wanted to search the documents I had saved in parts 1 & 2. This is pretty straightforward, as Full text indexing has been in several versions of SQL Server and is SQL Server 2008 R2 the FullText indexes are part of the databases they refer to.  What caught...
  • Blog Post: Beyond Relational - Working with SQL Server FileTable

    In my last post I setup FileTable in SQL Server Denali, and now I ma ready to start using it. Just to recap before I do that FileTable is a way of storing files in what appears to be a normal set of folders under a UNC share but in such a way that  these files are under the control of SQL Server...
  • Blog Post: Beyond Relational - Installing SQL Server FileTable

    A long time ago in a land far far away, somebody had the bright idea of using a database as part of a file system and the Windows Future System (WinFS) was born – but this is not that story.  However the idea and some of the team moved to the SQL Server engineering team and FileStream was the result...
  • Blog Post: SQL Server Reporting Services–if it’s important look after it

    Before I can commit funds to a new project be it at work or at home I need to know I can afford it; specifically is there enough money in the budget and to find that out I need to run a report.  This is what’s meant by operational reporting and this distinction means that this report can be considered...
  • Blog Post: Installing Denali ctp3–how hard can it be

    l forget sometimes that installing SQL Server isn’t that straightforward, in part because it is now so much more than the database engine, that was SQL Server 7 when I started.  I also think its important that you understand the choices you are making when installing it although many of these can...
Page 1 of 2 (40 items) 12