Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: August 2013

MDX #29–Co-authored MDX with SSAS 2012 Cookbook

I have been absent from this blog for the last few months. For those who have noticed, I’d like to offer my apology and also provide an excuse. I hope that co-authoring a book is a good enough excuse.

For the last few months, I have been working on the… Read more

2 comments, 351 reads

Posted in Sherry Li's BI Corner on 29 August 2013

Working Class Hero

I could tell you a story about Green Day's cover of John Lennon's classic "Working Class Hero" that you wouldn't believe. (It's too crazy.) But that doesn't really matter any way.

Here is something that does matter: there is nothing wrong with being a DBA.

I have encountered… Read more

0 comments, 471 reads

Posted in @chuckboycejr on 29 August 2013

I have a dream

It seems fitting with the anniversary of Martin Luther King’s “I have a dream” speech that I would write about discrimination this week in my piece “Stunned”. There’s a long discussion over at SQLServerCentral, and along with a phone call with a friend, I thought a bit about… Read more

0 comments, 360 reads

Posted in The Voice of the DBA on 28 August 2013

Introduction to Power Query Q&A

Thanks everyone for attending my free webinar on Introduction to Power Query on August, 27, 2013.  If you were not able join for the live event you can now watch the recording here. This was part of an ongoing webinar series by Pragmatic Works offers every Tuesday and Thursday… Read more

0 comments, 519 reads

Posted in Devin Knight on 28 August 2013

Exploring Excel 2013 for BI Tip #11: Color Scales

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

0 comments, 1,176 reads

Posted in DataOnWheels on 28 August 2013

Learn SQL Server Performance Tuning Basics in a Single Day

Have you always wanted to dig into performance tuning but wasn’t sure where to start? If so, check out this Introduction to SQL Server Performance Tuning training opportunity for you in Pittsburgh on September 13th. It will be given as a PreCon for SQL Saturday #250 in Pittsburgh. Konstantin… Read more

0 comments, 2,220 reads

Posted in John Sterrett on 28 August 2013

Learn Query Tuning in Dallas

I am excited to be able to tell you about an all day seminar that I’ll be putting on prior to the Dallas SQL Saturday #255. The seminar will be on November 1, 2013. It’s called Query Performance Tuning in SQL Server. We’re going to cover the topic… Read more

0 comments, 243 reads

Posted in The Scary DBA on 28 August 2013

The most important skill to practice when preparing for any certification exam!

I like practice tests. Once I feel like I’m getting ready to take a certification exam I start taking an appropriate practice exam or two.

Just a point here. When I get a question wrong I review the SUBJECT I get wrong, I don’t just memorize that particular answer. I… Read more

4 comments, 398 reads

Posted in SQLStudies on 28 August 2013

Duplicate Statistics

The Setup:

Standard best practise is to have auto create and auto update statistics set for SQL Server databases. But there is no corresponding setting to remove statistics that are no longer necessary. Unless explicitly managed by the DBA these statistics could be causing excess resource usage.

Demo:

Create a… Read more

7 comments, 1,604 reads

Posted in Ctrl-alt-geek on 28 August 2013

VMware vSphere 5.5 details trickling out

VMworld 2013 is this week in San Francisco, and some exciting details about the next version of the vSphere suite, version 5.5, are starting to trickle out. 

From my perspective, the biggest announcements so far are as follows:

  • The maximum size per VMDK and RDMv disk is now 62TB (up…

Read more

0 comments, 251 reads

Posted in Technobabble by Klee from @kleegeek on 28 August 2013

Winner of the worst recruiter of the year!

Every week I get a bunch of emails from recruiters about jobs that I am not qualified for (see Low-rate recruiters – The bane of my existence).  Some obviously use keyword searches and just spam any person who has that keyword in their profile (i.e. I have Microsoft Dynamics… Read more

19 comments, 627 reads

Posted in James Serra's Blog on 27 August 2013

Check Your Azure Account Usage

It is absolutely not cool or fun to pay money to learn new technology. One of the main complaints people had for learning Azure (and AWS for that matter) is that they had to register with a credit card and actually put their own money on the line to try… Read more

1 comments, 288 reads

Posted in The Scary DBA on 27 August 2013

SharePoint SSRS “The permissions granted to user ‘Domain\User’ are insufficient for performing this operation”

Not too long ago I ran into a crazy situation where just about everything that could have gone wrong with my SharePoint environment after a restore did go wrong. I was planning on blogging a bunch of it and thanks to time constraints I had to just get it backup… Read more

5 comments, 438 reads

Posted in Bradley Schacht on 27 August 2013

How to Tell If Your Users are Connecting to the Availability Group Listener

You've spent a lot of time planning and building out a new SQL Server 2012 environment complete with Availability Group Listeners, but how can you be sure the end users are connecting to the listener and not directly to the SQL Server instance?

So why would we care about this? …

Read more

0 comments, 1,027 reads

Posted in Everyday SQL on 27 August 2013

Query Stats

DBAs rarely use the full potential of sys.dm_exec_query_stats.  It’s common to see the queries for looking at the most expensive queries according to any of the stats contained within the current cache, which is great to see.  However, if you grab snapshots of this information the proper way then you… Read more

3 comments, 1,753 reads

Posted in Simple SQL Server on 27 August 2013

A Rickety Stairway to SQL Server Data Mining, Part 14.2: Writing a Bare Bones Plugin Algorithm

By Steve Bolton

…………As I’ve said many times throughout this series of amateur mistutorials, SQL Server Data Mining (SSDM) is one of the most powerful yet neglected products Microsoft has to offer. The ability to extend it with your own algorithms is in turn the most powerful yet neglected… Read more

0 comments, 1,533 reads

Posted in Multidimensional Mayhem on 26 August 2013

SQL – Identify & Drop Duplicate Index

This post explains the simple steps to identify a duplicate indexes in all the databases.  The duplicate index are more than one indexes that differ only by it’s name but consist of identical fields internally. It generates overhead when performing updates, inserts or deletes, require lot of resources for rebuilds,… Read more

4 comments, 369 reads

Posted in PowerSQL By Prashanth Jayaram on 26 August 2013

SQL Saturday 223 OKC

This past weekend I made the relatively short (about 3 hours) trip to the Oklahoma City area to attend and speak at the third annual SQL Saturday event there.  I’ve been invited to speak at each of their three events, and I’ve been impressed with each one of them so… Read more

2 comments, 315 reads

Posted in Tim Mitchell on 26 August 2013

Backup Your Certificate for TDE

If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database Encryption Key (DEK). If you follow my instructions, then you have one.

If you didn’t make a backup, or you have just discovered a TDE database, make one now,… Read more

0 comments, 942 reads

Posted in The Voice of the DBA on 26 August 2013

Last Weeks Top “Reading” Links #46

It’s Monday, it’s time for weekly round-up #46.  As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  While these links aren’t the answer to life, the universe, and everything, they do… Read more

1 comments, 341 reads

Posted in StrateSQL on 26 August 2013

Newer posts

Older posts