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

Latest Blog Posts

Sharing a Good Idea

I posted earlier about my experiments with Microsoft Curah!. (yes, technically the period should follow the exclamation since the exclamation is part of the name, not the end of the sentence) Evidently people actually read this blog because it inspired Stephen Bennet to start putting together his own curations… Read more

0 comments, 75 reads

Posted in The Scary DBA on 14 April 2014

MidnightDBA at SQL Saturday Houston – May 10

Sean and I will be speaking at SQL Saturday Houston on May 10, at San Jacinto College – South Campus 13735 Beamer Rd. Building 12 Houston, TX 77089 We have three sessions between the two of us: T-SQL Code Sins, Jen DBA Career Roadmap, Sean and Jen DIY Performance Reporting,…

Read more

0 comments, 106 reads

Posted in SQL Awesomesauce on 14 April 2014

Collation: Correction -> Instance

I had a recent run in with collation problems and it got me started reading about 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.

You’ve… Read more

0 comments, 68 reads

Posted in SQLStudies on 14 April 2014

SQL Server – Different Ways to Check Object Definition

sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various database objects like Views, Stored Procedures and User Defined Functions.

There are two other options which can be used to retrieve object definition:

OBJECT_DEFINITION( object_id ) – is a built-in… Read more

0 comments, 87 reads

Posted in SQL and Me on 14 April 2014

5 Years Running! OKCSQL!

I want to congratulate OKCSQL on a 5 year run. 

I personally wasn't here for that whole duration, but we have leaders and members that have been. We’re still growing and have plenty of room for new members. We have an awesome group! We have some fantastic sponsors even. GDH

Read more

0 comments, 69 reads

Posted in DBA On The Go on 14 April 2014

Missing Database Owner

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.

A scenario
A DBA creates a new database and by doing so he become the owner of…

Read more

0 comments, 84 reads

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

Hortonworks Data Platform 2.1 New Features

What is Hortonworks Data Platform

Hortonworks recently announced their release of the HDP 2.1 their Hadoop Big Data platform.  If you have not tried it yet and are interested in how to get started with Big Data.  Now is the time learn Hadoop.

In this release there are 5 new… Read more

1 comments, 110 reads

Posted in Business Intelligence and Enterprise Architecture on 13 April 2014

Using the T-SQL MERGE Statement

In SQL Server 2008, Microsoft added a new SQL query type: the MERGE statement. This flexible query provides the ability to perform INSERTs, UPDATEs and even DELETEs all within a single statement. Used in combination with Common Table Expressions (CTEs), this can be a powerful tool to replace multiple… Read more

0 comments, 181 reads

Posted in DwainCSQL on 13 April 2014

Reblog: April 4 to April 10

Photo credit – Husso

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this… Read more

0 comments, 63 reads

Posted in StrateSQL on 11 April 2014

An Open Letter to Brogrammers

It’s not in the language I would write it in and it’s not necessarily safe for work, but it gets the point across.

An Open Letter to Brogrammers

One reason I do support Women in Technology, and other groups opposing discrimination. Apart from it’s poor behavior, it’s often just not… Read more

0 comments, 128 reads

Posted in The Voice of the DBA on 11 April 2014

Simple And Amusing Question Of The Day

I was working on a script today to check the range of some values and trying to take the time to handle edge cases, even though I don’t expect them (edge cases!) and ran across something I knew but hadn’t thought about. Good fodder for a question, but not a… Read more

0 comments, 76 reads

Posted in SQLAndy on 11 April 2014

Quarterly Goals

Over time I’ve settled on quarterly goals as the best way to focus on the stuff I most want to get done. I still think about my long term goals and I still have to do short term planning, but quarterly goals work out to be the most useful measure… Read more

0 comments, 80 reads

Posted in SQLAndy on 11 April 2014

Friday Followup For April 11, 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

  • Why So Serious? – #TSQL2sDAY #53
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Do You Need A Log…

Read more

0 comments, 75 reads

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

Call for Speakers – SQLSaturday #324 Baton Rouge

Baton Rouge is now on its 6th SQLSaturday and the event grows year after year. It all started with Patrick LeBlanc back in 2009 with #17 and with help from local User Groups (William AssafSparkhound), it has expanded its topics and attendees. This event is… Read more

0 comments, 72 reads

Posted in The Smiling DBA on 11 April 2014

First Birthday to My Blog

Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over the internet and reading blogs of many wonderful brains made me think about creating a blog.

When I wrote my first post a year ago I wondered and asked… Read more

0 comments, 69 reads

Posted in PowerSQL By Prashanth Jayaram on 10 April 2014

Heartbleed bug: immediate security threat for both IT, and consumer sites and services

“An encryption flaw called the Heartbleed bug is already being called one of the biggest security threats the Internet has ever seen. The bug has affected many popular websites and services — ones you might use every day, like Gmail and Facebook,” says this Mashable article. This thing MUST be…

Read more

0 comments, 237 reads

Posted in SQL Awesomesauce on 10 April 2014

Webcast Follow-Up: Introduction to Columnstore Indexes

Similar to yesterday’s post, I have a follow-up for another Pragmatic Works Training on the T’s session that I delivered last month.  This was is titled Introduction to Columnstore Indexes.  In the session, I discussed columnstore indexes and the value that they provide in SQL Server, both in 2012… Read more

1 comments, 92 reads

Posted in StrateSQL on 10 April 2014

Smart Moves with SQL Server VMs – Data Movement

Today marks another installment in my ‘Smart Moves with SQL Server VMs’ blog post series. Today we are going to help stretch the minds a bit farther and talk about another way to help SQL Server DBAs move large quantities of data between VMs in an extremely rapid manner. 

Last… Read more

0 comments, 132 reads

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

I’m a Traveling Man

We are coming into quite a busy time for my speaking schedule. I’m hitting the road. It does one thing for me that I truly love, I get to talk to people. So, if you have questions, want to chat, need to call me a pompous know-it-all to my face,… Read more

0 comments, 85 reads

Posted in The Scary DBA on 10 April 2014

Collation: Correction -> Expression, Column, Database

I had a recent run in with collation problems and it got me started reading about 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.

You’ve… Read more

0 comments, 87 reads

Posted in SQLStudies on 10 April 2014

Newer posts

Older posts