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

Latest Blog Posts

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, 76 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, 104 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, 71 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, 173 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, 50 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, 37 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, 76 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, 95 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, 116 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, 74 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

0 comments, 246 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, 63 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, 64 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, 120 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, 59 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, 70 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, 76 reads

Posted in Kendal Van Dyke on 17 November 2014

Vital Statistics and Health Checks

This post has nothing, absolutely nothing, to do with SQL Server. It does, however, relate to your career as a deskbound, stressed-out IT professional. With that disclaimer out of the way, you may continue reading if you’d like.

A couple of things happened in the past week that led to… Read more

0 comments, 79 reads

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

Use -eq in Powershell

I was writing a quick script to work with files and I only wanted to process one file for each execution of a loop. I could have done this multiple ways, but I threw this together:

$fileEntries = [IO.Directory]::GetFiles(“d:\placeholder”);
$delete = 1;
foreach($fileName in $fileEntries)
if ($delete = 1)
Read more

0 comments, 122 reads

Posted in The Voice of the DBA on 17 November 2014

Quickly Add Telnet

Have you found yourself on a server or workstation that doesn't have telnet, and need it to test port connectivity? Did you receive this error when you tried to execute telnet in cmdshell or powershell?

telnet : The term 'telnet' is not recognized as the name of a cmdlet, function,…

Read more

0 comments, 69 reads

Posted in SQL Tact on 17 November 2014

Older posts