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

Archives: August 2012

Parallel Data Warehouse (PDW) How-To: Check Database Size with DBCC_pdw_showspaceused

There is a way to view the size of a particular PDW database using the  DBCC_pdw_showspaceused command via the NEXUS query editor.  Executing the steps below will allow the developer to view sizes (in Mb) for the following columns:

Reserved_Space
Data_Space
Index_Space
Unused_Space
PDW_Node_ID

Follow the steps below in NEXUS… Read more

These People Are Exceptional

I should know. I was one of the judges of this year’s Exceptional DBA of the Year award. I had to read through tons and tons of submissions and help to arrive at a final list of people who truly personify the concept of both the DBA and the exceptional… Read more

2 comments, 644 reads

Posted in The Scary DBA on 28 August 2012

SQL Server Guest User – Still a Serious Security Threat

One of the security recommendation inside SQL Server Security Best Practice white paper for guest user is that, to disable guest access in every database (expect “master”, “msdb” and “tempdb”) on SQL Server instance, and it should not be used in any circumstances. By default, guest user exists in all… Read more

3 comments, 2,165 reads

Posted in Basit's SQL Server Tips on 28 August 2012

Minnesota SQL Saturday (#SQLSat149)

It’s close to that time of year again.  It’s time for a SQL Saturday in Minnesota and this… it isn’t happening on a Friday.  Yes, this year PASSMN has opted to instead have the SQL Saturday on a Saturday.  If you’ve followed this event in Minnesota for the past few… Read more

1 comments, 407 reads

Posted in StrateSQL on 28 August 2012

Please, Call Me Richard

I presented a session at the SQL Saturday event in Oklahoma City last weekend. The event itself was pretty good. The organizers put everything together pretty well and the venue was quite nice. Plus, since I grew up in Oklahoma (Tulsa), it was a chance to go home. The event… Read more

10 comments, 470 reads

Posted in The Scary DBA on 28 August 2012

The INSTALLSHAREDWOWDIR command line value is not valid.

I was recently making some changes to my laptop setup and installing SQL Server 2008R2 and SQL Server 2012 directly on the computer rather than on my VM. In the case of my setup I had already installed the client tools for 2008R2 and 2012 on my laptop. So in… Read more

1 comments, 627 reads

Posted in Bradley Schacht on 28 August 2012

Say Seminar, Not Pre-Con for SQLSaturday

I read a note posted on the OPASS LinkedIn site today about our upcoming SQLSaturday and the two pre-cons by Stacia Misner and Kevin Kline. I say and think pre-cons, but does the new DBA? Their boss? Seminar, One Day Class, or something else, we need to call it… Read more

3 comments, 409 reads

Posted in SQLAndy on 28 August 2012

Enable Transparent Data Encryption

This is one of the things in my Encryption Primer presentation that I don’t demo. It’s really easy to do, and it’s rather mechanical, so I just show the image that has the steps from MSDN and leave it at that.

However there are a few things I wanted to… Read more

1 comments, 1,723 reads

Posted in The Voice of the DBA on 28 August 2012

PowerShell: Redirecting Console Output and Error Output to a Variable and E-mailing it

I recently had the need to script the execution of a command-line utility and thought it would be a good learning experience to try doing it with PowerShell.  The utility would sometimes output to the STDOUT, but would also send its output to STDERR if there was a problem.  This… Read more

1 comments, 6,980 reads

Posted in New York City .NET on 28 August 2012

A Novel Workaround for an Infamous SSAS Connection Error

For months I’ve been itching to get the latest version of SQL Server, thanks to the addition of new functionality on the OLTP side that I can make use of, like FileTables and the new windowing functions. Two Fridays ago, I finally got my copy of SQL Server 2012 Developer… Read more

10 comments, 835 reads

Posted in Multidimensional Mayhem on 28 August 2012

Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations

There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data Warehouse (PDW) environment. With proper planning and attention to detail, one can side-step two operations more commonly known as the Data Movement Service (DMS) ShuffleMove and PartitionMove operations.  To… Read more

The Embarcadero – SQL in the City San Francisco

I love San Francisco. It was one of the cities that I thought I might live in someday. My kids have all been there multiple times, exploring museums, crossing the amazing Golden Gate Bridge, visting Muir Woods and more. When I heard SQL in the City was coming to S.F,… Read more

0 comments, 499 reads

Posted in The Voice of the DBA on 27 August 2012

PASS Election Season

Did you know that it’s election season for PASS?  Did you know that you can pose questions to the potential candidates via the Election Forums?  The NomCom is busy interviewing candidates and is offering you the opportunity to ask the candidates question, via the NomCom.  Do you have a… Read more

0 comments, 317 reads

Posted in SQL Swimmer on 27 August 2012

SQL Server 2012 and SharePoint 2013: Installing on a Virtual Machine

With the preview of SharePoint 2013 now available, I have updated my post SQL Server 2012: Installing on a Virtual Machine to use SharePoint 2013 instead of SharePoint 2010.  If you would like to get a head start on learning what is new with SharePoint 2013 and Excel 2013, follow… Read more

11 comments, 11,482 reads

Posted in James Serra's Blog on 27 August 2012

Secure Your Spot at the Nashville SQL Saturday!

PASS SQL Saturdays are free 1-day training events for IT professionals interested in Microsoft SQL Server, providing a variety of high-quality technical sessions, all happen through the efforts of local volunteers.  The leadership team of the local chapter of PASS here in Nashville (Facebook | LinkedIn) have worked… Read more

0 comments, 618 reads

Posted in Kevin E. Kline on 27 August 2012

Create a SQL Server Reporting Services (SSRS) Catalog Report in 15 Minutes

One big question I have gotten often is “I need data, what kind of reports do you have?” It is a valid question from a user, especially with a server that may gave hundreds of reports. The solution? Create a Reports Catalog Report. I have provided the simple instructions and…

Read more

0 comments, 219 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 27 August 2012

Re-Using Phone Numbers at the Office

I’ve been with my current client for just over a year and I still get calls for the previous occupant from vendors, credit card companies, etc. I know that calling is how they figure out the person has moved on, but I get tired of the calls. It goes something… Read more

0 comments, 316 reads

Posted in SQLAndy on 27 August 2012

Five Applicants for the PASS Board

If you haven’t reviewed the list, head to the PASS Election Page. One incumbent, two appointees, one previous candidate, and one new candidate. All still have to be vetted by the Nominating Committee over the next week or so, then on to the election which starts on September 28th.… Read more

0 comments, 245 reads

Posted in SQLAndy on 27 August 2012

When Can You Be Considered As A Senior DBA

 

As a DBA, when can you consider yourself as a senior DBA?

If you read online posts, you will find most of the time, a senior DBA is judged by “Do you know this and do you know that?” approach, which to me is subjective and may cause more…

Read more

0 comments, 1,859 reads

Posted in DBA Philosophy on 27 August 2012

SQL Saturday 125 OKC

This weekend I traveled three hours north to Oklahoma City to participate in SQL Saturday 125, the second annual event hosted by the OKCSQL group. Ryan Adams, Russ Loski, John Sterrett and I hit the road midafternoon to give ourselves time to make it in time for the speaker… Read more

5 comments, 324 reads

Posted in Tim Mitchell on 27 August 2012

Newer posts

Older posts