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

Latest Blog Posts

Reblog: November 14 to November 20

Photo credit – JStove

Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no such things as unicorns, so I can… Read more

1 comments, 62 reads

Posted in StrateSQL on 21 November 2014

Have We Devalued SQL Server Consulting?

Have we given too much away?

SQL Server has an amazing community. It freely provides information and training of SQL Server technologies via the internet and even in person events like SQL Saturday’s.

Has the value of SQL Server Consulting Diminished?

This is fantastic for anyone who works in SQL… Read more

1 comments, 77 reads

Posted in WaterOx SQL on 21 November 2014

Friday Followup For November 21, 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

  • Using Encryption To Protect Your Data From Alien Abduction
  • Building (for FREE) a Virtual Server for SQL Demos

Read more

0 comments, 63 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 21 November 2014

In-memory OLTP Part 1: Introduction to In-memory OLTP

SQL Server 2014 introduced probably one of the biggest changes to the SQL Server engine since years, “In-memory OLTP” (or Hekaton). In-memory OLTP lets you move tables from your traditional, disk based, storage and moves them directly into the memory (RAM) of your SQL Server instance. Traditional storage throughput and… Read more

0 comments, 109 reads

Posted in DotNine SQL Server and more on 21 November 2014

Encryption in Colorado Springs – Encrypting in the Application?

Last night was my annual presentation at the Colorado Springs SQL Server User Group. I try to make sure I get down there at least once a year, and it’s been only once a year for the last few years. Far too busy, and I’m sorry for that, but I… Read more

0 comments, 127 reads

Posted in The Voice of the DBA on 20 November 2014

The Truth About Index Fragmentation

In just a little while, I’m going to give a presentation at the PASS Performance Virtual Chapter. You can download the materials from my presentation here:

The post The Truth About Index Fragmentation appeared first on .

Read more

2 comments, 94 reads

Posted in Noam Brezis on 20 November 2014

Exam Prep 70-463: More about Dimensions

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Today we’re going to review dimension tables in more depth.… Read more

0 comments, 410 reads

Posted in Cleveland DBA on 20 November 2014

FUD Makes Security Harder

The US government’s illogical screeds against better personal encryption for data and communications is well documented. Then comes this reported communication:

Department of Justice: iPhone encryption will lead to the death of a child

I’m hoping the quote given in the article is completely out of context. However, previous statements,… Read more

0 comments, 69 reads

Posted in Databases – Infrastructure – Security on 20 November 2014

Nominated for Author of the Year

I have the great pleasure to announce that I have been nominated for the “Author of the Year” award at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post

You can vote for me at the following URL:

Note… Read more

1 comments, 51 reads

Posted in Koen Verbeeck on 20 November 2014

Practical Problems with CI

I agree. Continuous Integration has issues in the real world, at least it probably does in many companies. The more tests you have, the more likely you refactoring or changes will break something. The more things break, the more people will look to leave them alone, deferring the "fix"… Read more

2 comments, 108 reads

Posted in The Voice of the DBA on 20 November 2014

SQL Konference 2015

My first speaking date of the new year is scheduled. I’ll be at the SQL Server Konference 2015, near Frankfurt, Germany. Red Gate arranged things, and I’m looking forward to heading over and renting a car to drive in Germany.

And speaking, of course.

I don’t know the agenda… Read more

0 comments, 113 reads

Posted in The Voice of the DBA on 19 November 2014

T-SQL Tricks – Custom Templates

I wrote about the Template Explorer, which comes with the SQL Server tools and is visible in Management Studio (SSMS). It’s handy, but there are limited code items in there. What if I want more?

That’s easy. Suppose I decide that I often need to create procedures with the EXECUTE… Read more

0 comments, 138 reads

Posted in The Voice of the DBA on 19 November 2014

Fast Track Data Warehouse Reference Architecture for SQL Server 2014

I have previously blogged about the Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference Architecture and Appliances).  That was version 3.0 of the reference configuration that was for SQL Server 2008 R2.  Released a couple of years ago was version 4.0… Read more

1 comments, 93 reads

Posted in James Serra's Blog on 19 November 2014

You don’t really need ORDER BY do you?

You see dozens of blog posts and articles about how the order of a result set is not guaranteed without an ORDER BY clause and here is my contribution to the subject.

You all know I love examples so without further ado here we go:

Using data from AdventureWorks2014


Read more

1 comments, 460 reads

Posted in SQLStudies on 19 November 2014

SOA and message based integration - the challenge of bulk data changes

I'm working on problems of enterprise data integration in the role of enterprise architect, but I am and have been a SQL person for 15 years, so it may be that I look at this topic with considerations that don't get much attention more widely.

So, enterprise data integration! Or…

Read more

0 comments, 130 reads

Posted in Don Halloran on 19 November 2014

Changing Delay Between Responses for SQL Alerts with Powershell

So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on or maybe you have used sp_blitz and received the Blitz Result: No SQL Server Agent Alerts Configured and like a good and conscientious DBA you have set them up. Read more

0 comments, 75 reads

Posted in SQL DBA With A Beard on 18 November 2014

More on that Cyberwar

As a follow-up to my post on being at war, cyberwar:

State Department Hacked

If the experts are correct, this trend is only going to continue. Reading the article and others on the same situation, they all note that the unclassified email had been hacked, but not classified. That’s… Read more

0 comments, 127 reads

Posted in Databases – Infrastructure – Security on 18 November 2014

What Are You Thankful For

Bob Pusateri (B | T) wrote a blog post yesterday for anyone who was interested on sharing what they were thankful for to write a blog post and link back to his. With Thanksgiving on the way the picture is painted perfectly; I can hear now as family… Read more

1 comments, 69 reads

Posted in The SQL Professor on 18 November 2014

Community is Everything

I don’t care what technology or technologies you enjoy using in your daily job. If there’s an enthusiastic community behind it, you need to become part of it. Your job and career will be better as a result.

I’ll start this personal post with a mixed tale from my childhood.… Read more

0 comments, 78 reads

Posted in Technobabble by Klee from @kleegeek on 18 November 2014

2014 PASS Summit 2014 Board Q&A Notes

As has occurred in previous years at the PASS Summit the PASS Board of Directors held an open Q&A session on the final day. I was able to attend most of the session but had to leave a few minutes early for my scheduled presentation. I didn't count but estimate… Read more

0 comments, 84 reads

Posted in Kendal Van Dyke on 17 November 2014

Older posts