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

Archives: February 2014

PASS, Evangelism, Goals, Dreams

The role of PASS in the community has evolved a lot over the past few years. Back in 2006/2007 PASS was mainly about the Summit and trying to grow new chapters, not a lot of emphasis on doing more for chapters and not much interest in a day based event… Read more

0 comments, 1,293 reads

Posted in SQLAndy on 28 February 2014

Powershell in a Month Day 18–Variables

This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones.

I’m slightly behind here after holidays and some travel. Apparently my pop-up reminder for my own studies bears about as much… Read more

1 comments, 1,448 reads

Posted in The Voice of the DBA on 28 February 2014

Upcoming Webinar - Introduction to Power BI

Come join me for this webinar on 3/13/2014 at 11:00 AM EST

Introduction to Power BI 

The future of Business Intelligence has many new and exciting features. This world that was once reserved for only experts in SQL Server technologies has expanded to serve the masses with more and… Read more

0 comments, 1,347 reads

Posted in Devin Knight on 28 February 2014

Webinar Q&A: New BI Features in SharePoint 2013

I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in SharePoint 2013. If you attended I want to say thank you. It’s always a fun time presenting and the audience is always a lot of fun to interact with before… Read more

0 comments, 1,776 reads

Posted in Bradley Schacht on 28 February 2014

Reblog: February 21 to February 27

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, 1,424 reads

Posted in StrateSQL on 28 February 2014

Friday Followup For February 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

  • Cheating DBCC To Fix Index Corruption
  • Do You Need A Log Recovery Tool?
  • Automated Permissions Auditing With Powershell…

Read more

0 comments, 1,120 reads

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

Why wait statistics are important and how you can start collecting them now!

Why wait statistics are important and how you can start collecting them now!

Wait statistics have always been a very important tool in troubleshooting complex performance issues or monitoring the impact of changes on your SQL Server. I use wait statistics daily in helping clients troubleshoot performance issues they are…

Read more

0 comments, 1,341 reads

Posted in DotNine SQL Server and more on 28 February 2014

Fight Career Frustration With Learning

If you work in IT, the office becomes your second home.  It’s where we make a living, and most of us take a lot of pride in the work we do.  We feel good when we’ve put in a successful day at the office, however we also have those days…

Read more

10 comments, 2,945 reads

Posted in Adam Kreul | Blog on 28 February 2014

Virtual Lab – Setting up a new VM

This is part of a series where I set up a virtual lab for testing and misc. work. The other parts in the series are here: Building a Virtual Lab with Hyper-V.

I have my disks set up, now it’s time to create my virtual machines. I’m going to… Read more

1 comments, 1,461 reads

Posted in The Voice of the DBA on 27 February 2014

PowerShell – SSRS Inventory – Automatic – Excel File – EMAIL

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.

Download the file and save as SSRSInventory.PS1.

It has five mandatory parameters

  1. InputFileName – Text File contains a list of SQL Servers  -C:\Server.txt(Example)
  2. DirectoryToSave – Folder…

Read more

0 comments, 1,976 reads

Posted in PowerSQL By Prashanth Jayaram on 27 February 2014

Data Architecture Virtual Group - Whiteboard Data Architecture Presentation

Thanks to all 130+ folks who joined, suffered my jokes and handwriting, and asked fantastic questions during my presentation to the SQL PASS Data Architecture Virtual Group meeting.

We covered three large project templates, including an end-to-end application and Data Warehouse, a SharePoint-list driven Data Warehouse, and an "Access Jailbreak"…

Read more

0 comments, 1,271 reads

Posted in SQL Tact on 27 February 2014

Security #Datachat on Twitter Tonight

Tonight, at 9 PM Eastern, I’ll be participating in a #datachat on SQL Server security. It’s sponsored by Confio (now part of Solarwinds).

You can find more details about the #datachat here.

How can you participate? Simply open up a search for #datachat and participate in the community Q… Read more

1 comments, 978 reads

Posted in Databases – Infrastructure – Security on 27 February 2014

Introduction to Hadoop

Hadoop was created by the Apache foundation as an open-source software framework capable of processing large amounts of heterogeneous data-sets in a distributed fashion (via MapReduce) across clusters of commodity hardware on a storage framework (HDFS).  Hadoop uses a simplified programming model.  The result is Hadoop provides a reliable shared… Read more

8 comments, 8,093 reads

Posted in James Serra's Blog on 27 February 2014

Spring in Florida

The first sign of spring in Florida is the leaves falling from the oak trees. Tons of leaves, leaves everywhere, definitely a pain to keep up with, yet it’s worth it for the next part – in the next week or so I expect – when the large oak in… Read more

0 comments, 1,039 reads

Posted in SQLAndy on 27 February 2014

Let’s Talk Query Tuning

I spend quite a bit of time writing about query tuning on this blog. I’ve written (re-written and am actively re-writing) books on query tuning. But what I like most is talking about query tuning. I love giving sessions at various events on different aspects of query tuning, but, what… Read more

2 comments, 1,256 reads

Posted in The Scary DBA on 27 February 2014

SQL Server sample databases

Here are some places on the web where you can find sample databases for SQL Server. It's nice to have some of them on your local instance.
1. The AdventureWorks sample databases for SQL Server versions can be found on the following link http://msftdbprodsamples.codeplex.com/. There are the backup files…

Read more

0 comments, 723 reads

Posted in SQL Mighty on 27 February 2014

Thinking with Data by Max Shron


I recently enrolled myself in the O’Reilly Blogger Review program, which basically allows me to get one O’Reilly eBook for free per month so I can review it on my blog. This works in both ways of course: I get free eBooks while they’re still hot from the press… Read more

0 comments, 1,180 reads

Posted in Koen Verbeeck on 27 February 2014

Issue with sys.dm_db_index_usage_stats in SQL Server 2012

I’d be struggling to remember a week where I hadn’t run a query against the dmv sys.dm_db_index_usage_stats to find unused or under used indexes (or even heaps). It would have to be in the top shelf of many DBA’s toolboxes. So I was alarmed when I came across this post Read more

6 comments, 3,194 reads

Posted in Ctrl-alt-geek on 27 February 2014

Dude, where’s my Power Map?

If you haven’t noticed lately, Power Map has gone into General Availability as of 25 of February 2014. It comes along with service pack 1 of Office 2013, which you can download here. There are two ways of getting this update:

  • Downloading and installing service pack 1, aka the…

Read more

0 comments, 2,718 reads

Posted in Koen Verbeeck on 26 February 2014

Colorado SQL Events for March 2014

SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register. Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are… Read more

0 comments, 1,064 reads

Posted in Marc Beacom on 26 February 2014

Older posts