Category Archives: SQL Server

SQL Server

SQL Server – Run Scheduled Scripts without SQL Agent

Posted on April 5, 2011 by

Here’s a really useful article on how to schedule backups and to run SQL scripts without using SQL Agent. http://www.diaryofaninja.com/blog/2011/02/14/howto-quick-amp-dirty-sql-express-scheduled-backup This is particularly relevant for SQL Server Express installations where agent isn’t available. The pertinent part of this is using … Continue reading →

Posted in SQL Server | Leave a comment

SQL Server full text indexing using Adobe PDF iFilter 9, SQL Server 2008 R2 64bit

Posted on December 2, 2010 by

The full text indexing service in SQL Server allows PDF files to be indexed and allows you to perform full text searches against the contents of PDF files stored in binary fields. The prerequisite for making this work is the … Continue reading →

Posted in SQL 2008 R2 | 3 Comments

Cannot generate SSPI Context error from SQL Server Management Studio

Posted on August 26, 2010 by

This is an error that I’ve seen on various occasions when connecting to SQL Server using integrated security. I recently came across this problem when attempting to connect to SQL Server 2005 from Management Studio. Connections to the server had … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Reinstalling system databases in SQL Server using setup.exe

Posted on August 17, 2010 by

Having worked with SQL Server for several years, it’s surprising that I’ve never encountered this particular problem before (a corruption of one of the SQL Server system databases). I recently came across an instance of SQL Server 2005 that wouldn’t … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Reporting Services talk at SQL Server User Group

Posted on June 27, 2010 by

At the SQL Sever user group in Reading this week, I gave a presentation on Reporting Services. I met a great bunch of attendees and there were some very interesting questions raised at the session. The first one was a … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Introducing Microsoft SQL Server 2008 R2 eBook

Posted on May 20, 2010 by

Here’s a link to a free SQL Server 2008 R2 book from the Microsoft website. http://download.microsoft.com/download/C/D/1/CD1648C1-46BC-4C79-B16F-7AF650C186B4/693883ebook.pdf

Posted in SQL 2008 R2 | Leave a comment

How to use Database Compression in SQL 2008

Posted on September 10, 2008 by

One of the new features in SQL Server 2008 is the ability to compress the data in your database. I’ve recently been investigating this feature and here are some of my notes on the topic. There are 2 different types … Continue reading →

Posted in SQL Server 2008 | Leave a comment

SQL User Group in Milton Keynes

Posted on August 26, 2008 by

For anyone in the Milton Keynes area, Simon Sabin is holding his first user group in this region on Thursday (26 Aug 2008).   More details are here:   http://sqlserverfaq.com/events/128/Milton-Keynes-SQL-2008-for-Developers-CTEs-and-Recursion.aspx  

Posted in SQL Server | Leave a comment

SQL 2008 beta exams now available (70-450/70-452)

Posted on August 17, 2008 by

The Beta SQL 2008 MCTS exams are now available.  You can take them for free by registering through Prometric/Vue and entering the following promotional codes:   71-452: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008 – Promotional Code: 3568C 71-450: PRO: … Continue reading →

Posted in SQL Server | Leave a comment

Report Designer Preview in SQL 2008 Nov CTP

Posted on December 6, 2007 by

SQL Server 2008 includes many enhancements in the reporting space and the latest CTP contains an updated preview of the ‘Microsoft Report Designer’. The purpose of this is to provide an easy to use report authoring tool which is suitable for an end … Continue reading →

Posted in SQL Server | Leave a comment