Welcome to SQLShare

Featured Video

Working with Foreign Keys This lesson explains how to use foreign keys to make sure valid data is entered and how to create foreign keys using the different techniques available in Management Studio. Foreign keys are an essential part of database design, definitely worth learning!	This is a preview. Click the title above to see the whole video.
Next

Upcoming Events

Event Date

Title

Description

iCal

No data to display

SQL Blog Posts

Title

Summary

Blog

Feed

Best of MSDN Blogs–15 Episode SQL Azure Learning Series

I’m still having fun geeking with SQL Azure although we are not using it at work. Looks like the UK ISV Developer Evangelism Team has put together a step-by-step for getting started in SQL Azure. Chec...

Lee Everest's SQL Server, etc, weblog

WAHOO! I’m working for PASS HQ!!!

Today I begin my journey as the newest member of the PASS HQ team. I am still pinching myself as I cannot believe that this has happened to me! It’s like winning the lottery, getting to do what I am...

Community Pollination by Karla Landrum

Writing Better Emails

In January 2009, I made the transition back to being a senior DBA. One of the first things my manager pointed out to me was that I needed to improve my email writing. His main beefs:I took too long ge...

K. Brian Kelley - Databases, Infrastructure, and Security

http://www.sqlservercentral.com/blogs/brian_kelley/rss.aspx

Microsoft Migration Assistant v5.0 Released

As I was surfing around twitter after the marathon TV event that was the Royal Wedding came to end last friday I noticed a tweet by @MicrosoftSQLCSS announcing the release of SQL Server Migration Assi...

Gethyn Ellis - The SQL DBA in the UK

http://feeds.feedburner.com/Gre-TheSqlDbaInTheUk

Microsoft Migration Assistant v5.0 Released

Gethyn Ellis - The SQL DBA in the UK

Extreme Standardisation

I spent yesterday at the Best of the Microsoft Management Summit in London and rather than have endless debates about what is or isn’t private cloud the term extreme standardisation was used to explai...

Insufficent data from Andrew Fryer

http://feeds.feedburner.com/technet/DeepFat

SQL Server DBA Manageability practices: Central Management Servers - how best you want to utilize them?

SQL Server 2008 version added a new face within SQL Server Management Studio that can help users to administer/manage/execute queries against multiple servers by designating Central Management Servers...

SQL Server Knowledge Sharing Network

http://sqlblogcasts.com/blogs/ssqanet/rss.aspx

SQL Server DBA Manageability practices: Central Management Servers - how best you want to utilize them?

SqlServer-QA.net

TempDB Deleted Accidentally

TempDB is the ALU of the SQL Server and if somehow this gets deleted Server cannot start. Here is a solution of how to get the server started when TempDB is

SQLServerCentral

A Developers' Guide to Refactoring Databases

When Agile meets 'Big Design', the result can be frustration on both sides. Is it possible for database development to to easily coexist with Agile methodologies for application development? Nick sugg...

SQLServerCentral

Latest Featured Videos

Most Watched Videos

Working with Foreign Keys (Watch it Later!)
	Date Featured: February 24, 2012 Author: Andy Warren Length: 3 Minutes 46 Seconds Rating: 4.28 Description: This lesson explains how to use foreign keys to make sure valid data is entered and how to create foreign keys using the diff...

Computed Columns - Part 2 (Watch it Later!)
	Date Featured: February 23, 2012 Author: Andy Warren Length: 2 Minutes 58 Seconds Rating: 4.36 Description: Computed columns are an interesting alternative to expressions in a stand alone select or a select contained in a view. Not s...

Computed Columns - Part 1 (Watch it Later!)
	Date Featured: February 22, 2012 Author: Andy Warren Length: 1 Minutes 57 Seconds Rating: 4.28 Description: Computed columns are an interesting alternative to expressions in a stand alone select or a select contained in a view. Not s...

Using the Import/Export Wizard (Watch it Later!)
	Date Featured: February 21, 2012 Author: Brian Knight Length: 5 Minutes 16 Seconds Rating: 3.86 Description: A great demonstration of using the Import/Export Wizard that uses SSIS for the actual moving of data

Use sp_MSForEachDB Instead of Your Own Loop (Watch it Later!)
	Date Featured: February 20, 2012 Author: Andy Warren Length: 2 Minutes 0 Seconds Rating: 4.23 Description: Did you know it's possible to loop through databases and tables without writing your own loop? That's right, SQL Server has a...

Speak Like a SSIS Developer (Watch it Later!)
	Date Featured: June 10, 2006 Author: Brian Knight Length: 11 Minutes 51 Seconds Rating: 4.23 Description: In this first video of the series, you'll learn what SQL Server Integration Services does and a little about the environment....

Change Data Capture with SSIS (Watch it Later!)
	Date Featured: January 12, 2007 Author: Brian Knight Length: 14 Minutes 3 Seconds Rating: 4.46 Description: In this presentation, Brian Knight shows you how to use canned SSIS components to detect data changes in a source table and o...

Adding a Time Stamp to a File Name in SSIS (Watch it Later!)
	Date Featured: December 01, 2008 Author: Brian Knight Length: 6 Minutes 9 Seconds Rating: 4.49 Description: This videos show you how to dynamically add a date stamp to a file name using SQL Server Integration Services expressions. It...

Using the File System Task in SSIS (Watch it Later!)
	Date Featured: December 01, 2008 Author: Brian Knight Length: 4 Minutes 6 Seconds Rating: 4.27 Description: This video by MVP Brian Knight shows you how to use a File System Task in SSIS to rename, move or delete a file. If you have ...

Secure FTP File Transfer in SSIS (Watch it Later!)
	Date Featured: April 15, 2009 Author: Tim Mitchell Length: 3 Minutes 49 Seconds Rating: 4.34 Description: Unfortunately, there are no native components in SSIS to support the secure (SFTP) transfer of files. This video will demons...