Click here to monitor SSC
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, 708 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, 820 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, 787 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,216 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, 821 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, 578 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, 827 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,405 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, 799 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,211 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, 721 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, 542 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, 6,678 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

2 comments, 573 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, 692 reads

Posted in The Scary DBA 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, 650 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, 2,422 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,029 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, 576 reads

Posted in Marc Beacom on 26 February 2014

Acadiana SQL Server User Group - Introduction to SQL Server Security Principals and Permissions

Great crowd last night and a great job by organizers Glenda Gable and Jill Joubert for the very first meeting of the Acadiana SQL Server User Group! I'm looking forward to seeing another solid SQL Server networking community in place and growing, just an hour west of us in Baton…

Read more

0 comments, 773 reads

Posted in SQL Tact on 26 February 2014

Older posts