Friday, 12 December 2014

SQL Bits – Europe’s largest SQL Conference

4th 7th March
ExCeL Centre in London, England

SQLBits have announced their dates for 2015.
I have been three times and it is an excellent opportunity to learn and meet fellow DBAs and developers.
This year it has expanded to FOUR days, two training days featuring industry experts and two technical session days. Saturday as normal is a free day.
If your company’s training budget is limited next year then SQLBits offers the best value for money. Tell your boss that you’re giving up a Saturday to go to the free day and he might be sympathetic to pay for one or more of the other days.

Lots of people have submitted talks for the technical sessions and this year I’ve put my hat in the ring as well.
I’ve submitted three sessions:
A real DBA don’t need a GUI -A Guided Tour of SSMS
Beware of the Dark Side - A Tour of Oracle for the SQL DBA
Taming the Beast - How a DBA can keep Kerberos under control

I’ve given the first two at SQL Saturday events and they were received well by the audience.
You can vote for the sessions you’d like to hear at http://sqlbits.com/information/PublicSessions.aspx

If you do vote, remember me !

David

Thursday, 12 June 2014

Win a Free Copy of my Book - Getting Started with SQL Server 2014 Administration

Readers of my blog would be pleased to know that I have teamed up with Packt Publishing and we are organizing a Giveaway for you to celebrate the release of my book and two lucky winners stand a chance to win an e-copy of Getting Started with SQL Server 2014 Administration. Keep reading to find out how you can be one of the Lucky Winners.

Overview of Getting Started with SQL Server 2014 Administration

image

  • Learn to design a SQL Server infrastructure combining on-premise servers and Windows Azure Storage.
  • Learn the other enhancements and new features that can help improve database performance

Read more about this book and download free Sample Chapter:


http://www.packtpub.com/getting-started-with-sql-server-2014-administration/book

 

How to Enter?


All you need to do is head on over to the http://www.packtpub.com/getting-started-with-sql-server-2014-administration/book and look through the product description of this book and drop a line via the comments below to let us know what interests you the most about this book. It’s that simple!

Product description for Getting Started with SQL Server 2014 Administration http://www.packtpub.com/getting-started-with-sql-server-2014-administration/book
Deadline:
The contest will close on 30/06/2014. Winners will be contacted by email, so be sure to use your real email address when you comment!

Wednesday, 7 May 2014

I’ve Written a Book…Getting Started with SQL Server 2014 Administration

That’s folks you heard it here first. Since the end of 2013 through to April this year I have been working a book called “Getting Started with SQL Server 2014 Administration” the book is pretty much a look at the new features that would interest the DBA working with the latest and greatest version of SQL Server 2014.It got released last week at the end of April/

Getting Started with SQL Server 2014 Administration

You can get it from the publisher and all the leading book websites. I haven’t seen it in Waterstones yet but I’m hopeful. The rumors of orderly queue forming out the Waterstone’s in Newport the night before its release had no foundation. Apparently there was just a long queue for the night-club next door.

Anyway you can pick your copy here

Thursday, 24 April 2014

SSMS Add-ons

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.

SSMS is a fantastic tool but many people and companies have found ways to enhance it to make it even more useful.
At the Exeter SQL Saturday I was chatting with David Atkinson of Red Gate software about their add-ons to SSMS.

David told me about an exciting project that Red Gate have started called the SSMS Ecosystem Project. They have created a framework to make it easier for developers and DBAs to develop, share and manage SSMS add-ons.
And the best news is that this framework is free.

Once you’ve created your add-in using the framework you can place it on their add-in directory so others can find and try it out. Red Gate are happy for you to use their API to create commercial tools as well as free ones.
Red Gate consider this to be a work in progress, they intend to enhance their API and hope to create a distribution platform similar to the Visual Studio gallery where you will be able to discover and share your add-ons.

Check it out at http://www.red-gate.com/ssmsecosystem

We also came up with quite a list of add-ons which are available on the Internet, some free and some commercial

http://www.red-gate.com/
Red Gate’s own set of tools: SQL Search, SQL Source Control, SQL Prompt, SQL Test

http://www.devart.com/dbforge/sql/sqlcomplete/
SQL Code formatter

http://www.sqlcodeguard.com
Provides fast and comprehensive static analysis for T-Sql code, shows code complexity and objects dependencies. (Now using SSMS Ecosystem Project)

http://www.ssmsboost.com
A set of productivity tools to speed-up daily tasks of SQL DBA and T-SQL developers.

http://www.supratimas.com
Adds a tab next to the SSMS Plan Explorer with its own improved version
It also has a browser-based analysis tool for SQL Server query execution plans.

http://www.ssmstoolspack.com/
by Mladen Prajdić A whole list of useful features to improve productivity

http://www.sqlsentry.net/plan-explorer
A SQL Server Query Plan Analysis tool

SQL Scripts
http://www.sqlservercentral.com/Scripts/
This brings thousands of useful community SQL scripts to SSMS.

SQL Treeo
http://www.sqltreeo.com/wp/
Enables users to create custom folders for databases, stored procedures, tables, views and user defined functions
This is not an exhaustive list. I expect there are plenty of other tools available. Let us know if you have a favourite

Wednesday, 23 April 2014

SSMS Queries on Function Keys

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.

If you have simple queries or functions that you use regularly you can assign them to a function key for quick running in a query window

Microsoft have already added a few
If you hit  Ctrl-1 in a query window it runs sp_who
The results are displayed in the results window but the query window doesn’t display the query which can be a bit confusing.

You can set your own up at
Tools ->Options -> Environment -> keyboard -> Query Shortcuts

You’ll see there are already three already listed

Alt-F1    sp_help
Ctrl-1    sp_who
Ctrl-2    sp_lock

The function key Alt-F1 can be very useful.
In a query window type in the name of a system stored procedure such as sp_MSforeachdb
Now highlight the word and hit Alt-F1
The results window will show information on the stored procedure and also the parameters used by the procedure. Very handy.

As well as complete queries you can add partial statements to a function key.
Let me explain
Add the statement  “Select top 100 * from” to Ctrl-4

You must restart SSMS before the function key will work
Now open query Window

Type in the name of a table in the query window.
Now highlight the table name and hit Ctrl-4
The partial query will use the highlighted table name and run the full select query.

Tuesday, 22 April 2014

SQL Server Training – Spring 2014

I have just returned from a trip to Washington DC where I was delivering course 2105 – SQL Server 2012 DBA skills upgrade class in an onsite class to one of Learning Tree’s clients. For those of you that don’t know, a Learning Tree onsite is event is when Learning Tree come to you and deliver a course at your site just for you  and can even be tailored or customized to your specific requirements. You can follow the link to read more information about onsite events and what they can include.

SQL Server 2012 Database Administration

This spring I will be delivering two public courses that are scheduled to run in the London Education Centre (LEC)

Both of these events are guaranteed to run, so you can enroll safe in the knowledge that the course will not cancel. Maybe I’ll see you in-class

Monday, 21 April 2014

Central Management Studio CMS

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.

One of the subjects I covered was Registered Servers and the Central Management Studio
These are two features in SSMS that allow you to register your SQL instances with a more meaningful name and then group them into folders such as project name or type.
This can make it much easier to find the instances used by a particular project especially for new starters who won’t know the names of all the instances and projects in your company.
The CMS can be shared by all of your DBAs or developers so there is one central list of instances and what they are used for.

One additional feature is the ability to run queries against multiple instances. You simply right click on a particular folder and select “New Query”. A new query window will open with a pink footer showing connected (x/x), where x is the number of instances in the folder.
Any query run in this window will execute on every instance in that particular folder.
If you select the CMS server itself you can run a query on every instance you have registered

A great feature you may think but what if you accidently ran this in a multi server query window?

exec sp_msforeachdb 'drop database [?];'

Since writing my presentation I have come across a DBA team that aren’t allowed to use the CMS because of the danger of accidently running a dangerous multi server query on every instance in the company.

I’ve hunted high and low but can’t find anyway of disabling the multi query option in SSMS so if you are not willing to risk it then the usefulness of the CMS will not be available to your team.

What do other think?
Does your company use the CMS?
Are the benefits of the CMS worth the risk of someone accidently running a dangerous multi server query?
Have you found a way of disabling the multi server query option?

Let me know?