Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 330 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, 199 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, 229 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, 177 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, 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, 260 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, 169 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

0 comments, 121 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, 399 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, 232 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, 223 reads

Posted in SQLAndy 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, 291 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, 81 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, 167 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

0 comments, 204 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, 231 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, 211 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, 333 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

4 comments, 316 reads

Posted in StrateSQL on 29 January 2014

SQL Server Quickie #10 – Forwarding Records

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 10th SQL Server Quickie to YouTube. This time I’m talking… Read more

0 comments, 333 reads

Posted in Klaus Aschenbrenner on 29 January 2014

Older posts