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

Archives: November 2014

Video articles

While thinking of ways to improve the way I can get SQL Server information across to those who follow my blog or read my articles, I came up with a new feature: video articles!

Reading an article on the internet is a great way to learn, but viewing or listening… Read more

0 comments, 932 reads

Posted in DotNine SQL Server and more on 30 November 2014

Giving away FREE Access to my SQL Server High Availability and Disaster Recovery Deep Dive Course – Round 2

Originally posted on - Microsoft technologies and what I do for fun -:
Last year, as part of launching my very first online course, I gave away FREE access to my SQL Server High Availability and Disaster Recovery Deep Dive Course. I’m doing it again this year but with…

Read more

0 comments, 1,116 reads

Posted in Coffee and SQL on 29 November 2014

Outlier Detection with SQL Server, part 3.1: Grubbs’ Test

By Steve Bolton

…………In the last two installments of this series of amateur self-tutorials, I mentioned that the various means of detecting outliers with SQL Server might best be explained as a function of the uses cases, the context determined by the questions one chooses to ask of the… Read more

2 comments, 10,578 reads

Posted in Multidimensional Mayhem on 29 November 2014

Virtualization Virtual Chapter Webinar – Open Q&A

On December 10 at 11am CST I will be presenting the next PASS Virtualization Virtual Chapter monthly webinar, where you can ask me any of the burning questions about virtualized SQL Server that you’ve been just itching to ask! It’s an open questions and answers session. Please submit your questions… Read more

1 comments, 915 reads

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

Me and You or Me versus You


Have you ever had to deal with a manager or co-worker who made your working life uncomfortable or even miserable? That’s one of the most difficult and emotionally taxing situations for adults all over the world. Each night, after a hard day of dealing with these people, IT pros… Read more

0 comments, 1,747 reads

Posted in Kevin E. Kline on 28 November 2014

Reblog: November 21 to November 27

Photo credit – Jenn and Tony Bot

Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s blog posts that came… Read more

0 comments, 1,002 reads

Posted in StrateSQL on 28 November 2014

DBTA – For #SQLFamily, It’s the Most Wonderful Time of the Year!

It’s the holiday season, a time for cheer and goodwill towards men. That got me thinking about the whole “most wonderful time of the year” tune playing in the background and how that has some special implications for the SQL Server world. Here’s a bit of context: I’m writing this… Read more

0 comments, 1,110 reads

Posted in Kevin E. Kline on 28 November 2014

Friday Followup For November 28, 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
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed…

Read more

0 comments, 921 reads

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

Setting up WebStorm to debug grunt with TypeScript

It’s possible to use the WebStorm editor to debug grunt tasks if you are using TypeScript and generating .map files.  Assuming that grunt is already launching from the command line, here’s how to step into the debugger:
  • Open your project’s folder in WebStorm.
  • Click Run… Edit Configurations…
  • Add a new…

Read more

0 comments, 1,560 reads

Posted in New York City .NET on 28 November 2014

SQL Server - Clustered Indexes and Non Clustered Indexes

To understand the concept of Clustered and Non Clustered indexes, it is important to understand the definition and functionalities of indexes first. An Index is a structure related to a view or table that speeds up the processes by quick retrieval of integrated rows from view or table.

There are…

Read more

1 comments, 1,757 reads

Posted in on 28 November 2014

Beware the defaults! (in windowing functions) – The Movie!

I was recently contacted by the fine gents of Webucator, an online training services provider. In order to promote their SQL Server classes, they are doing a free series called SQL Server Solutions from the Web where they show different SQL Server solutions found in blog posts around… Read more

4 comments, 1,039 reads

Posted in Koen Verbeeck on 27 November 2014

Parameterization Part 6: Simple vs. Forced Parameterization

This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan caching works in SQL Server, what parameter sniffing is, when it’s good and when it’s bad, and also some common mistakes related to parameterization and how to avoid them.

In… Read more

0 comments, 4,131 reads

Posted in Guy Glantser on 27 November 2014

Audit Database File Size Changes

Recently I shared an article on how to track the growths and shrinks that occur within database files.  I shared that article here, you should read it before proceeding with today’s article.

Near the end of that article I declared that it was a really good method to track… Read more

4 comments, 1,969 reads

Posted in SQL RNNR on 26 November 2014

When the Problem is Not Them. It’s You.

Hello Dear Reader!  I’ve been the Data Platform Management Lead at Pragmatic Works for almost two years now.  It’s been an interesting journey that I’m enjoying.  I’m the tier 3 support in a lot of cases, play the role of manager, mentor, and fellow fighter in the trenches when required. …

Read more

0 comments, 1,225 reads

Posted in SQLBalls on 26 November 2014

What is Azure Data Factory?

The Azure Data Factory is a service designed to allow developers to integrate disparate data sources.  It is a platform somewhat like SSIS in the cloud to manage the data you have both on-prem and in the cloud.

It provides access to on-premises data in SQL Server and cloud data… Read more

4 comments, 1,993 reads

Posted in James Serra's Blog on 26 November 2014

SQL Saturday Parma – English Slide decks available to download

My SQL Saturday Parma slide decks are available to download on SlideShare.

The main topic of those presentations is database lifecycle management (DLM) on SQL Server.
Concepts: ALM/DLM, team work, differences between code and databases.
We’ve demonstrated the usage of…

Read more

0 comments, 0 reads

Posted in Alessandro Alpi on 26 November 2014

How to burn down your house while frying a turkey

It’s an odd query, yes, but in preparation to write this post I actually typed the above phrase into my browser.  No, I’m certainly not looking to burn down my house.  In fact, wait here while I clear my search history, just in case.

For the sake of argument, let’s… Read more

5 comments, 1,227 reads

Posted in Tim Mitchell on 26 November 2014

Who’s on call

Kenneth Fisher:

I really enjoyed writing this post last year and honestly still enjoy reading it myself. And since tomorrow is a holiday for a lot of people (I’m in America so I get to make that assumption) it seemed like a good time to bring it out again.…

Read more

0 comments, 1,032 reads

Posted in SQLStudies on 26 November 2014

PASS Summit 2014 ~ My GameTime Experience

“How did you like your convention?”

“How was your trip?”

“What did you learn?”

“Where did you go for a week?”

“Who did you meet?”

“Talk with the vendors?”

“What is PASS Summit?”

Those are the types of questions I received after arriving back from attending PASS Summit 2014.… Read more

0 comments, 1,507 reads

Posted in The SQL Professor on 25 November 2014

SQL Saturday NYC

I excited to say that PASS SQL Saturday NYC is back on the schedule and will be May 30, 2015 at the Microsoft Times Square office.  It is something that we have been talking about for some time now at the NJSSUG.  It took some time to get the… Read more

0 comments, 981 reads

Posted in Another SQL Geek on 25 November 2014

Older posts