Wednesday Weekly #sqlserver Links for 2011-30

Being an Exceptional DBA Award 2011 Finalist « Chris Taylor’s SQL Server Blog

via chrisjarrintaylor.co.uk on 7/26/11

Article to:

 

     
 

COMMUNITY

 
     

The Tipping Point – DISTINCT Causes Timeouts

via weblogs.sqlteam.com on 7/26/11

Article to:

 

     
 

WARNING

 
     

Less Than Dot – Blog – A Cheat Sheet for All the *{_(%#$] PowerShell Punctuation

via blogs.lessthandot.com on 7/26/11

Article to:

 

     
 

POWERSHELL

 
     

SQLServerVideos – Free Videos to Learn Microsoft SQL Server

via www.sqlservervideos.com on 7/26/11

Article to:

 

     
 

WEBSITE

 
     

SQLServerVideos.com – Free Videos and Tutorials to help you learn Microsoft SQL Server. Watch over 4.5 hours of totally free SQL Server Videos and Tutorials. There’s nothing to buy, and there are no strings attached.

WMI Date Formats … PowerShell to the Rescue – richmac – Site Home – MSDN Blogs

via blogs.msdn.com on 7/26/11

Article to:

 

     
 

ALTERNATIVE

 
     

Announcing the System Administrator of the Year Contest

via www.windowsitpro.com on 7/26/11

Article to:

 

     
 

COMMUNITY

 
     

While you’re reading this article, hundreds of thousands of IT professionals around the world are configuring servers, fighting spam, answering help desk calls, and helping keep websites like this one running. They often work long hours, come to work wh

SSC Database Size Survey

via www.surveymk.com on 7/26/11

Article to:

 

     
 

DISCUSS

 
     

Performance benchmarking: Explicit vs Implicit Transactions « TroubleshootingSQL

via troubleshootingsql.com on 7/26/11

Article to:

 

     
 

PERFORMANCE

 
     

Women in IT Community Contributor of the Year Award – Catherine Eibner – Site Home – MSDN Blogs

via blogs.msdn.com on 7/26/11

Article to:

 

     
 

COMMUNITY

 
     

CRM, Axapta, Dynamics, SSIS, GirlGeekDinners, GeekGirlBlogs, BizSpark, Startup, Early Adoption programs,

OMG I’m an MVP! | The SQL UPDATE Statement

via sqlchicken.com on 7/26/11

Article to:

 

     
 

COMMUNITY

 
     

I can’t believe it, but I can finally say that I’m now officially a Microsoft SQL Server MVP! Last week I got the great news from my MVP lead, Ryan Bolz

Using SMO Transfer Class to Script Database Objects | Sev17

via sev17.com on 7/26/11

Article to:

 

     
 

RESPECT

 
     

Connection Loss Errors in SSMS Query Editor – SQL Server Manageability Team Blog – Site Home – MSDN Blogs

via blogs.msdn.com on 7/26/11

Article to:

 

     
 

WARNING

 
     

SQL in the Wild » Blog Archive » Goodbye IsNumeric hell

via sqlinthewild.co.za on 7/26/11

Article to:

 

     
 

ALTERNATIVE

 
     

SQL Q & A: Tales of Transactions

via technet.microsoft.com on 7/26/11

Article to:

 

     
 

RESPECT

 
     

Execution Characteristics of Extended Stored Procedures

via msdn.microsoft.com on 7/26/11

Article to:

 

     
 

RTFM

 
     

Gaining Speaker Experience Credentials, Part II – K. Brian Kelley – Databases, Infrastructure, and Security – SQLServerCentral.com

via www.sqlservercentral.com on 7/26/11

Article to:

 

     
 

CAREER

 
     

Book Review: Getting Things Done | Doug Lane

via www.douglane.net on 7/26/11

Article to:

 

     
 

CAREER

 
     

How to Be a Superstar: Change a Few Well Placed Things That Make a Difference | Brent Ozar PLF

via www.brentozar.com on 7/26/11

Article to:

 

     
 

RESPECT

 
     

As a database administrator or developer, you can be invisible if you plug away at providing standard support for your job. Make yourself a superstar: here’s how to identify a few changes you can make to set yourself apart.

Do You Want to be a Certified SQL Server Database Development Expert

via www.mssqltips.com on 7/26/11

Article to:

 

     
 

EDUCATION

 
     

Do you want to distinguish yourself as a database developer on the SQL Server 2008 platform? Consider studying for and passing the 70-433 exam. The Microsoft Learning site recommends the exam for those writing T-SQL code for database solutions. The exam e

Linchi Shea : Performance impact: stored procedures, SQL batches, and CPU usage

via sqlblog.com on 7/26/11

Article to:

 

     
 

WARNING

 
     

What is the simplest way to drive a CPU to 100% using T-SQL? If it’s a language like C++ or C#, the simplest way is to create a tight loop and perform some work that uses CPU cycles inside the loop. For instance, the following tight loop in C# can peg

Gaining Speaker Experience Credentials, Part II – K. Brian Kelley – Databases, Infrastructure, and Security – SQLServerCentral.com

via www.sqlservercentral.com on 7/26/11

Article to:

 

     
 

CAREER

 
     

Online non-NULL with values column add in SQL Server 11

via rusanu.com on 7/26/11

Article to:

 

     
 

DENALI

 
     

Author: Remus Rusanu Subject:SQL Server Blog

CLR Performance Testing

via www.simple-talk.com on 7/26/11

Article to:

 

     
 

WARNING

 
     

Configuring the Storage Subsystem

via www.simple-talk.com on 7/26/11

Article to:

 

     
 

BOOKMARK

 
     

DOS Batch File Date and Time

via www.gethynellis.com on 7/26/11

Article to:

 

     
 

ALTERNATIVE

 
     

Gethyn Ellis – SQL Server DBA in the UK – IT blog and website

Bob Beauchemin’s Blog | A row-level and label security offering for SQL Server

via www.sqlskills.com on 7/26/11

Article to:

 

     
 

TOOL

 
     

SSMS – Query Result configuration – Generate comma separated output without BCP or query changes – Nakul’s Blog

via beyondrelational.com on 7/26/11

Article to:

 

     
 

ALTERNATIVE

 
     

I have maintained that SSMS has a lot of underappreciated features, and that most of the community is not utilizing SSMS to it’s maximum potential. Today, I will show you how a simple configuration change helped in speeding up one of the most common tasks

Introducing the Extended Events Reader – Using SQL Server Extended Events – Site Home – MSDN Blogs

via blogs.msdn.com on 7/26/11

Article to:

 

     
 

DENALI

 
     

Linchi Shea : Performance impact: implicit type conversions

via sqlblog.com on 7/26/11

Article to:

 

     
 

WARNING

 
     

Often you see an implicit type conversion or a type mismatch causing a performance issue when it trips up the SQL Server query optimizer. A while back though, I ran into a case where a harmless looking type mismatch caused significant performance degradation

Using FILESTREAM with Other SQL Server Features

via msdn.microsoft.com on 7/26/11

Article to:

 

     
 

RTFM

 
     

A Big Milestone-SQLSaturday #100 | SQLAndy

via www.sqlandy.com on 7/26/11

Article to:

 

     
 

COMMUNITY

 
     

Five mistakes companies make in SQL Server upgrades

via searchsqlserver.techtarget.com on 7/26/11

Article to:

 

     
 

WARNING

 
     

Think your SQL Server upgrade will be a cinch? Well, it can, but thing can – and do – go wrong. Learn what not to do when moving from one SQL Server version to another.

Microsoft Certified Master Reading List – SQLServerPedia

via sqlserverpedia.com on 7/26/11

Article to:

 

     
 

EDUCATION

 
     

Statistics Used by the Query Optimizer in Microsoft SQL Server 2008

via msdn.microsoft.com on 7/26/11

Article to:

 

     
 

MICROSOFT

 
     

Online non-NULL with values column add in SQL Server 11

via rusanu.com on 7/26/11

Article to:

 

     
 

DENALI

 
     

Author: Remus Rusanu Subject:SQL Server Blog

Analyzing I/O Characteristics and Sizing Storage Systems for SQL Server Database Applications

via technet.microsoft.com on 7/26/11

Article to:

 

     
 

MICROSOFT

 
     

Gaining Speaker Experience Credentials, Part II – K. Brian Kelley – Databases, Infrastructure, and Security – SQLServerCentral.com

via www.sqlservercentral.com on 7/26/11

Article to:

 

     
 

CAREER

 
     

 

 

About Robert Matthew Cook

Hello, my name is Robert Matthew Cook. This blog is autoposted to from my main blog at www.sqlmashup.com. For more profile information or to leave a comment, please visit me there.
This entry was posted in Uncategorized. Bookmark the permalink.