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

Archives: June 2013

Reblog: June 21 to June 27

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 1,165 reads

Posted in StrateSQL on 28 June 2013

SQL 2014 CTP1, where is my BIDS?

Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI solutions, Microsoft has changed its name a few times. You know, to make it less confusing. Here’s a nice overview:

  • BIDS or Business Intelligence Development Studio. The most non-confusing name…

Read more

10 comments, 4,476 reads

Posted in Koen Verbeeck on 28 June 2013

SQL Server – Understanding ‘sp_spaceused’ Results for Database Size Information

From a recent conversation with a customer, I noticed even some of the experienced DBAs are not very clear about the terms “unallocated space” and “unused space” and by doing a quick Bing search, found there are many SQL friends out there trying to get a clear correlation between these…

Read more

10 comments, 1,604 reads

Posted in SqlServerZest.com - SQL in simple style on 28 June 2013

SQL Server: Part 2 : All About SQL Server Statistics :Histogram

In the Part 1 about SQL server Statistics, we have discussed about density vector information stored in the the statistics. In this post, let us discuss about the histogram. Let us create a copy of SalesOrderDetail table and two indexes on top of that as we did in our first…

Read more

20 comments, 10,110 reads

Posted in PracticalSQLDba on 27 June 2013

PowerSQL – Different Approaches to Find Free Space in all disk drives

Different ways to find FreeSpace  in all disk drives of a given server

  • T-SQL
  • Using WMIObject
  • Counters

All three methods are explained below

This post illustrates the simplest way of doing anything with ease using Powershell. I hope everyone agree with it.

Download the code here Code- DiskSpaceUsageDetails


TSQL Read more

0 comments, 1,487 reads

Posted in PowerSQL By Prashanth Jayaram on 27 June 2013

Visual Studio 2013 preview available

Wow, Visual Studio 2012 is just out of diapers and here comes the next version!

Microsoft officials released the preview of Visual Studio 2013 at the Microsoft Build 2013 developer conference on June 26 (along with TFS 2013).  Download here.  Meanwhile, many of the new hybrid application lifecycle management… Read more

0 comments, 1,601 reads

Posted in James Serra's Blog on 27 June 2013

SQL Server Installation Date

I have been working on a project recently to collect system metrics of a SQL Server environment. One of the items that came up that would like to collected is the date that SQL Server was installed on the server.  In doing a quick search on where this property would… Read more

1 comments, 1,280 reads

Posted in Tim Radney - Database Professional on 27 June 2013

SQL Server Society of Las Vegas presents HealthySQL - Webinar! Tonite!

Hey, all!  

Today, going on all day, is the Summer Performance Palooza 2013, hosted by the PASS Performance Virtual Chapter.  It is a virtual parade of SQL Server webinars and super speakers delivering terrific tele-training into your living room, or whereever you are.  Check out the link for on-going… Read more

0 comments, 1,686 reads

Posted in Pearl Knows on 27 June 2013

Natural Born Killers (The series) – Day 8 Parameter Sniffing

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL Server blog title and to be fair it is.

Those who do know me, will know that I have been presenting a session this year titled “Natural Born Killers, performance… Read more

0 comments, 1,910 reads

Posted in Richard Douglas on 27 June 2013

5 community stored procedures you need for your servers

We’re blessed in the SQL Server community that there are so many people willing to share work they have done for the benefit of others. I’ve collated five scripts that have really helped me out over the years by some of the best in the business, enjoy…

Paul Randal –…

Read more

0 comments, 4,008 reads

Posted in Richard Douglas on 27 June 2013

Improved Temp Table Caching in SQL Server 2014

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Under some preconditions SQL Server is able to cache Temp Tables. Caching Temp Tables means that SQL Server doesn’t have to recreate them, when you are creating the same Temp Table… Read more

1 comments, 3,027 reads

Posted in Klaus Aschenbrenner on 27 June 2013

Ohio Business Intelligence Road Trip 2013

Next month Mike Davis and myself will be making a epic road trip.  We will be flying into Columbus, OH to deliver a two day (7/16 – 7/17) workshop on advanced Reporting Services techniques.  We will then pack up and drive to Cleveland, OH for another two day (7/18-7/19) workshop… Read more

0 comments, 1,616 reads

Posted in Devin Knight on 27 June 2013

Indexing Fundamentals Presentation

**This Session has been rescheduled for July 10th @ Noon EST (16:00 UTC)** On July 10th 2013 @ Noon EST (16:00 UTC) I will be giving a presentation with the Professional Association for SQL Server (PASS) DBA Fundamentals Virtual Chapter. Entrance is free as always and details can be found…

Read more

1 comments, 1,234 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 26 June 2013

Visiting Atlantis

This week I got to visit Atlantis. Not the mythical island, but rather the ship, the Space Shuttle Atlantis at Kennedy Space Center. The visit was part of my summer vacation, spoiling myself by doing something with my family almost every day. The official ‘launch’ of the exhibit is… Read more

0 comments, 1,340 reads

Posted in SQLAndy on 26 June 2013

Checkout SQL Server 2014 CTP1 and Windows 2012 R2 preview up in the cloud

You must be really busy spinning up VMs to test SQL Server 2014 CTP1 and Windows Server 2012 R2 preview.

If your on-premise desktop computer/laptop is running low on resources and if you don’t want to take the pain of handling multiple VMs locally,then you have an option to test… Read more

2 comments, 1,596 reads

Posted in SQLSailor.com on 26 June 2013

SQL Server: Identifying Edition Specifc features Used in a Database

I had a situation which forced me to do a feasibility study to move SQL server 2008 enterprise edition environment to standard edition. It is hard to check is there any edition specific features are implemented in any of the databases. It will be more complex process if the environment contain many…

Read more

6 comments, 1,628 reads

Posted in PracticalSQLDba on 26 June 2013

SSWUG Summer Camp

I'm speaking at SSWUG Summer Camp!  Thankfully, I can be at home, in my pool AND be at summer camp (oh, how I love modern technology!).  If you have the time, come listen to me blather on about SSIS.  http://www.sswug.org/vc Read more

0 comments, 902 reads

Posted in SQLRunner on 26 June 2013

PASS Nominating Committee for 2013 Elections Announced

I was pleased to see the email this morning announcing that community volunteers Erin Stellato, Ryan Adams, and Tamera Clark will be joining Board members Sri Sridharan and Rushabh Mehta for the 2013 Nominating Committee. More information on the election site. 

The work of the NomCom is not glamorous… Read more

0 comments, 1,238 reads

Posted in SQLAndy on 26 June 2013

Using OUTPUT to back up a change

How will you back out if your change doesn’t work?! Always take a backup! There should always be a back out script to go with any change script! These are things that have been drilled into me time and time again. Sometimes by management, sometimes by bitter experience. If I’m… Read more

2 comments, 2,412 reads

Posted in SQLStudies on 26 June 2013

Oracle and Microsoft are in the Cloud Together

What an interesting week this has been. On Monday Microsoft and Oracle announced a partnership that rocked the cloud world. Oracle will certify its software to run fully-supported on Microsoft Windows Server Hyper-V and within Microsoft’s Azure cloud service. This list of software includes the Oracle Database, Weblogic,… Read more

0 comments, 1,339 reads

Posted in Technobabble by Klee from @kleegeek on 26 June 2013

Older posts