SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2014

Speaking on Standardize SQL Server Implementations (Dev to Prod)

In this session Prakash will walk through the process he has implemented to alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production.

Read more

0 comments, 1,077 reads

Posted in SQLFeatures on 31 October 2014

Reblog: October 24 to October 30

Photo credit – Mike Lynch

A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time, I’m… Read more

0 comments, 959 reads

Posted in StrateSQL on 31 October 2014

Tales from the Query Processor III

Hello Dear Reader!  It’s that time of year again.  The leaves are turning, temperatures are changing, and Halloween is once again upon us.  Today is Halloween, time to take the kiddos out to Trick-or-Treat!  Today is also my daughter’s 16th birthday!  It’s hard to believe that it has…

Read more

1 comments, 1,155 reads

Posted in SQLBalls on 31 October 2014

It’s That Time Again

“It’s the most wonderful time of the year…”

No, not the end-of-year festival of repetitive music, overeating, and trampling on other people to find that perfect gift.  No, it’s time again for the PASS Summit, the annual gathering of SQL Server and data professionals from around the world.  The… Read more

1 comments, 1,009 reads

Posted in Tim Mitchell on 31 October 2014

Changing Your SQL Server Name

Is the name of your SQL Server correct?

Why Worry About The Server Name In SQL?

When the name of the actual host machine’s server name does not match the server name stored in SQL Server a lot of things can start to go wrong.

Reporting services can break, Connections… Read more

5 comments, 1,600 reads

Posted in WaterOx SQL on 31 October 2014

Changing Your SQL Server Name

Reading Time: 2 minutes

Is the name of your SQL Server correct?

Why Worry About The Server Name In SQL?

When the name of the actual host machine’s server name does not match the server name stored in SQL Server a lot of things can start to go wrong.

Reporting… Read more

5 comments, 987 reads

Posted in WaterOx SQL on 31 October 2014

Summit and something new…

Let me just say, I’m excited.


First of all, can you believe that the PASS Summit is next week?  Next. Week.

Are you ready…

  • to have your brain explode from all the SQL learnin’?
  • to reconnect with your SQL Family?
  • to add new members to that family?


Personally,… Read more

1 comments, 864 reads

Posted in Cleveland DBA on 31 October 2014

I Won’t Be At the PASS Summit This Year

Due to a minor health issue I’ve decided to – for once – be conservative and cancel the trip this year. I’ve attended every year since 2002 and it feels strange to not go. I’m sure you’ll understand it’s the people I’ll miss far more than the presentations. My friend… Read more

0 comments, 1,252 reads

Posted in SQLAndy on 31 October 2014

Friday Followup For October 31, 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
  • What Are Your Servers Doing While You’re Sleeping?
  • Do…

Read more

0 comments, 840 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 31 October 2014

How to take Transaction Log backup ? TIP# 68


As we discussed in earlier tips how to take full backup and differential backup now in this tip we will see how to take transaction backup .

Before taking transaction backup the first and mandatory condition is that you should have a full backup.

Just right click the database… Read more

0 comments, 858 reads

Posted in Rajat Jaiswal-337252 on 30 October 2014

How to Configure Search in SharePoint 2013 || Configure Search Topology in SharePoint 2013

Hello Friends,

I was getting lot of responses on blogs and mails. It will be difficult to cover all at once . So covering today the latest one “How to Configure Search in SharePoint 2013” and in Standalone server.

Microsoft is focusing more and more on Power Shell and this…

Read more

10 comments, 1,328 reads

Posted in AshishSharePointBlog on 30 October 2014

SQL Pass Summit 2014

Next week I will be in Seattle for the 2014 SQL Pass Summit event.  If you are involved in projects that leverage the Microsoft SQL Server stack this is a great conference to attend. If this is your first time going and would like some tips on making the most… Read more

0 comments, 1,129 reads

Posted in Business Intelligence and Enterprise Architecture on 30 October 2014

Sort – Is it Really a Blocking Iterator?

SQL Server has two types of execution plan iterators: Blocking and Non-Blocking.

A non-blocking iterator gets rows in and sends rows out at the same time. For instance, the Nested Loops iterator gets rows from its outer input and sends the matching rows on to the next iterator without having… Read more

2 comments, 1,281 reads

Posted in Matan Yungman on 30 October 2014

Quick Schema Auditing

I was working on a demo recently and needed to show that a little monitoring can help you catch schema changes. At first I looked at SQL Audit and DDL Triggers, but then I ran across a short custom metric on the SQL Monitor Metrics site that my company, Red… Read more

2 comments, 1,104 reads

Posted in The Voice of the DBA on 29 October 2014

SQLSaturday Tampa Announced For February 28, 2015

SQLSaturday Tampa is the first SQLSaturday in Florida for 2015, scheduled for February 28th, 2015. The event is held at the USF College of Business Bldg, 12212 USF Maple Drive, Tampa, FL 33620. Easy to find, free parking, lots of hotel options near by. The weather at the end of… Read more

0 comments, 1,241 reads

Posted in SQLAndy on 29 October 2014

Headed to the PASS Summit 2014

I can hardly believe how fast this year has flown by. My favorite SQL Server conference of the year, the PASS Summit, is just next week! I can hardly wait! This conference is one of the largest SQL Server and BI conferences of the year, planned and coordinated by… Read more

1 comments, 1,007 reads

Posted in Technobabble by Klee from @kleegeek on 29 October 2014

PASS Summit 2014

Well, it is that time of year again. The Professional Associations for SQL Server (PASS) annual summit. This year we go back to Seattle where Microsoft mostly lives and hope we can get lots of their employees to visit and talk shop.

One of my main goals is to Network… Read more

0 comments, 1,227 reads

Posted in The Smiling DBA on 29 October 2014

Managing Geeks – A journey of leading by doing

I am proud to share that my good friend Andy Leonard has just released a new book. This is also the second book published by LinchpinPress.

Over the years Andy has blogged about his experiences with managing technical teams. Andy wrote over 50 post on the subject and has… Read more

1 comments, 1,842 reads

Posted in Tim Radney - Database Professional on 29 October 2014

SQL Server 2014 Backup and Recovery

In early October my third book was published. I have been blessed to be able to work with Joes2Pros for my first two books, however Joes2Pros is focusing its time and energy into video content. When SQL 2014 was released and new features were added for backups, there was a… Read more

2 comments, 1,841 reads

Posted in Tim Radney - Database Professional on 29 October 2014

Playing with the log – Before the first full backup

The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the effect of VLF size on shrinking the log. So the other day I was asking about VLFs and got sent to this great video of a recorded session from… Read more

1 comments, 1,781 reads

Posted in SQLStudies on 29 October 2014

Older posts