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

Archives: November 2014

SQLSaturday Returns to NYC 2015!

November 25, 2014 - Good news in Gotham!  Well you asked for it! You wanted it! You waited for it! And now it's finally here! It gives me great pleasure to announce the return of SQL Saturday to New York City! Save the date, May 30, 2015! Just…

Read more

0 comments, 1,372 reads

Posted in Pearl Knows on 25 November 2014

Placeholders for Emergencies

A long time ago I worked in a large corporation where we managed lots of servers, each of which performed a variety of different functions. Some were Exchange, some SQL, some file servers, etc. and they would come and go at a frightening pace.

We had monitoring in place, but… Read more

7 comments, 6,650 reads

Posted in The Voice of the DBA on 24 November 2014

Capturing DB Usage stats – sp_spaceused simulation using DMV’s.

SP_SPACEUSED

sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters or no parameters. The objective of this stored proc is to measure the amount of space consumed by database… Read more

2 comments, 6,473 reads

Posted in PowerSQL By Prashanth Jayaram on 24 November 2014

Last Weeks Top “Reading” Links #110

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

0 comments, 683 reads

Posted in StrateSQL on 24 November 2014

Exam Prep 70-463: Just the facts, ma’am

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 exploring fact tables… Read more

5 comments, 7,817 reads

Posted in Cleveland DBA on 24 November 2014

TempDB Configuration Best Practices

1. Do not change collation of TempDB from the SQL Server instance collation.

2. Do not change the TempDB database owner from sa.

3. Do not drop the TempDB database.

4. Do not drop or revoke the guest user from the database.

5. Do not change the recovery model from… Read more

1 comments, 1,256 reads

Posted in MSSQLFUN on 24 November 2014

Cumulative Update – 13 for SQL Server 2012 Service Pack 1 Is Now Available !

The 13th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 13 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 563 reads

Posted in MSSQLFUN on 24 November 2014

Cumulative Update – 3 for SQL Server 2012 Service Pack 2 Is Now Available !

The 3rdcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2012 SP2.

Those who are facing severe issues with their environment, they can plan… Read more

0 comments, 791 reads

Posted in MSSQLFUN on 24 November 2014

DBTA – Mission Critical Performance Enhancements in SQL Server 2014

 

Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performance.”  Microsoft wants to stake out this ground not only as performance enhancements in the relational engine, but also those features which support better data availability, performance, security, and… Read more

0 comments, 516 reads

Posted in Kevin E. Kline on 24 November 2014

Putting sp_ at the beginning of your stored procedure.

Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So what does that do and why should we care? The primary effect is that if you put a stored procedure starting with sp_ in master you can call it directly… Read more

1 comments, 855 reads

Posted in SQLStudies on 24 November 2014

A look at the SQL Assessment Intelligence Pack in Operational Insights

Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate and visualize all your machine data in one place. It can collect data from all of your machines either via SCOM or by using an agent. Once the data is… Read more

4 comments, 6,475 reads

Posted in SQL DBA With A Beard on 24 November 2014

SQLSaturday Speaking & Sharing

Recently, I caught a blog link on LinkedIn, of one SQL Server professional talking about his experience speaking at a SQLSaturday, and I thought I would not only share my own experience, but invite all of you who ever spoke at a SQLSaturday to share yours as well.  In…

Read more

0 comments, 748 reads

Posted in Pearl Knows on 24 November 2014

Clustered Columnstore Indexes – part 44 (“Monitoring with Extended Events”)

Continuation from the previous 43 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/

This post is dedicated to the monitoring aspects of the Columnstore Indexes, which should help you understanding what is going on with your production system.

Columnstore Monitoring Options

First of all we have all normally useful DMV’s that are useful for… Read more

0 comments, 291 reads

Posted in Niko's blog on 23 November 2014

NJSSUG SSIS Performance Tuning

On November 18, 2014 I had presented to the New Jersey SQL Server User Group (NJSSUG) on SSIS Performance Tuning.   As promised I wanted to make available the demos

Here is a link to the zip file containing the slide deck and demos.  Download here


Read more

0 comments, 316 reads

Posted in Another SQL Geek on 21 November 2014

Put Your New Leadership Knowledge Into Practice

Have you ever tried to hit a golf ball toward the pin, toss a dart at the bull’s-eye, or chuck a fly at a trout? If you’re like most people, your first attempt didn’t come anywhere close to hitting the mark. Your golf ball may have found the woods, your… Read more

1 comments, 525 reads

Posted in Kevin E. Kline on 21 November 2014

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

0 comments, 634 reads

Posted in StrateSQL on 21 November 2014

SQLSaturday Austin

I was pleased to get the email yesterday confirming that I was selected to speak at SQLSaturday #362 on January 31, 2015. I think the last time I was in Austin was 2004 or so when I was at Dell for a week for SAN and cluster training. It was… Read more

0 comments, 504 reads

Posted in SQLAndy on 21 November 2014

Have We Devalued SQL Server Consulting?

Reading Time: 3 minutes

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… Read more

1 comments, 258 reads

Posted in WaterOx SQL 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, 524 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, 388 reads

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

Newer posts

Older posts