Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Decree: Set your partition offset and block size – make SQL Server faster

If I’ve said it once, I’ve said it 1,024 times: your SQL data and log drives need a 1024 KB starting offset, and a 64 KB block size*. Your SQL data and log drives need a 1024 KB starting offset, and a 64 KB block size. If you read this…

Read more

3 comments, 127 reads

Posted in SQL Awesomesauce on 7 April 2014

SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio

By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database, system tables/views/procedures and so on.

SQL Server Management Studio provides an option to hide these objects from Object Explorer to prevent *accidental* use.

To enable this option follow below steps. Read more

0 comments, 1,344 reads

Posted in SQL and Me on 7 April 2014


The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML. In a previous blog I showed how to use a web service task to get the city and state when entering a zip code.

The results we got back from…

Read more

0 comments, 1,176 reads

Posted in Mike Davis SQL on 7 April 2014

Help! I'm stuck in Single User Mode and can't get out!

So, here’s a silly little take on a serious end-user issue where no-one could access the production database.

Got a call from a client recently.  Like something out of a LifeAlert® commercial: “Help! I'm stuck in single user mode and can't get out! “ 

I figured this… Read more

9 comments, 1,712 reads

Posted in Pearl Knows on 7 April 2014

I'm Speaking at SQL Saturday Houston, May 10th.

I will be speaking at my first SQL Saturday. I'll be in Houston May 10th. I'm rather surprised to be honest. No, I don't have that sinking feeling that my presentation isn't good enough or that I'll show up at the event in my underwear with everyone laughing... those fears…

Read more

2 comments, 77 reads

Posted in DBA On The Go on 7 April 2014

SQL Saturday Exeter

A couple weeks back was the second SQL Saturday to be held in Exeter. Although I wasn’t speaking this time, my friend, colleague and fellow contributor to this blog, David Postlethwaite was making his full speaking debut delivering a session entitle “Real DBAs Don’t need a GUI” it was a… Read more

0 comments, 75 reads

Posted in The SQL DBA in the UK on 7 April 2014

Decode SQL Server Job Schedules

As once a data architect, I cannot help but admiring and appreciating the data model behind the sql server job schedules. The core design is actually just one table, msdb.dbo.sysschedules, but the design beauty/elegance of the table is that it can support many different types of schedule with a rich… Read more

0 comments, 105 reads

Posted in DBA Philosophy on 7 April 2014

SQL Server Filtered Index

What is a SQL Server Filtered Index

A SQL Server Filtered index is a nonclustered indexes that can be used to increase query performance when selecting records from a table.  This type of index can be especially useful when there are a small count of  distinct values in a column… Read more

0 comments, 132 reads

Posted in Business Intelligence and Enterprise Architecture on 5 April 2014

New Extended Events for Tracing in SQL Server 2014

Neue “Erweiterte Ereignisse” (XEvents) für Tracing in SQL Server 2014

Dieser Artikel enthält eine Liste der neuen Erweiterte Ereignisse (“Extended Events”), dem Tracing Framework in SQL Server in dem neuen 2014 Release.

Zunächst gibt es 3 neue Pakete („Packages“), die alle zu der neuen Arbeitsspeicher(„In-Memory“) -OLTP Engine: XTP, aufgeteilt…

Read more

Changing SQL Server Agent Jobs Ownership: Who should own SQL Server Agent Jobs

I writing this blog post as a result of the following two questions, which I’ve been asked by one of my blog follower recently.

  • Question#1: Does it matter who is the owner of the SQL Server Agent job?
  • Question#2: Is there a way to quickly update the job owner for…

Read more

0 comments, 149 reads

Posted in Basit's SQL Server Tips on 4 April 2014

Don’t Be an Arse

In deference to my British employers, I’ll use their word.

It constantly strikes me how rude, stupid, and unfriendly people can be on the Internet. I’ve been trying to avoid even reading comments on many places, including Facebook because I’m struck by how people behave. I haven’t completely succeeded and… Read more

0 comments, 110 reads

Posted in The Voice of the DBA on 4 April 2014

Great Companies – Spotify

I don’t know anyone at Spotify, nor have I worked there. However when I see descriptions and explanations like this one of how they organize and build their culture, it makes me think they’re doing it right.

Autonomy is important, and it helps motivate people. I need to do more… Read more

0 comments, 92 reads

Posted in The Voice of the DBA on 4 April 2014

Data Collector in SQLServer 2014 – What’s New !

Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting up Data Collector in SQL2014. In the walk-through if there is a new feature or change which is specific to SQL2014,then I will highlight that.

As soon… Read more

0 comments, 1,243 reads

Posted in on 4 April 2014

Monthly Reflections – March 2014

After a bit of an enforced sabbatical from blogging (short but boring story), I was interested to see how my blog had fared over the last month in essentially what was a re-launch. The list below is one of popular posts rather than a top N format due to the… Read more

0 comments, 80 reads

Posted in Richard Douglas on 4 April 2014

Using BMC Control-M to Automate Tasks

My largest client recently purchased BMC Control-M to use as our enterprise scheduler. Since this product went live in our environment I have been watching it displace other schedulers to become the centralized scheduler.  As I have learned more about the capabilities of Control-M as well as becoming more alert… Read more

5 comments, 874 reads

Posted in Tim Radney - Database Professional on 4 April 2014

Speaker of the Month, April 2014

I’m really enjoying picking a speaker of the month. It forces me to sit through a lot more sessions at the events I attend. I had been getting rather slack about attending sessions. It’s easy to get caught up in networking so much that you’re not taking advantage of the… Read more

4 comments, 463 reads

Posted in The Scary DBA on 4 April 2014

Follow Up To A Questionable Trigger

This question of the day didn’t turn out well at all – required too big a leap the way it was written to get to the key answer. Four were easy, one was not. I confused the issue with a less than great trigger – not deliberately, sadly. The lesson… Read more

0 comments, 60 reads

Posted in SQLAndy on 4 April 2014

SQLServerCentral Editorial: Team Reputation

Maybe too serious a topic for a Friday, I wrote Team Reputation because I like working for good teams – who doesn’t? Most teams are average and that’s ok, but it’s a lot more fun to be part of the big red machine if you get the chance (and have… Read more

0 comments, 62 reads

Posted in SQLAndy on 4 April 2014

Friday Followup For April 4, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • The Phoenix Project: a DBA rises from the ashes
  • Automated Permissions Auditing With Powershell and T-SQL: Part 1

Read more

0 comments, 65 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 4 April 2014

Analyzing CXPACKET waits

One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.

This wait type is usually at the top of the list when you query the sys.dm_os_wait_stats on servers where you configured the MDOP setting to be anything but ‘1’. CXPACKET waits…

Read more

0 comments, 1,547 reads

Posted in DotNine SQL Server and more on 4 April 2014

Newer posts

Older posts