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

Archives: January 2014

Powershell in a Month Day 14 – WMI

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.

Day 14 introduces us to Windows Management Instrumentation (WMI). Since many people might not be familiar with WMI, the chapter spends… Read more

1 comments, 1,737 reads

Posted in The Voice of the DBA on 31 January 2014

Honored to be added to SQLRockstar’s SQL Server blog rankings

Today I woke up to find that Thomas LaRock (blog | twitter | linkedin) has added me to his SQL Server Blogger Rankings list. WOW! I’m completely honored to be listed among this world-class list of the best bloggers in the industry. He created a new section on… Read more

0 comments, 1,204 reads

Posted in Technobabble by Klee from @kleegeek on 31 January 2014

Reblog: January 24 to January 30

Photo credit – Husso

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this… Read more

0 comments, 1,358 reads

Posted in StrateSQL on 31 January 2014

See Consolidated Data About SQLSaturday (Events, Sponsors, And Speakers)

Yesterday Kendal Van Dyke posted a file to Skydrive with consolidated information from all the events published so far. He built it by grabbing the individual event feeds and I’m guessing some scraping to come up with a file that is useful. Kudos to Kendal for doing this, it fills… Read more

0 comments, 1,148 reads

Posted in SQLAndy on 31 January 2014

Famous Move Quotes–Visualized

Ran across this poster of movie quotes – $20 will get you a copy. Why might you be interested? The visualizations of the quotes!

Read more

0 comments, 1,220 reads

Posted in SQLAndy on 31 January 2014

Master Data Services (Second Edition) – Review

For the preparation of my upcoming talk about SQL Server 2012 Master Data Services on the Microsoft Business Analytics Day (hosted by my company element61), I read the book Master Data Services 2nd edition by Tyler Graham.

I had almost no prior experience with MDS up to this… Read more

2 comments, 1,908 reads

Posted in Koen Verbeeck on 31 January 2014

Friday Followup For January 31, 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

  • If You’re Not Doing Anything….
  • Do You Need A Log Recovery Tool?
  • What Are Your Servers Doing While…

Read more

0 comments, 1,112 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 31 January 2014

My Visual Studio crashed and I didn't know why!

Recently I had to develop a simple ETL task with the help of SSIS to transfer an Excel data file into a SQL Server table for reporting. It was nothing special, simple file and only a fraction of it needed to be transfer to I had use a SQL command…

Read more

1 comments, 1,280 reads

Posted in Data Adventures on 31 January 2014

Starting to Use Powershell

I have to admit that before the Powershell Challenge, I wasn’t really looking forward to using Powershell for much of anything. It looked cumbersome, I didn’t always understand how sample scripts worked, and it was just easier to use the various other Windows tools to accomplish tasks.

However as… Read more

0 comments, 1,761 reads

Posted in The Voice of the DBA on 30 January 2014

Security, Compliance, and SQL Server – Recording Now Available

If you missed it live you get a second chance! http://www.mssqltips.com/sql-server-video/284/security-compliance-and-sql-server-video/. Had about 300 attend and more questions than we could answer in the time left, will try to do some follow up posts in the next week or so to answer them (and feel free to post questions… Read more

0 comments, 1,093 reads

Posted in SQLAndy on 30 January 2014

Uninstalling SSMS on Server Breaks SQL Powershell

I reviewed my daily report and saw that some jobs failed on six instances overnight, the common factor being that they all used Powershell. None of them had failed recently or been changed recently, and the same code executed fine on many other instances in the same time frame.  Here… Read more

0 comments, 1,751 reads

Posted in SQLAndy on 30 January 2014

Non-unique indexes that COULD be unique

In my last post I showed a query to identify non-unique indexes that should be unique.

You maybe have some other indexes that could be unique based on the data they contain, but are not.

To find out, you just need to query each of those indexes and group… Read more

0 comments, 971 reads

Posted in SpaghettiDBA on 30 January 2014

Final Day for Power BI Voting, Can I Have Your?

Today is the final day for the Power BI Contest voting and I could use your help to move on in the competition!  Please take a moment and vote for my video here http://tinyurl.com/PowerBIDevin

Thanks for voting! Read more

0 comments, 1,313 reads

Posted in Devin Knight on 30 January 2014

Your own personal space

Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding Friday afternoon) and generally unwind. Your worries seem to drift off until there’s a bang on the door…there’s been an issue in Production and you need to investigate. You heave… Read more

0 comments, 999 reads

Posted in The DBA Who Came In From The Cold on 30 January 2014

2013 with You & SQL Server

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 41,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 15…

Read more

0 comments, 1,115 reads

Posted in MSSQLFUN on 30 January 2014

It May Be Necessary Re-enable Service Broker After Baremetal Restore

After the restore of a database, or perhaps a bare-metal restore of a Windows server running SQL Server, unique IDs in the Service Broker settings may have changed, causing the broker to fail when starting. So, you will need to reactivate Service Broker.

You may first notice this because Database…

Read more

1 comments, 1,108 reads

Posted in SQL Tact on 30 January 2014

Database Project Versioning

SSDT 2010, 2012 with TFS integration brought about a couple of different options when you are looking to version your database projects. Before deciding on how you should version your projects, you first have to ask what you are trying to accomplish through versioning. Is this simply an audit trail,… Read more

0 comments, 1,787 reads

Posted in SQLMiguel on 30 January 2014

SSIS Training class by Andy Leonard



Andy Leonard (b | t | l | f) of Linchpin People, has announced a new training class called ‘From Zero to SSIS‘. The first class is being offered in Reston, VA, May 19-23 2014. Andy is one to the top guru’s… Read more

0 comments, 1,750 reads

Posted in Tim Radney - Database Professional on 30 January 2014

New SSIS Training Class from Andy Leonard

Andy Leonard (b | t | l | f), a good friend of mine from Linchpin People, has announced a new training class called ‘From Zero to SSIS‘. The first class is being offered in Reston, VA, May 19-23 2014. Come learn from the… Read more

0 comments, 1,390 reads

Posted in Technobabble by Klee from @kleegeek on 29 January 2014

Have You Studied SQL Server Enough?

Photo Credit – yum9me

SQL Server is a fairly big and complicated product.  There are quite a few areas that you can study, the database engine, Analysis Service, T-SQL development, and many others.  As you delve into each of these areas, how do you know when you’ve studied any area… Read more

0 comments, 1,483 reads

Posted in StrateSQL on 29 January 2014

Older posts