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

Archives: July 2012

Password Resets

I read this piece from Troy Hunt, which is a long look at the password reset process for a web application. It’s one of the first that I’ve seen which talks about the different implementations, along with the pitfalls and advantages of each.

It’s a great look at passwords,… Read more

0 comments, 1,677 reads

Posted in The Voice of the DBA on 31 July 2012

Creating a DDL Trigger

One of the most amazing features to an old SQL Server 4.2 guy was the addition of DDL triggers to the server. As with any trigger, these can be problematic in that they can overload a server, and they ALWAYS fire, so you can cause yourself problems, but in terms… Read more

2 comments, 2,758 reads

Posted in The Voice of the DBA on 31 July 2012

Come See Me. I’ll Probably Be Just Down the Street Soon!

Even though I’ve recently changed jobs, I’ll still be speaking at a lot of SQL events across the country and internationally.  There are still a few trips that I’ve yet to finalize, in particular with the fine folks in Houston, run by my friend Nancy Hidy (blog | twitter Read more

2 comments, 1,702 reads

Posted in Kevin E. Kline on 31 July 2012

Bad business practices damage your company, KRG Technology

I just composed and sent this message to eleven members of a single California-based recruitment company. I’ll let the email speak for itself, but you, dear reader, should also know that the positions they reference range from Business Objects to Android programming, with nary a DB job in sight. Read more

6 comments, 1,724 reads

Posted in SQL Awesomesauce on 31 July 2012

SQL Audit 201 – Creating an Audit Solution

Welcome back, folks!

Ok so, now that we’ve covered the basics of creating a SQL Audit and viewing the output, let’s put the pieces together to form a complete solution. As with any implementation, the key to success lies in careful planning. Before we take off running, we need… Read more

5 comments, 6,615 reads

Posted in Cleveland DBA on 31 July 2012

Exporting Data Using BCP

BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way to export large quantities of data very quickly from SQL Server. It can be used to export entire tables or even a custom query. In this post we will focus… Read more

3 comments, 8,561 reads

Posted in Bradley Schacht on 31 July 2012

OLAP PivotTable Extensions Update

OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now.  It allows you to have some exposure to what’s going on under the covers (Among many other features) while you browse a cube using an Excel PivotTable. This weekend there has… Read more

0 comments, 1,880 reads

Posted in Devin Knight on 31 July 2012

SCRIPT: Basic Information About Indexes

I’m having a little fun with documenting basic information about indexes in my current project. I’m posting the scripts here mostly for me to come back when I need them in the future, but hopefully some of you might find them useful.

Find tables without any index:

This script… Read more

0 comments, 2,036 reads

Posted in Sam Vanga on 31 July 2012

Reading Excel into SSIS via OpenXML Scripting

Reading Excel data isn't easy.  It should be, but there's a lot of unfortunate barriers in the way that I've discussed before.  They boil down to one main reason: Excel wasn't created for IT, it was created for business users.  We're quite obviously an afterthought.  That said, we're much more…

Read more

11 comments, 4,765 reads

Posted in Todd McDermid's Blog on 31 July 2012

Improve DBA Operation Productivity – Part Two

As a DBA, we have to take various actions based on huge amount of information received. In one perspective, our productivity is limited by our capability bandwidth to process the information received. However, if this information is frequently “polluted or even poisoned”, our productivity is surely compromised.

I define “polluted… Read more

0 comments, 1,883 reads

Posted in DBA Philosophy on 31 July 2012

SQLSaturday #171 Pittsburgh Prep Continues

Hey, did I mention that Pittsburgh is having a SQLSaturday this year?

Pittsburgh, Pennsylvania. Photo:Herbert Spencer, used under Creative Commons License.

It's October 6th, at La Roche College, just north of the city proper. A few of us on the committee visited the venue last Thursday, and I have to… Read more

0 comments, 1,539 reads

Posted in Stephen Tirone - Adventures with Data on 30 July 2012

#GetHawt – The Summer 2012 Edition

Jen McCown started a #GetHawt set of posts last year and I think it went well. It must have, so she started an invitation for a summer competition. Silly me hadn’t been paying much attention, even though I’d seen the tweets. I finally caught up this last week, and… Read more

0 comments, 1,748 reads

Posted in The Voice of the DBA on 30 July 2012

August 2012 S3OLV Meeting

Well well well.  It has certainly been a long time between announcements on the blog about meetings for the Las Vegas SQL Server Users Group.

We have had to cancel a couple of times in the past few months – but the meetings have been happening with or without the… Read more

4 comments, 1,590 reads

Posted in SQL RNNR on 30 July 2012

Syncing your contacts

In the same vein as my blog post about Syncing your calendars, I wanted to post how to sync your contacts in Outlook, Gmail (Google Contacts), and iPhone:

- Transfer your Outlook contacts to Gmail via Transfer contacts between Outlook and Google Gmail

- In Gmail, remove the duplicates… Read more

0 comments, 1,822 reads

Posted in James Serra's Blog on 30 July 2012

SQL Server Orphanage – Using sp_change_users_login to find and fix all orphaned SQL users

Every wonder who all your orphaned SQL Server users are on your server? Just run the script below and copy the results of the query into a new query window then execute them. Make sure you keep the spacing and the quotes as they are so that the Dynamic SQL…

Read more

6 comments, 1,408 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 30 July 2012

Video Enable PowerPivot Add-in

This is one of our first PowerPivot video tutorials and this short 1 minute tutorial we show how to enable PowerPivot Add-in in Excel 2013. View blog post: http://www.katieandemil.com/457

Read more

0 comments, 1,614 reads

Posted in Katie and Emil on 30 July 2012

SQL Server : Dedicated Administrator Connections

Think about a scenario : People are complaining about your production database server.Many users are getting continuous time out error. Rest of the users are not able to connect database server.When you tried to  run your diagnostic query , either you are not able to connect or it is not…

Read more

9 comments, 3,651 reads

Posted in PracticalSQLDba on 30 July 2012

How to move master and resource system databases?

I received an phone call from a friend today asking how to move master and resource system databases in Microsoft SQL Server 2012.

Well, the process is very simple and is explained in this blog post:

Moving “master” database

The following are the steps to move master database:

  1. Launch SQL…

Read more

4 comments, 6,622 reads

Posted in Basit's SQL Server Tips on 29 July 2012

The effects of an SSD on SQL Server Performance

I.                    Introduction A little while ago, my wonderful wife Renee got a Solid State Drive (SSD) for me.  Being a DBA, one of my first thoughts was to wonder what kind of effect this would have on database performance, since … Continue reading

Read more

12 comments, 5,649 reads

Posted in SQLWise on 29 July 2012

transparent data encryption steps

In this blog post I show steps that are needed to enable Transparent Data Encyption on a SQL Server 2012 database. I prepared the article to support my learning to 70-462 Administering SQL Server 2012. View Article: http://www.katieandemil.com/456

Read more

0 comments, 1,562 reads

Posted in Katie and Emil on 28 July 2012

Older posts