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

Archives: September 2011

SQL University SSIS : Named Pipes -- Producer

Yesterday, I set up the premise for using named pipes in SSIS.  Today we are going to get into the actual coding required to get this system up and running.  In a bit I will go over how you modify your Script objects to enable you to access the libraries… Read more

0 comments, 409 reads

Posted in SQLRunner on 27 September 2011

SQL Saturday in Iowa City This Weekend

In just a few short days, it will be time for SQL Saturday #98 in Iowa City.  If you’ve got some free time this coming Saturday and are within driving distance– take the time now to register and come get some free training.

While you are there, think about stepping… Read more

0 comments, 617 reads

Posted in StrateSQL on 27 September 2011

NOT IN or IN?

I have been having a hard time believing my eyes when I noticed that these queries give different results:

1. select * from TableA a where a.a_id not in (select b.a_id from TableB b)

2. select * from TableA a where not exists (select b.a_id from TableB b where a.a_id=b.a_id… Read more

0 comments, 636 reads

Posted in aedna@SQL on 27 September 2011

KB2463332 failed to install

This morning I was working on getting all new inherited SQL Servers patched to current levels of service packs when one particular server was failing on patching the database engine itself.  A quick google search revealed articles tips that someone may have deleted the c:\windows\installer contents.  That wasn’t my case. Read more

0 comments, 1,244 reads

Posted in Tim Radney - Database Professional on 27 September 2011

workaround for orphaned users


The server principal  is not able to access the database  under the current security context, is the error message appears for those users who was able to access the database / application earlier especially after refreshing database from production to dev, test or uat enviornment when the correspondent login is…

Read more

Missing indexes

One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing. Creating the optimal indexes for a system, is no where near a trivial excercise. You need to consider the read/write ratio as well as how you write your queries. This… Read more

0 comments, 1,129 reads

Posted in SQL Server Notes from the Field on 27 September 2011

September 2011 SQL Server 2008 Instance Level Diagnostic Queries

Since it is late September, I thought it would be a good time to release an updated set of Diagnostic queries that focus completely on SQL Server instance level metrics. These queries go a little deeper into the Instance level metrics than the combined Diagnostic Information Queries.

My previous DMV…

Read more

0 comments, 1,064 reads

Posted in Glenn Berry's SQL Server Performance on 27 September 2011

ALTER AUTHORIZATION sql to change owner of a database

ALTER AUTHORIZATION changes the ownership of  entities .  Server level entity ownership can be changed to server- level principals. Database level ownership can be changed to database level principals.

ALTER AUTHORIZATION can change database ownership.  This replaces sp_changedbowner.  Alter any security management scripts using sp_changedbowner  - such as Attach database… Read more

2 comments, 67,124 reads

Posted in SQLServer-DBA on 27 September 2011

SQL Server – Creating and using Dump Devices for Backups

A dump device is simply a logical device which redirects to a specified physical device. The main advantage of using a dump device for backups is it reduces the change required to backup code. For example, if you are backing up to a Network location. If you have hard-coded the… Read more

0 comments, 1,097 reads

Posted in SQL and Me on 26 September 2011

Recovery Models

In SQL Server we have three basic recovery models: full, bulk-logged, and simple. By default we find that most databases use the defaults, which mean that they are in the full recovery model.

In that case, you need to be sure that you are performing log backups, otherwise the log… Read more

2 comments, 2,585 reads

Posted in The Voice of the DBA on 26 September 2011

Paying for Free

It seems like there is a widespread malaise in the country these days. Everyone’s clamoring to cut taxes -but no one wants to have their neighborhood school closed, or fear bridges collapsing underneath them, or damage their automobiles while driving...(read more)

Read more

0 comments, 811 reads

Posted in SQLSequel on 26 September 2011

What is a Microsoft Regional Director?

First off, they don’t work for Microsoft.  A Microsoft Regional Director (RD) is an unbiased third-party evangelist of Microsoft products and services.  Regional Directors are members of an elite, worldwide group of technology thought-leaders known for their national and international speaking tours, their authorship of books, articles and blogs, and… Read more

0 comments, 1,226 reads

Posted in James Serra's Blog on 26 September 2011

SSIS Lookup Cache Connection Manager with Excel

The lookup transform in SSIS 2008 gives you the ability to join data and eliminate non matching rows. One of the limitations of the lookup is the fact it requires an OLEDB connection. However, with the cache connection manager you can use just about any other data source as your… Read more

0 comments, 1,403 reads

Posted in Mike Davis SQL on 26 September 2011

Small Business Hardware

[NOTE] My blog post scheduling-fu is weak, so this post didn’t go out Friday as planned. My apologies.

This is the final installment of our Small Business series. So far we talked about how to get the software, and we’ve talked about the different options of SQL Server available… Read more

2 comments, 1,210 reads

Posted in SQL Chicken on 26 September 2011

Book Review: Smarter, Faster, Cheaper

In my continuing quest to not get personal visits from Buck Woody (blog|twitter) I’m making sure that I make good on my commitment to read 12 personal development books in 12 months. We’re up to #4 (again demonstrating the degree of fear that Buck can put… Read more

2 comments, 1,239 reads

Posted in The Scary DBA on 26 September 2011

Notes from SQLSaturday #85

I’m writing this on Sunday afternoon after the event, thinking about the event and what I want to share with you:

  • The speaker party started with a down pour, forcing us into a too small back room that still worked. Great evening conversations.
  • We used the built-in SpeedPASS for the…

Read more

0 comments, 562 reads

Posted in SQLAndy on 26 September 2011

SQL University SSIS : Named Pipes -- Fundamentals

There comes a time when you look at how something is being done and say, "Does it have to be that way?".  SSIS has a few stock Data Flow Sources and they meet 90% of our needs.  There is a situation where I have a single source of data, but… Read more

0 comments, 397 reads

Posted in SQLRunner on 26 September 2011

PASS 2011 Countdown – 2 Weeks To Go

I’m not sure how we got to 2-weeks until this year’s PASS Summit.  If you haven’t registered yet it’s really getting to be time to do that.  It’s really easy to do, click on the banner below and enter your information and your neighbor’s credit card, but I didn’t… Read more

0 comments, 461 reads

Posted in StrateSQL on 26 September 2011

Database Properties Health Check

For some time now, I have been working on a new book called How to Perform a SQL Server Health Check. I have written over 300 pages of it, and I am only about half way done. In the meantime, I have published a short except from the book… Read more

0 comments, 861 reads

Posted in SQL Aloha on 26 September 2011

SQL Server MVP Deep Dives 2 Released

Exciting news…  The second edition of the SQL Server MVP Deep Dives book has been completed and is going to press in time for the PASS Global Summit!  The book will be on sale at the conference book store and is available to pre-order on Amazon*  It can be… Read more

0 comments, 854 reads

Posted in SQL Server BI Blog on 26 September 2011

Newer posts

Older posts