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

Latest Blog Posts

Where are my 32-bit Perfmon Counters?

I have run into this before, but not in this same way, so I decided it would be worth writing about.

On a client server they are running 32-bit SQL Server 2005 (I know, not supported - that's a different rant/post) on a 64-bit Windows 2008 installation.  When I logged…

Read more

0 comments, 37 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 April 2014

Learn High Availability and Disaster Recovery with SQL Server in a Day!

If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00 PM (EDT) 

Do you need to build a High Availability (HA) and/or Disaster Recovery (DR) strategy for SQL Server Databases? If so, you will no doubt have questions like: Read more

0 comments, 45 reads

Posted in John Sterrett on 23 April 2014

Azure Automation

I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.

There’s a set of documentation available as I noted before. Unfortunately, reading through the full set of documentation, I have some criticisms to offer. The layout of the documentation goes through “Common runbook tasks”… Read more

0 comments, 43 reads

Posted in The Scary DBA on 23 April 2014

Collation: Confusion

I started reading about collations after I had a recent run in with them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

In Europe, Canada and… Read more

0 comments, 47 reads

Posted in SQLStudies on 23 April 2014

Practical Data Migration Strategies

Practical Data Migration Strategies

As organizations mature their IT infrastructure must change to keep up with new applications and technologies. Many times this includes moving data housed in one technology (legacy) to the upgraded or new platform that is being implemented. Depending upon what you are trying to accomplish there… Read more

0 comments, 59 reads

Posted in Business Intelligence and Enterprise Architecture on 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…

Read more

0 comments, 54 reads

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

SQLSaturday #305 Dallas Business Analytics Edition

I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There are a number of sessions I want to attend including Eric Mezell’s An Introduction to Hadoop, Andy Egger’s Applied Predictive Analytics, David Browne on Enterprise Business Intelligence (for lunch) and… Read more

0 comments, 37 reads

Posted in The Smiling DBA on 23 April 2014

Real heavyweights: Float vs Decimal, the Thrilla in Precision

This is a followup to a previous post where I likened SQL Server float datatype to Muhammad Ali. Specifically, I wanted to address the phrase "negligible data storage increase" to the test for different numeric data types.

In short, I will dismiss the notion that float provides a realistic advantage in…

Read more

0 comments, 49 reads

Posted in SQL Tact on 23 April 2014

Come see me present SQL Saturday Atlanta

Have you seen the schedule for SQL Saturday #285 – Atlanta?   Holy cow they have jam packed too many hard decisions into that schedule.    I’ll be presenting Maintenance and Backups: Intro to Ola Hallengren bright and early at 8:15 in the Admin Room, aka Room 3.   Luckily for everyone… Read more

2 comments, 57 reads

Posted in Jason Carter on 22 April 2014

The Powershell Challenge Update

I’ve fallen down on my challenge over the last month. It’s been a content time, with me working more towards presentations and writing most of Mar and April to meet deadlines and commitments. I also let my calendar reminder die in Feb and didn’t renew it.

As a result, here… Read more

1 comments, 63 reads

Posted in The Voice of the DBA on 22 April 2014

2014 SQL Server Editions – Overview

2014 is the latest edition of SQL Server available[/caption]

SQL Server 2014 was officially released in April 1st, 2014. You can download the 120 day Enterprise edition trial version here:

As with previous version of SQL server, there are three primary editions of SQL Server 2014 available.

Enterprise Edition

Read more

1 comments, 85 reads

Posted in WaterOx SQL on 22 April 2014

Mr. Carter, Where Did You Go?

It has been nearly a month since your last blog post Mr. Carter, and frankly your last post was nothing more than a list of things you did in Madison.  What gives?  Where are you?  What is so important that you must leave with such reckless abandon as to not… Read more

0 comments, 62 reads

Posted in Jason Carter on 22 April 2014

Last Weeks Top “Reading” Links #80

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

0 comments, 50 reads

Posted in StrateSQL on 22 April 2014

Understanding the Three A’s of Security for SQL Server

Do you know what the “Three A’s of Security” are and how they apply to Microsoft SQL Server? Let’s look at them as they are important for managing security properly on a given Microsoft SQL Server.


Authentication is determining who a person/process is.

When a connection is made, it’s… Read more

0 comments, 85 reads

Posted in Databases – Infrastructure – Security on 22 April 2014

Blogging-Write More

Blogging isn’t easy. You have to come up with a topic, write about it, and then release it for the world to see. That’s three kinds of pressure. Now most of us don’t have hundreds or thousands of readers, but the pressure is still there, and it can lead to… Read more

3 comments, 60 reads

Posted in SQLAndy on 22 April 2014

I Am Better Than You

That is a patently false statement and total BS. It sure does crawl up your spine though doesn’t it? Why then do we need to do this?

I read an article, “How DevOps is Killing the Developer,” and, frankly, was a little put off by this:

Good developers…

Read more

10 comments, 84 reads

Posted in The Scary DBA on 22 April 2014

SQL Server Internals Presentation Double Time!

I’ll be doing double time over the next two weeks with Two Presentations on SQL Server Internals. It is essentially just a repeat of the same presentation but with two chances to attend :) Here are the details of the timings for both presentations: April 29th @ 12 Noon EST…

Read more

0 comments, 104 reads

Posted in - Ayman El-Ghazali on 22 April 2014

How to install SQL Server Failover Cluster from SQL Server 2008 onwards ?

Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :-

1) Open SQL Server Installation Center > Go to Installation from Left > Click on New SQL Server Failover installation from right

2) Click RUN to start setup

3) Click ok after validation check. In case of… Read more

0 comments, 46 reads

Posted in MSSQLFUN on 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… Read more

0 comments, 53 reads

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

Webinar – Easy SQL Server Benchmarking

On Thursday, May 1st, I will be presenting a new webcast with Tegile Systems entitled “Easy SQL Server Benchmarking”.

Abstract: Do you have a new piece of hardware going into service and want to see how well it performs? Or do you have a few systems and want to… Read more

0 comments, 116 reads

Posted in Technobabble by Klee from @kleegeek on 21 April 2014

Older posts