tag:blogger.com,1999:blog-23185093957447970922024-09-17T22:51:24.018+01:00fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.comBlogger91125tag:blogger.com,1999:blog-2318509395744797092.post-34172575219652033352010-07-11T16:51:00.001+01:002010-07-11T16:51:28.320+01:00

Well, someone, from somewhere in Egypt (according to Google's assessment of the IP location) got into my GMail account. Thanks for that, I didnt have anything else planned for today so have spent hours changing passwords and contacting people to apologise for sending them links to Canadian Pharmacy websites. Just in case you have any similar unfortunate experience here some basic instructions/

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-50841995858982790022010-05-23T11:38:00.001+01:002010-05-23T11:38:22.554+01:00

We feeds the birds from a bird feeder in our garden, just outside the kitchen window. We get Sparrows, Chaffinches, Blue Tits, Great Tits, Starlings, Blackbirds and occasionally Woodpeckers. Now we have for some time wondered at the way that when stocks run low we get Sparrows and Blue Tits on the window sill, tapping at the window. We are not sure whether they are just finding amusement at their

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com1tag:blogger.com,1999:blog-2318509395744797092.post-26756167275595864782010-05-21T21:59:00.001+01:002010-05-21T21:59:00.686+01:00

Do you write a blog, have you ever thought about it? I think people fall into one of a few categories when it comes to blogs, especially blogs with technical content. Writing articles furiously – daily, twice daily and reading dozens of others. Writing the odd piece of content and read plenty of others’ output. Started a blog once and its fizzled out but reading lots. Thought

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com1tag:blogger.com,1999:blog-2318509395744797092.post-31785967628882951642010-05-15T08:30:00.001+01:002010-05-15T08:41:24.947+01:00

Well, it was really windy and a little rainy at times but I had the camera out for a good while. Sadly the wind put and end to many close-ups of the birds as it was blowing me on my feet but here is one that I am pleased with. I know the horizon wasnt that sloping but its a symptom of trying to pan with the bird in the middle of a blowy day on the top of a cliff. No apologies :).

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-51676077992875413322010-05-13T09:07:00.000+01:002010-05-13T09:07:35.290+01:00

I have the great pleasure (and no small amount of anxiety if I am completely open about it) to announce that I have been invited to syndicate this blog with Simple-Talk (www.simple-talk.com). This is a brilliant opportunity for me to connect with so many more people in the world of SQL Server than via this site so I truly hope I am good enough to produce suitable quantity and quality to match the

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com1tag:blogger.com,1999:blog-2318509395744797092.post-32983138898724339832010-04-26T19:50:00.000+01:002010-04-26T19:50:42.641+01:00

SQL Server Execution Plans by Grant Fritchey Query Execution Plans are something that a DBA or TSQL developer will get to encounter pretty soon after starting to work with SQL Server. They are found in a number of guises - graphical, text or even XML. In either format they are a daunting array of information that seems really important but also pretty complex and technical. With Grant's book by

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-70972253564986928072010-04-18T23:12:00.000+01:002010-04-18T23:12:09.949+01:00

Date: Friday 16th April 2010 Location: Church House Westminster Event: SQLBits VI Having been to one SQLBits previously I was very keen to get registered and attend this event. This time I was accompanied by my wife (she's also a DBA/Developer so it wasn't a case of having to fund a shopping trip too!) and travelling from Devon meant that we stayed over in London for the previous night. The

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-70856401425004206452010-04-09T19:34:00.001+01:002010-04-10T11:05:07.974+01:00

If you work with software and databases then it wont be long before you encounter  problems connecting to SQL server (or any other data source) and there are often many reasons why you would be presented with  problems. A good way of starting to analyse your problems with no need for any specific software on a  PC is to use a UDL file. Create a new text file on the desktop of the

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com1tag:blogger.com,1999:blog-2318509395744797092.post-21368315625238298282010-03-27T13:28:00.003+00:002010-03-28T10:45:12.671+01:00

I am now getting into my stride on upgrading to SQL 2008. We have a reasonably compact environment here with only a handful of production servers. We use mirroring and replication in places and we have a couple of report servers to keep the data flowing to the users. I have just moved a database that has a gang of reports pointing to it and have been going through the directory settings for

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-13675728248517690262010-03-09T15:40:00.001+00:002010-03-09T15:41:05.588+00:00

I am in the middle of a SQL Server 2008 installation and today I needed to transfer the Mail Accounts and Profiles to the new instance in order to be ready for use by the incoming system. I never been a fan of the GUI to configure Mail on SQL 2005 as it involves a lot of back and forth clicking to get everything done. I decided to take a look at what PowerShell would let me do. After getting

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-16289413478827217812010-03-08T14:29:00.000+00:002010-03-08T14:29:05.423+00:00

That doesn't sound right does it? If something is free it doesn't cost anything and if you have lots of those things they all cost the same - right? Well, not entirely. Let me explain in a little more detail. I am learning PowerShell as you may well know if you have seen any other of my recent blog items and so am looking around the internet to find code samples and try out different methods of

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-56126066037191109862010-03-04T10:06:00.001+00:002010-03-04T11:15:40.642+00:00

Right, I'm progressing with PowerShell a little at a time. I still dont have any books but whenever I need to reference SQL information (not data, I am only getting info on Server settings not accessing customer database data) I try the PS route first. In order to connect to a SQL Server from the command line you need to add two PS snapins. To do that you issue the commands add-PSSnapin

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-3698054004079807422010-03-03T15:19:00.004+00:002010-03-03T16:32:33.121+00:00

I have a number of SQL Servers to upgrade from 2005 to 2008 this year and as service pack 1 is already out it makes sense to install this at the same time as the main software. In Microsoft parlance this is known as 'slipstreaming'. In theory it involves getting the set up files for SQL Server 2008 and applying the service pack to them rather than to the installed software. Its covered on an

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-41151452719639197352010-03-02T09:56:00.000+00:002010-03-02T09:56:32.562+00:00

That's the title for the latest book from Brad McGehee and Simple Talk Publishing. Its available from Amazon here. ISBN 978-906434-34-2 Price:GBP19.99 / USD29.99 / CAN35.99 This book will enable any person responsible for data stored in a SQL Server database to ensure it is being managed to a required minimum with a small amount of effort and possibly limited experience. This is not a book long

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-54262481087883043112010-02-28T16:16:00.002+00:002010-02-28T20:56:38.667+00:00

OK, I've just a minute to put this up but I have used PowerShell to help someone with a problem. It wasnt the only way and may not have been the simplest way but it certainly work. A question was posted on www.ServerFault.com asking "How can I tell if Snapshot Isolation is turned on?", my reaction was to see if PowerShell could tell me what the Snapshot Isolation setting was on my SQL databases.

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-84200350685534012192010-02-26T14:35:00.004+00:002010-02-26T14:58:45.139+00:00

So I asked this question on ask.sqlservercentral.com/questions and the concensus of opinion seems to be that PowerShell should be in my future. I have a few books that I am deciding between but have downloaded some eBooks and have installed some new applications. It was a real hassle getting PSv2 installed as it seems to conflict with PSv1. I have downloaded PowerShell Analyzer from Shell Tools

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-65039716987805962582010-02-22T09:22:00.005+00:002010-02-22T09:51:20.542+00:00

That's the heading of a little box on my LinkedIn page (www.linkedin.com), if you have never heard of LinkedIn before, its like Facebook for business people, but with fewer photos.Now lots of 'social networking' sites have a way of finding other people you know that you havent yet connected with. It makes sense, the more contacts you have on thier site the more traffic will increase as there is

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-90816454992051809742010-02-08T21:49:00.007+00:002010-02-09T08:52:34.641+00:00

Behind every database there are database files, traditionally they are denoted by one of 3 file extensions - mdf is the main data file, ldf is the main log file and ndf is used for any additional log files. one mdf and one ldf are a minimum requirement for a SQL Server database.These files are locked by SQL Server when it is running, thus ensuring that the only updates go through the database

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-11903263868019051992010-01-21T19:35:00.007+00:002010-01-21T20:51:08.315+00:00

This post is a slight departure from the normal content and its part of what might be considered a challenge from the blog at http://thesqlagentman.com/2010/01/whose-blog-is-it-anyway/I woke on Sunday morning in a panic, you know the way, it's like you accelerate from 0 to 100 mph in 2s, slowly the bedroom materialised around me. I made a mental note not to read my twitter feed just before going

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-34937732438165127392010-01-18T21:04:00.003+00:002010-03-20T11:47:47.672+00:00

SSMS Templates The management tools that come with SQL Server are the way that most DBAs access and administer their database environment. SSMS has plenty of shortcuts and times saving features, one of which is the use T-SQL templates. SSMS templates are accessed via their own menu and are stored in folders just like you would access files on a windows explorer window. SSMS comes with a whole

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com1tag:blogger.com,1999:blog-2318509395744797092.post-12091783971006678342009-12-10T09:29:00.004+00:002009-12-10T10:02:31.123+00:00

There are loads of great scripts out there on other blogs and elsewhere that help you administer your database and run a tight ship but a lot dont show how to account for the database schema, its not uncommon to have everything in the dbo schema but there are lots of databases I manage that also have objects in other schemas and there are a couple of extra steps to take to get a funky new admin

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-88686340020506422482009-11-22T09:53:00.006+00:002009-11-22T16:08:05.468+00:00

OK, so I couldnt get to any of SQLBits other than the free Saturday, yup, they do a whole day for free. All you need do is register in time at www.sqlbits.com and then turn up. This is the fifth happening and was held at the Celtic Manor Hotel, Newport, Wales. A very impressive hotel with plenty of staff keeping all of the debris that 300+ DBAs generate while they eat bacon/egg/sausage baps, tea/

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com1tag:blogger.com,1999:blog-2318509395744797092.post-77706324096232520352009-11-19T20:50:00.006+00:002009-11-20T08:58:51.430+00:00

The scenario: We have an application server (iis) that is running slowly, the database shows no signs of stress so I want to review the web server application log to see if there are any entries that show any clues as to the issue. Easy, grab the data from the event log and quickly analyse the results; what sort of event, how many of them, when do they occur??I have two options immediately in my

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com1tag:blogger.com,1999:blog-2318509395744797092.post-16956491647154545592009-11-09T09:39:00.000+00:002009-11-09T09:39:19.316+00:00

Extracted from http://bradmcgehee.com/2009/11/give-sql-server-2008-r2-ctp-a-quick-try-for-free/Give SQL Server 2008 R2 CTP a Quick Try for Free: "You have probably heard that the SQL Server 2008 R2 CTP is available, but you may not have given it a try yet because it is such a pain to download the huge install file, find a test server to run it on, and then install it. Under the best of conditions

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0tag:blogger.com,1999:blog-2318509395744797092.post-56628752814814720232009-11-04T22:44:00.002+00:002009-11-04T22:48:28.652+00:00

I have recently had reason to review the indexing of a table as a query was taking a lot longer to run than I would have expected. My first move was to check out the estimated execution plan for the SQL that the view was based on. It turns out that a large chunk of effort in the query was running an index scan on a table that had 3 indexes. . The indexes details were: a primary key (unique,

fatherjackhttp://www.blogger.com/profile/08189614498927797936noreply@blogger.com0