Welcome to SQLShare

Featured Video

Auditing your SQL Server Logins for Blank Passwords In this video Brian takes us through finding blank password for your SQL Server Logins. He shows you how to write a script using the sys.logins views and a what not to do when trying to find blank passwords.	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

Auditing your SQL Server Logins for Blank Passwords (Watch it Later!)
	Date Featured: January 27, 2012 Author: Brian Kelley Length: 5 Minutes 21 Seconds Rating: 4.45 Description: In this video Brian takes us through finding blank password for your SQL Server Logins. He shows you how to write a script us...

Collections Explained (Watch it Later!)
	Date Featured: January 26, 2012 Author: Tim Mitchell Length: 2 Minutes 59 Seconds Rating: 4.20 Description: This video introduces collections in .NET.

The Default Trace in SQL Server 2005 (Watch it Later!)
	Date Featured: January 25, 2012 Author: Brian Kelley Length: 2 Minutes 20 Seconds Rating: 4.23 Description: In this video Brian covers the default trace for SQL Server 2005. The default trace is used to capture events on a sql server...

Creating Hierarcies with HierarchyId in SQL Server 2008 (Watch it Later!)
	Date Featured: January 24, 2012 Author: Plamen Ratchev Length: 3 Minutes 9 Seconds Rating: 3.95 Description: SQL Server 2008 adds a new feature to help with modeling hierarchical relationships: the HIERARCHYID data type. It provides c...

Reporting Services Formatting Codes (Watch it Later!)
	Date Featured: January 23, 2012 Author: Jessica Moss Length: 3 Minutes 46 Seconds Rating: 4.19 Description: Formatting data in a Reporting Services 2008 report is as simple as typing a couple of letters! SQL MVP Jessica Moss will sh...

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.26 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 ...

Filtered Indexes in SQL Server 2008 (Watch it Later!)
	Date Featured: November 03, 2008 Author: Plamen Ratchev Length: 3 Minutes 13 Seconds Rating: 4.37 Description: Filtered indexes are another welcome addition in SQL Server 2008. They allow creating an index filtered with WHERE clause. Wh...

Adding a Windows Based Login to SQL Server (Watch it Later!)
	Date Featured: December 15, 2008 Author: Brian Kelley Length: 1 Minutes 53 Seconds Rating: 3.97 Description: Using Windows logins is a great way to leverage the investment in a Windows domain. Did you know that you can add domain user...

SQL Server Authentication Modes (Watch it Later!)
	Date Featured: December 15, 2008 Author: Brian Kelley Length: 3 Minutes 27 Seconds Rating: 4.16 Description: Do you know your options for logging in (authenticating) to a SQL Server? Brian discusses the options and in later videos dig...

SQL Server System Functions (Watch it Later!)
	Date Featured: January 28, 2009 Author: Andy Novick Length: 4 Minutes 55 Seconds Rating: 3.76 Description: This video introduces some of the system functions like fn_virtualfilestats and fn_listextendedproperty. Some of these have b...