sqlmashup-blog
sqlmashup
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.
594 posts
Don't wanna be here? Send us removal request.
Last Seen Blogs
lailavan12
Untitled
parisworld-surat
Parisworld.in
girlyverse
GirlyVerse
wind-and-cloud
delete, delete
dreamcloud12
DreamDoll12
Text
PostgreSQL DBA
no more blogging at this site as I begin learning the ropes as a new postgresql dba. cheers!
0 notes
Text
Tammy
Today would have been my sister's 43rd birthday. I love you Tammy!
0 notes
Text
Time
There is an illness in the family which has been the focus of my time.
0 notes
Text
Wednesday Weekly #sqlserver Links for 2011-40
Wednesday Weekly #sqlserver Links
Grab a plate and load it up.
Current Feed Content
Tagged as [ADMIN]
SQL Server Database SUSPECT state - SQL Server DBA
According to BOL , a database in SUSPECT state is : “At least the primary filegroup is suspect and may be damaged. The database cannot be recovered during startup of...
How to Create Secure SQL Server Service Accounts
I'm looking to install SQL Server and I know it will require a service account. In this tip we cover what should be done to configure the SQL Server service accounts...
Getting Started with Utility Control Point in SQL Server 2008 R2 — DatabaseJournal.com
Utility Control Point can help SQL Server DBAs in multi-server administration.
Tagged as [CAREER]
A Good Time to Be a SQL Server Professional - Pearl Knows - SQLServerCentral.com
Webpage without description
Tagged as [COMMUNITY]
Wise man or Wise guy? You decide: Me an MVP? It Really Happened
Webpage without description
Todd McDermid's Blog: A "New Guy" Joins Our Team
Webpage without description
Completed 5 Years at MS | Vinod Kumar (Blog home)
Webpage without description
What do you want to see from your PASS board? Me?
Many of you know recently the PASS board announced that elections will be coming up for three seats
Joe Sack's Blog | New Adventures with SQLskills
Webpage without description
Congratulations New and Re-Awarded MVP Awardees! - The Microsoft MVP Award Program Blog - Site Home - MSDN Blogs
Microsoft Most Valuable Professionals (MVPs) are exceptional technical community leaders from around the world who are awarded for voluntarily sharing their high...
Tagged as [DENALI]
SQL Server Native Client Support for High Availability, Disaster Recover
Webpage without description
Bob Beauchemin's Blog | LOTS of New Goodies in SQL Server Denali Query Plans
Webpage without description
Bob Beauchemin's Blog | Additional Warnings in SQL Server Denali Query Plans
Webpage without description
Tagged as [DISCUSS]
Just Ship it.
Good enough is almost always better than nothing at all. Many of you will smile and nod sagely when you read that. Sure, that seems pretty obvious. But many people...
October Question: What one thing do you feel has the greatest impact on SQL Server’s performance? | SQL Aloha
Brad M. McGehee, Director of DBA Education, Red Gate Software
Forums
Forums
Tagged as [EDUCATION]
Free SQL Server Community October 2011 Training « Dan English's BI Blog
Webpage without description
SQL In The City: LA | Home Of The Scary DBA
Webpage without description
Registration - SQL Server PowerShell Extensions
Webpage without description
Tagged as [GEEK]
Keyboard Shoes - QWERTY - Pics | Geekosystem
If only you could write the next great American novel while taking a walk in the park. Well, now, you still can't, but you can take a walk in the park in these kick-ass...
Harald Haas: Wireless data from every light bulb - YouTube
Webpage without description
The Stack Exchange Architecture – 2011 Edition, Episode 1 - Server Fault Blog
Webpage without description
Tagged as [HUMOR]
Make It Sexy - Celebrity Pictures, Lol Celebs and Funny Actor and Actress Photos - ROFLrazzi
funny celebrity pictures - Apparently only one ship came equipped with a gym.
If Super Mario Bros. Had Been Designed in 2011 | ChurchMag
Exploring the Intersection of Church and Technology
Tagged as [MSFT]
SQL Server Technical Paper
Webpage without description
Tagged as [MULTIMEDIA]
SQLBits 9 Slidedeck for READPAST & Furious |
Webpage without description
24 HOP recordings | Dukagjin Maloku – Dugi'SQL
Webpage without description
Klaus Aschenbrenner - Slides & Samples for my SolidQ Summit Sessions
Webpage without description
Virtual TechDays Slides on AlwaysOn and Good Practices « Help: SQL Server
Webpage without description
Tagged as [RESPECT]
A Performance Troubleshooting Methodology for SQL Server
Webpage without description
Tagged as [RTM]
Deprecated Database Engine Features in SQL Server 2008 R2
Webpage without description
Logical and Physical Operators Reference
Webpage without description
Tagged as [SCRIPT]
Audit VLFs on your SQL Server | youdidwhatwithtsql.com
I've been reading a bit about VLFs (Virtual Log Files) this week. I've found quite a few interesting links, especially this one, informing us that there's such
Moving TempDB can be easy but tricky « sqlconcept.com
Webpage without description
Tagged as [SITE]
SQL Server Days 2011 | November 14-15, 2011
The largest SQL Server event in the Benelux
SQL Server events
All SQL Server events around the globe
Tagged as [SQLPASS]
Attend the PASS Summit from Home, 2011 edition | SQL Awesomesauce
Hidy-ho there, neighbors! This is an update of last year's Attend the PASS Summit from Home blog. I'll be updating this over the next few days, so keep your
PASS Summit 2011 – Birds of a Feather! | Straight Path Solutions, a SQL Server Consultancy
Howdy! The 2011 SQL PASS Summit is fast approaching. I'm happy to have been able to volunteer to help do some coordination of the Birds of a Feather lunch again
PASS 2011 Photowalk | Sql Server Insane Asylum
Webpage without description
Don’t pass by PASS Summit 2011! - SQL Server Team Blog - Site Home - TechNet Blogs
Insider news about SQL Server and Microsoft's Informaton Platform
SQL Karaoke 2011 powered by NEC and Genesis Hosting Solutions - SQL Server with Mr. Denny
So this is the all important SQL Karaoke wrist band post. In order to get your SQL Karaoke wrist band you must head over the NEC booth on Wednesday during the...
Tagged as [WARNING]
Yet another cause of Kerberos authentication failure connecting to SQL Server - Data, Design, and SQL Server - Site Home - MSDN Blogs
SQL Server and database design
After Applying SQL Server 2008 R2 SP1 Error 9013 is logged (The tail of the log for database %ls is being rewritten to match the new sector size of %d bytes …) - CSS SQL Server Engineers - Site Home - MSDN Blogs
Webpage without description
0 notes
Text
T-SQL Tuesday #23 – Joins #tsql2sday
T-SQL Tuesday
The host for this week early blog party is Stuart Ainsworth. You can click on the image above to read the invitation and about the topic of JOINS. You can also find there within the comments, links to the posts of all participants. You could also just wait for the round-up to be posted. For a round-up of round-ups please see this page by the blog party godfather Adam Machanic, A Year of Tuesdays: T-SQL Tuesday Meta-Roundup
Joining
If you have experience with joining the military then thank you sir or ma’am but as a SQL Server DBA you are sure to have experience with joining tables using Transact-SQL. My first blog post was on this exact same subject and this post will be a condensed version of it, SQL Server Joins using Playing Cards There are three primary JOIN operators the Query Optimizer will pick from: Nested Loops, Merge Join and Hash Match.
Nested-Loops
Imagine you were asked to find all the Aces in a deck of cards. How would you accomplish that? You would probably flip them all over and scan across them looking for the Aces. You would likely do the same if you were told that this would repeat for three, four or five different ranks. What if you were told it would be for eleven, twelve or even all thirteen different ranks?
Hash Match
If you were going to match many different ranks then you would probably decide scanning would be too repetitive. Instead you might break the deck into a pile for each rank. The time it took to reorganize the cards will be made-up by not having to look at every single card when another rank is asked for. What if you were told to match all fifty-two cards one-to-one between two decks?
Merge Join
We need to take a small leap of faith to continue using this card matching analogy. For now image that you have the ability to perform a perfect shuffle, where exactly one card from each the left and the right stacks fall together through-out the entire shuffle. If you had to find all fifty-two card matches you would likely go with a Hash Match but now that you are bestowed with the gift of Perfect Shuffle you have a better option. You quickly sort each deck then perform a perfect shuffle and BAM! The analogy is more appreciable when the cards are already sorted or the number of them is much higher than fifty-two.
See Also
Physical Join Operators in SQL Server – Nested Loops - SQL Server Performance
Physical Join Operators in SQL Server – Hash Operator - SQL Server Performance
Physical Join Operators in SQL Server – Merge Operator - SQL Server Performance
Nested Loops Join - Craig Freedman's SQL Server Blog - Site Home - MSDN Blogs
Hash Join - Craig Freedman's SQL Server Blog - Site Home - MSDN Blogs
Merge Join - Craig Freedman's SQL Server Blog - Site Home - MSDN Blogs
People
Stuart Ainsworth
Adam Machanic
Ami Levin
Craig Freedman
0 notes
Text
Wednesday Weekly #sqlserver Links for 2011-39
Wednesday Weekly #sqlserver Links
Help yourself to this link feast.
Current Feed Content
Tagged as [ADMIN]
Less Than Dot - Blog - Tips and Tricks to Make SQL Server Management Studio Awesome
Webpage without description
Semicolon
Not terminating T-SQL statements with a semicolon is on a deprecation path.
Tagged as [ALTERNATIVE]
Stored Procedures vs Functions (Difference between SP & UDF) « SQL Server Programming, Tips & Tricks
Webpage without description
Find Last Restart of SQL Server
How can I tell when my SQL Server instance was last started? In this tip we look at various methods of how to get the start time for a SQL Server instance.
Tagged as [BOOKMARK]
PowerShell working with SQLPS or SMO… | Max Trinidad – The PowerShell Front
Webpage without description
Tagged as [CAREER]
Arnie Rowland: Ramblings of a Harried Technogeek : 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,...
Tagged as [COMMUNITY]
Data Head | SQL RNNR
Well, it's official. I am a Data Head. It doesn't change too much my level of geekiness. But I may have to rethink one of the answers given during that
What is a Microsoft Regional Director? | James Serra's Blog
Explains what a Microsoft Regional Director is.
My first presentation - a recap | Cleveland DBA
Webpage without description
Tagged as [DENALI]
Bob Beauchemin's Blog | SQL Denali T-SQL features in SQL Azure now
Webpage without description
Rows or Range, What’s the difference ? - SQL and the like
Dave Ballantyne's blog. Freelance SQL Server database designer and developer at Clear Sky SQL
Tagged as [DISCUSS]
The PowerPivot Data MashUp Contest Is Here! - Microsoft Business Intelligence - Site Home - MSDN Blogs
Webpage without description
Aaron Bertrand : Connect Digest : 2011-09-22
Where is SYSDATE()? I've talked about this one before, but due to a recent conversation about building a datetime value from separate date/time columns or variables,...
September Performance Contest | SQL RNNR
This month SafePeak is sponsoring a contest centered around improving performance in SQL Server. The host of the contest is my friend Robert Pearl. You can
Tagged as [EDUCATION]
SQL In The City is comming - SQL Server with Mr. Denny
RedGate's SQL In The City is coming to the amazing Skirball Center in Los Angeles just a couple of weeks after the PASS summit. This is a great change to see...
The SQL Server Conference - SQLBits - Query across the Mersey - 29 Sep 2011 - 1 Oct 2011 - Liverpool
SQL Server Free Community Conference brought to you by the top MVPs and speakers in the UK covering all aspects of Microsoft SQL Server from Business Inteligence,...
Tagged as [GEEK]
Lego's augmented reality at IDF, eyes-on (video) -- Engadget
It's not as cool as Chipzilla's other augmented reality project, but at least this one exists out in the real world. Present at branded storefronts
Getting Up and Running with the TFS 2010 Object Model - The Microsoft MVP Award Program Blog - Site Home - MSDN Blogs
Microsoft Most Valuable Professionals (MVPs) are exceptional technical community leaders from around the world who are awarded for voluntarily sharing their high...
Tagged as [MASHUP]
SQL in the Wild » Blog Archive » 24 Hours of PASS Questions
Webpage without description
SQL Server Wait Types in SQL 2008 | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
SQL Server Citation is a SQL Server blog by Hemantgiri S. Goswami, Surat,India. He is a SQL Server Specialist and SQL Server MVP,Author, President and Leader of Surat...
more examples on querying XML data « SQL Server Programming, Tips & Tricks
Webpage without description
List of blogs - Karthick PK 's Blog - Site Home - MSDN Blogs
Webpage without description
SQL Stuff: continuous integration
Webpage without description
Life, The Universe and SQL Server: Links for Presentations
Webpage without description
Tagged as [MSFT]
Limited support options might be available for certain versions of SQL Server
Describes that support options may be limited for certain versions of SQL Server.
Tagged as [MULTIMEDIA]
SolidQ Journal September Edition - SQL Server BI Blog - SQLServerCentral.com
Webpage without description
PASS - The Professional Association for SQL Server > Learning Center > Session Recordings > 24 Hours Fall 2011
Webpage without description
Kendra Little Explains How to Design Smarter Indexes | Brent Ozar PLF | Brent Ozar PLF
How do you know which indexes to create to improve your database performance? Microsoft Certified Master Kendra Little shows you how to find a missing index,
Tagged as [PERFORMANCE]
About Sql Server » Blog Archive » Locking in Microsoft SQL Server (Part 9 - Optimistic transaction isolation levels - TANSTAAFL!)
Webpage without description
Tagged as [RESPECT]
SirSQL.net - Blog - Optimizing Database Restores
Webpage without description
SQL PowerShell Demo - Intro - Cindy Gross - Troubleshooting, tips, and general advice about SQL Server - Site Home - MSDN Blogs
SQL Server troubleshooting, tips, techniques, and advice
Tagged as [RTM]
sys.dm_exec_sessions (Transact-SQL)
Webpage without description
SQL Azure Overview
Webpage without description
Tagged as [SCRIPT]
Using Power Shell to script out Replication - REPLTalk covers Using and Tuning SQL Replication - Site Home - MSDN Blogs
Webpage without description
September 2011 SQL Server 2008 Diagnostic Queries | Glenn Berry's SQL Server Performance
Webpage without description
Tagged as [SITE]
SQL University | The SQL UPDATE Statement
Come learn SQL Server from the ground up! Great learning resource for new DBA's,accidental DBA's or experienced DBA's who want to refresh on their basics. This blogging...
Tagged as [SQLGPLUS]
Andy Leonard : Running in Circles – A Recap of My First MicroTraining Session
Earlier today I tried something new: a 30-minute training session using a Google+ Hangout (with extras). The extras include screen-sharing, so I was able to show...
MicroTraining: Performance Tuning Checklist | Home Of The Scary DBA
Webpage without description
Tagged as [SQLPASS]
Know when to hold ‘em « Voice of the DBA
Webpage without description
Stacia Misner : So Many Choices, but Only One of Me! PASS Summit 2011 Picks
It’s that time of year again when the anticipation of the upcoming PASS Summit begins to build. My first attempt at using the Summit Schedule Builder by selecting...
PASS Board Applications Open October 5
Normal 0 false false false EN-US X-NONE X-NONE
Tagged as [TOOL]
SSMS Tools Pack 2.0 is out! | Jason Crider
I know I’m a little late on mentioning that this great resource has been updated. Hopefully I can do a series on “tools in your SQL Toolbox” someday, but for ...
RML Questions - CSS SQL Server Engineers - Site Home - MSDN Blogs
Webpage without description
Tagged as [WARNING]
In Recovery... | How does daylight savings time affect disaster recovery?
Webpage without description
SQL Server Customer Advisory Team - SQL Server Best Practices
SQL Server best practices, whitepapers and deep technical lessons learned from large SQL Server customer implementations
Replication DDL Triggers - Never Say Never
Because this was a problem that Google was zero help on and I did find a couple other people afflicted with it, I figured I’d write a post about it. The issue was...
0 notes
Text
Wednesday Weekly #sqlserver Links for 2011-38
Wednesday Weekly #sqlserver Links
Here are some yummy links from this week.
Current Feed Content
Tagged as [ADMIN]
SQL University: Architecture for Small Businesses | The SQL UPDATE Statement
This post covers general architecture advice for small businesses (SMB) looking to use SQL Server as their database platform of choice.
Configuring SQL Server to Use Multiple Ports
In this tip we walk through how to configure a SQL instance to listen on multiple TCP/IP ports.
Paul White: Page Free Space : How to Find the Statistics Used to Compile an Execution Plan
Webpage without description
Tagged as [ALTERNATIVE]
The ‘smart’ delete « sqlconcept.com
Webpage without description
Tagged as [BOOKMARK]
Aaron Bertrand : Want your bug fixed? File a good bug!
In some circles I'm known as "the Connect guy" because I've filed a heck of a lot of suggestions and bugs that I've envisioned or encountered, and I'm often willing...
InformIT: SQL Server Reference Guide > The SQL Server Sample Databases: AdventureWorks
Webpage without description
Tagged as [CAREER]
Andy Leonard : The Sky Is Falling
Alarmist? Perhaps. Accurate? In one sense, but not in the most important sense. The Cloud is coming. Are you ready? “Figures Don’t Lie” – Foghorn Leghorn Consider the...
Exam Taking Tips for Certification - Canadian Solution Developers' Blog - Site Home - MSDN Blogs
Webpage without description
6 Blog Projects to Improve Your Writing | Brent Ozar PLF | Brent Ozar PLF
You're stuck in a rut. You've been writing the same thing for the same way for months. You've deluded yourself into thinking you've built up a style
Tagged as [COMMUNITY]
Father of SQL Server? - LivingForSqlServer - SQLServerCentral.com
Webpage without description
Jeff Moden is the Exceptional DBA 2011! « spaghettidba
Webpage without description
T-SQL Tidy Blog: National SQL Server Week
Webpage without description
Tagged as [DISCUSS]
PowerShell function in Policy-Based Management | Microsoft Connect
Policy-based management is a fantastic and powerful tool for administrators. As more and more companies are making their migrations to SQL Server 2008
Tagged as [EDUCATION]
SQL Server Customer Advisory Team - SQL Server Best Practices
SQL Server best practices, whitepapers and deep technical lessons learned from large SQL Server customer implementations
Check out Chicago’s SQL Server User Group. Some great, fresh content coming up! - Ravings of a Microsoft Evangelista - Site Home - MSDN Blogs
Microsoft Developer Technical Specialist blog
Registration - Essential Techniques for SQL Server Memory Management
Webpage without description
Tagged as [GEEK]
Sync Framework Toolkit now Open Source! - < Confessions of .NET Junkie Eric Golpe /> - Site Home - MSDN Blogs
Weblog of Eric Golpe, a Microsoft Consulting Services Application Development Senior Consultant
Ways to save money on Microsoft Software | James Serra's Blog
Different options to save money on Microsoft Software.
Tagged as [HUMOR]
Cabrones - YouTube
Webpage without description
DARTH_VADER_DOES_OFFICE_SPACE
Webpage without description
DILBERT_TESTS_THE_HUMOR_OF_THE_CEO
Webpage without description
Tagged as [MASHUP]
T-SQL Tuesday #22 Round-Up - Data Presentation - Pearl Knows - SQLServerCentral.com
Webpage without description
DBA Blogging With A Smile: 24 Hours of PASS: Answer questions…
Webpage without description
Reading list for the week - 19/09/11 | SQL Server DBA Diaries of Pradeep Adiga
Webpage without description
Rick Heiges : PASS Summit 2011 - What you can expect at the Conference - Summary
As I finish up preparing for the Sep 20 (@1pm ET) webcast, I thought a final blog post may be appropriate in order to quickly reference many of the areas that I have...
PASS | SQLRockstar | Thomas LaRock
Webpage without description
Tagged as [MSFT]
Considerations for the "autogrow" and "autoshrink" settings in SQL Server
Provides information regarding what happens when you select the "autogrow" setting and the "autoshrink" setting in SQL Server.
Potential causes of the "SQL Server does not exist or access denied" error message
Explains potential causes of the "SQL Server does not exist or access denied" error message.
FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005 or in SQL Server 2008
Fixes an issue in which a SQL Server Agent job stops after 00:00 in SQL Server 2005 or in SQL Server 2008. This issue occurs when you configure the job to run past...
a>
Tagged as [MULTIMEDIA]
SQL Server Sarah: SQL Saturday Atanta
Webpage without description
Tagged as [PERFORMANCE]
Indexed Views
To explain what an indexed view is, let's first look at what constitutes a view. A view may sound like a fancy elaborate thing, however all it is, is a saved...
The Pros and Cons of Parameter Sniffing
A look at the pros and cons of parameter sniffing, locked data, table scans, and query recompilation.
Tagged as [RESPECT]
When should you use NOLOCK? |
Webpage without description
SQL Server Memory Management Explained - SQLServerCentral
Free Microsoft SQL Server articles, news, forums, scripts and FAQs.
Database Mirroring for Disaster Recovery
If you’re currently using log shipping for disaster recovery, consider using asynchronous mirroring instead. Asynchronous mirroring offers enhanced manageability and...
Tagged as [RTM]
Connecting to SQL Server over the Internet
Webpage without description
Tagged as [SCRIPT]
SSIS Junkie : Delete all data from a database
Sometimes I use this blog to share scripts that I know I'm going to need at some point in the future, this is one of those times. The script below will remove all...
Tagged as [SITE]
DBA Twibe - DBA Twitter People
This page is for Twitter people interested in DBA. All things of interest to DBA's of SQL Server, Oracle, MySQL & DB2 databases. Also some fun things
Greplin | What can Greplin search?
Webpage without description
Tagged as [SQLPASS]
PASS First Timers Guide | SQL Awesomesauce
Hi there ho there everybody! I am now a Big Sister Fearless Leader of a group of PASS Summit first timers! This is the page wherein I record all of my sage
Announcing Inappropriate PASS Sessions 2011, which we are renaming P.U.S.S. Inappropriate Sessions, and which will be full of AWESOME | SQL Awesomesauce
Essential information: This is happening October 12, the week of the PASS Summit. The event goes from 7:00pm-10pm, but the sessions themselves
SQL Saturday in Las Vegas | SQL RNNR
SQL Community is getting a SQL Saturday training event in Las Vegas
Less Than Dot - Blog - Attending PASS Summit 2011? Want Lunch? And Free Career Advice? I Have Just The Event...
Webpage without description
Inside the SQL Server Clinic… - CSS SQL Server Engineers - Site Home - MSDN Blogs
Webpage without description
Tagged as [TOOL]
Making SQLNexus work smarter with Enterprise Edition - Gavin Payne
gavin payne uk
Tagged as [WARNING]
The Perils Of Try…Catch Blocks | Shaun J Stuart
The new Try...Catch T-SQL error trapping mechanism introduced in SQL 2005 is quite handy. But it does have some perils if you don't think things through
Overcome update conflict in P2P replication | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
SQL Server Citation is a SQL Server blog by Hemantgiri S. Goswami, Surat,India. He is a SQL Server Specialist and SQL Server MVP,Author, President and Leader of...
0 notes
Text
Wednesday Weekly #sqlserver Links for 2011-37
Wednesday Weekly #sqlserver Links
Biggest SQL Server feast to date so be sure to come back for seconds.
Current Feed Content
Tagged as [ADMIN]
How to prevent blocking in your SQL Server database | James Serra's Blog
Different solutions to prevent blocking in your SQL Server database.
Changes to automatic update statistics in SQL Server – traceflag 2371 - Running SAP Applications on SQL Server - Site Home - MSDN Blogs
This Blog will provide information about running SAP applications on SQL Server and Windows. The Blog is written by folks of Microsoft who are working with SAP and SQL...
SQL Marklar : How long is your downtime?
Webpage without description
Freccia's Blog
Webpage without description
Is your SQL Server in a VM?
Webpage without description
Tagged as [ALTERNATIVE]
When was the last time i run dbcc checkdb with sucess « Freccia's Blog
Webpage without description
Finding SQL VMs: Part 2
Webpage without description
Is your SQL Server in a VM?
Webpage without description
Tagged as [BOOKMARK]
Mythbusting: Concurrent Update/Insert Solutions
I'm comparing different methods of writing an insert/update stored procedure that will perform well concurrently.
Tagged as [CAREER]
The Top Ten Skills You Need for SQL Server « Voice of the DBA
Webpage without description
The Modern History of the Resume [INFOGRAPHIC]
While the look and feel of the resume has been quite constant for most of modern history, the resume has recently been turned on its head to including infographic,...
Gone Fishin’
Webpage without description
Tagged as [COMMUNITY]
Everything Else Blogs « Most Valuable Blogger « CBS Chicago
Webpage without description
WARDY IT Solutions Blog : SQL Server Centre of Excellence
With all of the awards that WARDY IT Solutions has recently won there has been a running joke about changing the company name to 'Awardies'. On the back of being...
The sqlhelp hash tag and sponsored tweets.
Please don't. It isn't that we hate marketing, but the sqlhelp hash tag is for Q&A only. All the other hash tags are totally fair game, but...
Tagged as [DENALI]
The Case to Upgrade to SQL Server Denali
See if SQL Server Denali’s features, such as AlwaysOn, SQL Server Developer Tools, and columnar indexes, are compelling enough to justify upgrading to the new release.
Lee Everest's SQL Server, etc. weblog | Submit SQL Server Denali feedback at connect.microsoft.com
Webpage without description
Microsoft’s Commitment to Interoperability - SQL Server Team Blog - Site Home - TechNet Blogs
Insider news about SQL Server and Microsoft's Informaton Platform
It’s a File System… It’s a Database Table… It’s SQL Server Denali FileTable! « Lenni Lobel on SQL Server and .NET Development
Webpage without description
XEVENT Provider in Denali
XEVENT provider is new sqlps provider in Denali CTP3. To admit, I was surprised when I saw it. In SQL Server 2008R2 we don’t have any GUI for XEVENT (Extended...
Tagged as [DISCUSS]
September Question: Tell us about your DBA interview experiences: good and bad. | SQL Aloha
Brad M. McGehee, Director of DBA Education, Red Gate Software
Feedback Requested: Interest in Instructor-Led Online Training - Microsoft Certified Master: SQL Server 2008 - Advanced Certifications - Born to Learn
Webpage without description
SQL Server Performance – September Story Contest 2011
Webpage without description
Tagged as [EDUCATION]
Following Capacity Crowds in London, Red Gate Brings SQL in the City to LA | Business Wire
Following capacity crowds in London, Red Gate is bringing SQL in the City to Los Angeles on October 28 at the Skirball Cultural Center in LA’s S
Did You Know? I’ll be teaching my Internals Class online!
In my most recent commentary for SQL Server Magazine, online here: http://www.sqlmag.com/article/training-and-certification2/sql-server-training... ,...
Tagged as [GEEK]
T-SQL Tidy Blog: How to write a SQL Server Management Studio Add-in for Denali (CTP3) (Part 2)
Webpage without description
Google APIs Client Library for .NET Beta is now available for Download | Ginktage
Google has released its Google API's Client Library for .NET Beta SDK which is now which is now available for download from Code.google.com Google APIs Client Library...
SQL Server 2008/R2 & F1 – A Microsoft Case Study on how FILESTREAM can create a formula for performance, integrity & robustness
Formula1 is the pinnacle of motorsports – a test of performance, integrity & robustness. The cars on the race track are technological marvels – they contain...
Tagged as [HUMOR]
USB_REBEL
Webpage without description
Bill Gates Saves Up for a Lamborghini at gcmouli.com
Webpage without description
Pointy-haired bosses & SQL
Not my usual type of blog post but I couldn't resist sharing this! Thanks to Scott Barrett . (Hopefully that doesn't instantly remind you of your boss!!)
Tagged as [MASHUP]
SQL Server Graphical Query Plans Tutorial
In this tutorial we will cover how to create SQL Server graphical query plans and how to read them to assist in tuning your queries.
Stairway to Transaction Log Management in SQL Server, Level 3: Transaction Logs, Backup and Recovery - SQLServerCentral
Webpage without description
A list of Microsoft's Official Twitter Accounts - Tips and tricks: ASP.NET, IIS and .NET development... - Site Home - MSDN Blogs
This blog focus on web development using ASP.NET and IIS. Also, I am sharing my notes for Visual Studio and ISA / TMG. Please comment for better blog activity.
Tagged as [MSFT]
Top 10 Hidden Gems in SQL Server 2005
Webpage without description
Statistics Used by the Query Optimizer in Microsoft SQL Server 2008
Webpage without description
Tagged as [MULTIMEDIA]
Does This Transaction Log Make My Database Look Fat? | Brent Ozar PLF | Brent Ozar PLF
Face it; your database doesn't get much exercise. It spends its day sitting on the same old server in the same old rack eating garbage all day long. Sure once
SQL Server Execution Plans - Grant Fritchey
Webpage without description
Slides For My 24 Hours of PASS Session
Webpage without description
Tagged as [PERFORMANCE]
Table Variables and Parallel Plans - Grumpy Old DBA - Beware the darkside !
Thoughts on the life of a Production SQL Server DBA Colin Leversuch-Roberts
Joins Hints, joins algorithms, and Join hint syntax explained
Webpage without description
Tagged as [RTM]
Forced Parameterization
Webpage without description
Tagged as [SCRIPT]
Dealing With Multiple Filegroups
Everything is good in moderation, and when it comes to having multiple filegroups in your database, I believe this to be true there as well. Having multiple
A better sp_MSForEachDB
Webpage without description
Tagged as [SQLGPLUS]
PASS Summit 2011 Attendees - Google Docs
Webpage without description
Tagged as [SQLPASS]
San Francisco and Silicon Valley SQL Server User Groups
Check out this short YouTube video to learn more about the San Francisco and Silicon Valley SQL Server User Groups!
SQLSaturday #97 Speaker Selection Process | SQL Server Input/Output
Webpage without description
The 2011 SQLServerCentral Party at the PASS Summit - SQLServerCentral
Free Microsoft SQL Server articles, news, forums, scripts and FAQs.
PASS Summit 2011 Alumni - Support now! - Twibbon.com
Support PASS Summit 2011 Alumni - Say it loud, say it proud: You're a seasoned veteran of the world's ultimate SQL Server and BI training and networking event. Help...
PASS 2011 Countdown – 5 Weeks To Go | Strate SQL
We are now 5-weeks from this years PASS Summit. It’s time to start getting ready for the event. Hopefully, you have already registered for the
Who's Coming
PASS Summit 2011
PASS Summit 2011 - Monday Night Networking Dinner - Eventbrite
presents PASS Summit 2011 - Monday Night Networking Dinner -- Monday, October 10, 2011 -- Seattle, WA
The SQL PASS Summit comes again to Seattle and CSS will be there… - CSS SQL Server Engineers - Site Home - MSDN Blogs
Webpage without description
PASS Update #64 (Officer Elections)
Webpage without description
SQLSaturday #97 Speaker Selection Process
Webpage without description
Tagged as [TOOL]
Great Tools for Formatting T-SQL | SQL Awesomesauce
I have a big rant I add to....well, to every single SQL session I give. That rant is on formatting code. You see, (I say,) you can't even begin to understand or
SQLjobvis - Visualize your SQL Server Agent Job History
SQLjobvis is the SQL Server Agent job history viewer with a difference.
SQL Server 2005: TableDiff.exe GUI
Webpage without description
Tagged as [WARNING]
EXECSYNC progress | Cleveland DBA
Webpage without description
SQL Server 2008/2008 R2 on Newer Machines with More Than 8 CPUs Presented per NUMA Node May Need Trace Flag 8048 - CSS SQL Server Engineers - Site Home - MSDN Blogs
Webpage without description
Why is SQL Server Configuration Manager Missing Services
When I open SQL Server Configuration Manager (SSCM) I see no services displayed (or just Integration Services). How can I resolve this quickly? Check out this tip...
0 notes
Text
T-SQL Tuesday #22 – Data Presentation #tsql2sday
T-SQL Tuesday
Robert Pearl has heeded the call of hosting the T-SQL Tuesday blog party this month. Please click on the #tsql2day image above to learn more about why the topic is "data-presentation". If you want to read more party-style blog posts then also check out the summary by Adam Machanic called A Year of Tuesdays: T-SQL Tuesday Meta-Roundup.
Presents
Who presents the data to your users? There are occasions when the DBA will be asked to write T-SQL for Manipulating Result Sets. Mr. Pearl mentioned having experience with Using Common Table Expressions in the invitation. I had a similar experience with Using GROUP BY with ROLLUP, CUBE, and GROUPING SETS. Who should present data to the users? Although this blog party has T-SQL in the title this post will be more theoretical than practical.
Tiers
There are always exceptions to any rule but as a general rule I subscribe to the N-Tier / Multi-tier architecting of applications. There are entire books about the benefits but for the sake of a short post I would like to share just two benefits of this architecture for a DBA. If you plan to stay for the soapboxing then please take a minute and look over this diagram by Damon Armstrong on Multi-tier architecture from his post .NET Application Architecture: the Data Access Layer.
Tools
Transact-SQL and SQL Server are used to scatter and gather data. CLR and Business Objects are used for control flow logic. Windows Presentation Foundation and Forms/Controls are used for user interface presentation. Each is a great tool for performing their intended task. You have NEVER used a crescent wrench as a hammer right? In the same tongue in cheek tone, you such NEVER use T-SQL to figure out the next user product suggestion and NEVER use T-SQL to display a dollar sign on the right side of a number.
Really?
Let us pretend that you inherited a stored procedure that does format the output so that there is a dollar sign displayed on the right side of a number. Who do you suppose would be tasked if the user wanted a different format? (Euros, two decimal places, in millions, negatives in parenthesis) Each of these has the potential to become a major time suck and also cause some wicked stored procedure sprawl. It has happened, it is still happening and will probably continue to happen but hopefully you are better informed for avoiding the problem.
People
Robert Pearl
Adam Machanic
Damon Armstrong
Welcome to the show
0 notes
Text
#powershell deepest folder top 1 alphabetical
Get-ChildItem -path "C:\getdeepestfolder\top1alphabetical\" -recurse | Sort-Object -property @{Expression={[regex]::matches($_.FullName, "\\").count}; Ascending=$false} | Select-Object -property "FullName" -first 1
0 notes
Text
Wednesday Weekly #sqlserver Links for 2011-36
Wednesday Weekly #sqlserver Links
Free buffet of some great content seen this week.
Current Feed Content
Tagged as [ADMIN]
Shrinking Transaction Logs « Tradney's Blog
Webpage without description
Microsoft: TPC Should Also Measure Database Availability | PCWorld Business Center
The Transaction Processing Performance Council should add an additional metric for availability to its set of database performance benchmarks, Microsoft...
Tagged as [ALTERNATIVE]
Checking if the SQL Server Agent Service is Running with PBM and WQL | $hell Your Experience !!! #PowerShellLifeStyle
Webpage without description
Tagged as [BOOKMARK]
No-Hassle SQL Server Remoting with PowerShell V2 | Max Trinidad – The PowerShell Front
Webpage without description
Bob Beauchemin's Blog | Adieu, OLE DB
Webpage without description
SQL-Articles » Day 13–Trace Flag 7806–Enable Dedicated Administrator connection in SQL Express edition
Webpage without description
Tagged as [CAREER]
RSA Animate - Drive: The surprising truth about what motivates us - YouTube
Webpage without description
PASS 2011 Countdown – 5 Weeks To Go | Strate SQL
We are now 5-weeks from this years PASS Summit. It’s time to start getting ready for the event. Hopefully, you have already registered for the
Don’t Be This Guy
TimMitchell.net is the home page and blog of Tim Mitchell, a Microsoft SQL Server MVP, consultant, trainer, and speaker.
Tagged as [COMMUNITY]
Me and My Big Mouth (Literally) | Michael J. Swart
I First Learned About SQL as a Speaker
I'm a SQLPerson! | Matt Velic
Matt Velic has joined the SQLPeople™ team.
Tagged as [DENALI]
Managing AlwaysOn with Powershell | Sev17
Webpage without description
Top five features in SQL Server Developer Tools
SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer’s Denali preview. Read up on five SSDT features.
SQL Express LocalDB - Expressly for developers
Programming book reviews, programming tutorials,programming news, C#, Ruby, Python,C, C++, PHP, Visual Basic, Computer book reviews, computer history, programming...
Tagged as [DISCUSS]
Invitation for T-SQL Tuesday #22 – Data Presentation - Pearl Knows - SQLServerCentral.com
Webpage without description
PASSion Award Nominations | Strate SQL
One of the things that makes PASS a successful organization is the volunteers. To show it’s appreciation for these volunteers, each year PASS awards the
Kendal Van Dyke: Are You Willing To Relocate?
Webpage without description
Important InapproPASS Survey | SQL Awesomesauce
We're planning this year's Inappropriate PASS Sessions party this year, and we need your input. InapproPASS is a now-annual party to demonstrate the kind of
SQL Server Training: More Options Than Ever Before
Kalen Delaney explores SQL Server training options, including online training, in-person training, and hybrid approaches.
Tagged as [EDUCATION]
Free Online Class on Artificial Intelligence - YouTube
Webpage without description
Tagged as [GEEK]
Joe Chang : Laptop for database performance consultants
Today, it is actually possible to build a highly capable database system in a laptop form factor. There is no point to running a production database on a laptop. The...
Tagged as [HUMOR]
If Logos were Honest - My Modern Metropolis
Viktor Hertz is on a roll! After his clever Pictogram Movie Posters went viral, you would have thought that he'd sit back and relax. Instead, Hertz pumped out…
Little Bobby Tables
Webpage without description
WAIT_FOR_THE_NEXT_BUS
Webpage without description
Tagged as [MASHUP]
My Guide to Passing MCTS Exam 70-432
How to pass MCTS Exam 70-432 first time. Here's how I did it.
Stop and checked your Virtual Log Files (VLFs) - REPLTalk covers Using and Tuning SQL Replication - Site Home - MSDN Blogs
Webpage without description
Tagged as [MULTIMEDIA]
How to Prove It’s a SAN Problem Webcast Video | Brent Ozar PLF | Brent Ozar PLF
Years ago, when I was frustrated with my SQL Server's performance, the SAN admin kept saying it was a SQL Server problem. When the SAN admin quit, I took his
Tagged as [PERFORMANCE]
Tony Davis : SQL Code Reuse: teaching a dog new tricks
Developers, by every natural instinct and training, strive to make their code reusable and generic. Dissuading them from doing so, in certain circumstances, is...
Tagged as [RESPECT]
Statistics on Ascending Columns
Webpage without description
Temporary Tables in SQL Server
Webpage without description
Paul White: Page Free Space : Can a SELECT query cause page splits?
Books Online has this to say about page splits: When a new row is added to a full index page , the Database Engine moves approximately half the rows to a new page to...
Tagged as [RTM]
DBCC PINTABLE (Transact-SQL)
Webpage without description
Checkpoints and the Active Portion of the Log
Webpage without description
Tagged as [SITE]
SQLPeople - It's about the community!
Webpage without description
SQL Hunter
Let The SQL Hunter be your tour guide. Find answers to your SQL problems. Code, procs, scripts, examples, solutions, etc. All things SQL.
Tagged as [SQLPASS]
Rob Farley : More free training from PASS
Yeah, alright. I know PASS puts on heaps of free training all the time. There are meetings around the world all the time, as held by hundreds of chapters. Seriously,...
Volunteers Are The Life Blood « SQLAJ
Webpage without description
Recorded version of my #sqlpass first timers session - SQL Server with Mr. Denny
In case you missed my SQL PASS first timers session it was recorded, which failed several times and I had to stitch them together in order to get it uploaded. You...
Tagged as [TOOL]
Geekbench 2.2 Released | Glenn Berry's SQL Server Performance
Webpage without description
Tagged as [WARNING]
“QUOTED_IDENTIFIER” causes Unexpected Query Plan for Persisted Computed Column query - Microsoft SQL Server Development Customer Advisory Team - Site Home - MSDN Blogs
Webpage without description
0 notes
Text
Wednesday Weekly #sqlserver Links for 2011-35
Wednesday Weekly #sqlserver Links
Free buffet of some great content seen this week.
Current Feed Content
Tagged as [ADMIN]
Index Maintenance: Rebuild vs. Reorg | Cleveland DBA
Webpage without description
In search of SQL Server Skills … » Memory
Webpage without description
SQL Server Connector for Apache Hadoop
Webpage without description
SQL Server's Dedicated Admin Connection: Why You Want It | Brent Ozar PLF
There’s a DAC in SQL Server that you should know and love. Sadly, you probably either haven’t met or you’ve forgotten to turn it on.
A Couple of Data Compression Tricks in SQL Server 2008 | Glenn Berry's SQL Server Performance
Webpage without description
Why does a data backup include transaction log?
Question: I’m what you call an ‘involuntary’ DBA and I’ve noticed something strange. Whenever I do a database backup SQL Server says that it backed up the data files...
Tagged as [ALTERNATIVE]
How to tell what SQL Server version you are running
One issue that I am often faced with is determining what service pack is installed on the SQL Server. Until recently the version of SQL Server that was...
T-SQL – Splitting a String based on Delimiter « Blog – Fabiano Neves Amorim
Webpage without description
SQL Server: Move Data to a Different Table using OUTPUT clause
Webpage without description
Data Hashing in SQL Server - SQL Server Security - Site Home - MSDN Blogs
Webpage without description
Tagged as [BOOKMARK]
Microsoft is Aligning with ODBC for Native Relational Data Access - Microsoft SQLNCli team blog - Site Home - MSDN Blogs
Webpage without description
Tagged as [CAREER]
Klaus Aschenbrenner - SQLMCM
Webpage without description
Andy Leonard : On Starting a Technical Blog…
Introduction My friend and brother K. Brian Kelley ( Blog | @kbriankelley | SQLPeople ) recently wrote a meta-blog (blog about blogging) post entitled Don’t Wait to...
Tagged as [COMMUNITY]
Announcing Mentors for New PASS Nordic Region
We are excited to announce the formation of the PASS Nordic Region, formalizing our support for the tremendous Nordic SQL Server Community. To help us prov
I'm a PASS Regional Mentor!
I am very honored to have been asked to be a regional mentor for the SQLPASS organization
Beginning Performance Tuning with SQL Server
Pinal provides a look at the SQL Server Management tools and a T-SQL command that he uses for performance tuning.
Interview with BI Expert Tim Mitchell | SQL Aloha
Brad M. McGehee, Director of DBA Education, Red Gate Software
Interview with SQL Server MVP Grant Fritchey | SQL Aloha
Brad M. McGehee, Director of DBA Education, Red Gate Software
SQL PASS Nordic « sqlconcept.com
Webpage without description
Tagged as [DENALI]
Installing SQL Server Denali CTP3 on Windows 2008 R2 Core Edition - Robert's SQL Blog - Site Home - TechNet Blogs
Webpage without description
Tagged as [DISCUSS]
PASS - The Professional Association for SQL Server > Community > Volunteers > PASSion Award
Webpage without description
Meme Monday For September | SQLRockstar
Thomas LaRock posts the next Meme Monday entry.
Tagged as [EDUCATION]
SQLskills.com | Immerse Yourself In SQL Server
SQLskills offers training, consulting, mentoring and custom Immersion events focused on Microsoft SQL Server. SQLskills was founded by SQL Server Specialist...
[EN] 24 Hours, PASS and Community | {koprowskit.eu} My MVP blog
Webpage without description
Free Performance Tuning and Optimization Roundtable - SQLPeople
Webpage without description
Tagged as [HUMOR]
DILBERT_THINK_ABOUT_MURDER
Webpage without description
SUPER_QUALITY_DATA
Webpage without description
IBD-football-flowchart.jpg
Webpage without description
Tagged as [MASHUP]
Parallel Data Warehousing (PDW) Explained | James Serra's Blog
Details on Parallel Data Warehousing (PDW).
Tagged as [MULTIMEDIA]
Video: How to Use the Denali Windowing Functions | Brent Ozar PLF | Brent Ozar PLF
SQL Server Denali includes some new tricks in its T-SQL bag. In this week's Technology Triage Tuesday webcast, Jeremiah Peschka explains aggregations -
Tagged as [PERFORMANCE]
Partitioning & Archiving tables in SQL Server (Part 2: Split, Merge and Switch partitions) - Félix Martínez Retama Blog - Site Home - MSDN Blogs
SQL and .NET tips & Tricks.
Tagged as [RTM]
Limitations of the Missing Indexes Feature
Webpage without description
System Stored Procedures (Transact-SQL)
Webpage without description
sys.dm_os_wait_stats (Transact-SQL)
Webpage without description
Trace Flags (Transact-SQL)
Webpage without description
Tagged as [SCRIPT]
DBA Rant » Archive » Powershell Homework Answers
Webpage without description
Setting up database mirroring with certificates - Microsoft SQL Server Support Blog - Site Home - MSDN Blogs
Webpage without description
Tagged as [SITE]
SQL South West - a SQL user group of SQL Server professionals working in the South West of the UK, meeting monthly in Exeter.
A SQL Server User Group based in Exeter, UK for anyone in the South West.
Tagged as [SQLGPLUS]
Scarlet & Scary : Google+ Hangouts With a Purpose
The other morning I held my first G+ Hangout that had an actual agenda. Mind you, my agenda was defined as follows: Database Deployments, how do you do them,...
Tagged as [SQLPASS]
PASS Update #63 (How Do We Rate) | SQLAndy
Webpage without description
PASS Goes Global
We are excited to introduce some changes to PASS in an effort to connect global SQL Server communities and foster relationships between our professionals – wher
NomCom Finalized
The 2011 Nomination Committee (NomCom) – a team that assesses and reviews all PASS Board of Director applicants – has been finalized. Three community members ha
Come Shake My Hand at PASS « Voice of the DBA
Webpage without description
Tagged as [TOOL]
Secret New SQL Server Denali Feature: Data Director | Brent Ozar PLF | Brent Ozar PLF
You heard it here first, folks - I've got the scoop on what might be the most exciting new feature in Microsoft SQL Server Denali. I hope you're sitting
Townsend Security Announces New Encryption Key Management Hardware Security Module for Microsoft SQL Server 2008
Mid-market SQL Server customers now have an affordable hardware security module option for encryption key management compliance requirements.
Tagged as [WARNING]
Debugging that latch timeout « TroubleshootingSQL
Webpage without description
T-SQL/SELECT PitFall « Blog – Fabiano Neves Amorim
Webpage without description
Even Simple Changes Can Cause Trouble: A Tale of TempDb | Brent Ozar PLF
Adding multiple files to TempDB is a commonly recommended best practice for SQL Server. Read about one case where this caused uncommon problems.
0 notes
Text
#sqlserver meta-URLs
Someone sent a request effectively asking for a whitelist of URLs for SQL Server DBAs.
Instead of a long list of all URLs here is a short list of meta-URLs.
SQL Server Blog list: PASS - The Professional Association for SQL Server > Community > Blog Directory
SQL Server Community list: SQL Server - Related Sites
SQL Server Vendor list: SQL Server Product Categories
Q&A list: List of question and answer websites - Wikipedia, the free encyclopedia
Do you see anything missing? Can you recommend other meta-URLs?
0 notes
Text
Wednesday Weekly #sqlserver Links for 2011-34
Wednesday Weekly #sqlserver Links
Free buffet of some great content seen this week.
Current Feed Content
Tagged as [ADMIN]
ACID Properties By Example (And Counterexample) Part Four: Durable | Michael J. Swart
If you're designing a database system, you only need to consider two kinds of malfunctions: media failure and system failure.
SQL Server A to Z - Kerberos | Cleveland DBA
Webpage without description
Tagged as [CAREER]
Merrill Aldrich : Dear SQL Tools Team(s): Stop Starting Over. Seriously.
I have two little boys at home, and my parents were both teachers. It gives me a strange relationship with our public schools – I am passionate about them, and the...
Why We’re All Doomed and GTD Can’t Save Us
If you’re a GTD fan or aspiring productivity enthusiast, I hope that title felt like a jab in the ribs. It should.
Tagged as [COMMUNITY]
Call Me Mini-Master | SQLRockstar
Thomas LaRock blogs about how he passed the written exam for the SQL MCM.
Tagged as [DISCUSS]
Compression Estimator to be featured in the September issue of SQL Server Magazine / back from Holiday - boB 'The Tool Man' Taylor - Site Home - MSDN Blogs
Webpage without description
DBA Rant » Archive » Test your Powershell prowess
Webpage without description
Annual SQL Connectivity Customer Survey - SQL Protocols - Site Home - MSDN Blogs
Webpage without description
Tagged as [EDUCATION]
Programming blog: MCTS
Webpage without description
Tagged as [GEEK]
LEGO 3D Milling Machine - "3D Printer" - YouTube
Webpage without description
Tagged as [HUMOR]
GAMES_OF_THE_FUTURE
Webpage without description
SQL_CLIPPY
Webpage without description
Tagged as [MASHUP]
Expert? Ha! | Home Of The Scary DBA
Webpage without description
Tagged as [MULTIMEDIA]
Five Ways to Fight Blocking Video | Brent Ozar PLF | Brent Ozar PLF
What do *you* do when your database has a problem with blocking? Most people reach for the “NOLOCK” hint. Bad news: that may introduce other problems, and
Tagged as [RTM]
Trace Flags (Transact-SQL)
Webpage without description
DBCC FREESYSTEMCACHE (Transact-SQL)
Webpage without description
Tagged as [SCRIPT]
Allen White : Pull Performance Data from Perfmon Logs with PowerShell
For the last year and a half or so I've been presenting a session on how to gather perfmon data with PowerShell. Here's a link to my blog after the 2010 Tech Ed...
Tagged as [SITE]
Professional Organization of SQL Server Educators | Bringing Technical Education to Texas
Bringing Technical Education to Texas
SQL-R-Us
For All Things SQL Server . . .
Tagged as [SQLPASS]
Things that PASS first timers really need to know webcast - SQL Server with Mr. Denny
As the SQL PASS summit is a big confusing event for people attending the summit for the first time, I'm taking it upon myself to do something about this.
short PASS update aka coming out of hibernation | Allen Kinsel - SQL DBA
Its been too long since I updated this place.... I should apologize or make excuses but, I wont waste your time or mine thinking of them This week is a
PASS SQLSaturday Recap
Normal 0 false false false EN-CA X-NONE X-NONE
Midlands SQL Server User Group now a PASS chapter | Purple Frog Systems
With our third event on the horizon, SQL Midlands is now an official PASS chapter. Proud to be part of a fantastic UK SQL Server community.
Tagged as [WARNING]
Rob Farley : T-SQL thoughts about the 95th percentile
95% of statisticians may be offended at this post. Unfortunately, I’m going to be showing my ignorance about statistics here, I’m sure. I may even use Wikipedia to...
When working with SQL in a cluster, the account rights on both nodes of the cluster need to be the same - SQL Server with Mr. Denny
Recently I was working with a clients SQL Server cluster. The managed service provide had installed some Windows patches causing the SQL Cluster to fail over to the...
0 notes
Text
#sqlservermyth cost threshold for parallelism = seconds
"It's like a lion and a tiger mixed... bred for its skills in magic."
The definition of cost threshold for parallelism is similar to this definition of a Liger. It is based on fact but when retold it magically becomes inaccurate. "The cost refers to an estimated elapsed time in seconds required to run the serial plan on a specific hardware configuration." The key words are the last five. They are intended to tell you that the calculation for estimating seconds is based on the characteristics of some SQL Server which probably will not match your current, past or future SQL Servers.
So what time is it?
Try executing the script below on a SQL Server with its cost threshold for parallelism value set between 1 and 24. You should find that querying 33487 records (each requiring one logical read) will not parallelize but querying 33488 records will parallelize. It has already been executed on several different SQL Server versions with varying hardware characteristics and the same result occurred each time. Attempts were also made to try and cause parallelizing to occur with 33487 records but increased CPU due to calculations of math functions but the attempts were unsuccessful. Let us temporarily ass/u/me that IO is the only differentiator to cause parallelism even though that is not the case. If it were true then it would mean the time it takes your SQL Server to perform 33488 reads is what time a query would need to take before parallelism will be used. At threshold 25 the reads breakpoint was 33670 and at threshold 45 the reads breakpoint was 60608.
(NOTE: this was an overly simplistic test for a feature as complex as parallel execution plans but hopefully it still proves the intended point)
Myth Busting
Tony Davis : SQL Server Myths
Demystifying SQL Server: SQL Server Myths Debunked (Part 1)
Demystifying SQL Server: SQL Server Myths Debunked (Part 2)
CommonSQLServerMyths.pdf <a pox on your house! if you do not read all 59 pages>
T-SQL Tuesday #11 Round up, Misconceptions in SQL Server « « Sankar ReddySankar Reddy
T-SQL Tuesday: Common SQL Server myths – Series I–Setup and Services « TroubleshootingSQL
Common SQL Server myths – Series II – SQL Memory « TroubleshootingSQL
My Favourite SQL Server Myths and Realities - LivingForSqlServer - SQLServerCentral.com
People
Tony Davis
Adam Haines
Paul Randal
Sankar Reddy
Amit Banerjee
Ramkumar Gopal
Script
SET NOCOUNT ON;
GO
SET ROWCOUNT 0;
GO
CREATE DATABASE [DELETEME] ON
PRIMARY (NAME = N'DELETEME_data', FILENAME =N'C:\Temp\DELETEME_data.mdf', SIZE = 16384KB , FILEGROWTH =16384KB)
LOG ON (NAME = N'DELETEME_log', FILENAME =N'C:\Temp\DELETEME_log.ldf', SIZE = 16384KB , FILEGROWTH =16384KB);
GO
ALTER DATABASE [DELETEME] SET AUTO_CREATE_STATISTICS OFF;
GO
ALTER DATABASE [DELETEME] SET AUTO_UPDATE_STATISTICS OFF;
GO
ALTER DATABASE [DELETEME] SET RECOVERY FULL;
GO
ALTER DATABASE [DELETEME] SET MULTI_USER;
GO
USE [DELETEME];
GO
CREATE TABLE [dbo].[JUNK] (TRASH CHAR(8000) NOT NULL DEFAULT SPACE(8000));
GO
INSERT INTO [dbo].[JUNK] VALUES (DEFAULT);
GO
INSERT INTO [dbo].[JUNK] SELECT * FROM [dbo].[JUNK];
GO 15
DECLARE @MORE_ROWS INT;
SELECT @MORE_ROWS = 33487 - COUNT(*) FROM [dbo].[JUNK];
SET ROWCOUNT @MORE_ROWS
INSERT INTO [dbo].[JUNK] SELECT * FROM [dbo].[JUNK];
GO
CHECKPOINT;
GO
SET ROWCOUNT 0;
GO
DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS;
GO
PRINT 'PREDICTING WITHOUT PARALLELISM';
GO
SET SHOWPLAN_ALL ON;
GO
SELECT DISTINCT 0 FROM [dbo].[JUNK];
GO
SET SHOWPLAN_ALL OFF;
GO
SET STATISTICS IO ON;
GO
SET STATISTICS TIME ON;
GO
SELECT DISTINCT 0 FROM [dbo].[JUNK];
GO
SET STATISTICS IO OFF;
GO
SET STATISTICS TIME OFF;
GO
PRINT 'ADDING JUST 1 MORE ROW';
GO
INSERT INTO [dbo].[JUNK] VALUES (DEFAULT);
GO
DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS;
GO
DBCC FREEPROCCACHE WITH NO_INFOMSGS;
GO
PRINT 'PREDICTING WITH PARALLELISM';
GO
SET SHOWPLAN_ALL ON;
GO
SELECT DISTINCT 0 FROM [dbo].[JUNK];
GO
SET SHOWPLAN_ALL OFF;
GO
SET STATISTICS IO ON;
GO
SET STATISTICS TIME ON;
GO
SELECT DISTINCT 0 FROM [dbo].[JUNK];
GO
SET STATISTICS IO OFF;
GO
SET STATISTICS TIME OFF;
GO
DROP TABLE [dbo].[JUNK];
GO
USE [master];
GO
DROP DATABASE [DELETEME];
GO
Bustin' makes me feel good
0 notes
Text
Wednesday Weekly #sqlserver Links for 2011-33
Wednesday Weekly #sqlserver Links
Great articles found this week, tagged and served up for mass consumption.
Tagged as [ADMIN]
SQL Server Storage Engine & Tools (SSQA.net) : SQL Server Manageability series: Log files and Setup Bootstrap folder, the key elements to manage the data platform
There a different types of log files available when you start to install the SQL Server and manage the instance. Whenever you talk about log file then immediate
Preventing Problems in SQL Server
Webpage without description
Tagged as [ALTERNATIVE]
Change Tracking and Database Refactoring - SQLServerCentral
Free Microsoft SQL Server articles, news, forums, scripts and FAQs.
Deleting Data in Small Chunks on SQL Server | Jason Crider
I’ve had this post on the backburner for a bit of time, but Glenn Berry (Blog|Twitter) recently posted on gradually deleting data in SQL Server and that made me...
Tagged as [BOOKMARK]
Microsoft SQL Server 2011, 2008R2, 2008, 2005, 2000 and 7.0 Builds
Webpage without description
SQL Server A to Z - Isolation Levels | Cleveland DBA
Webpage without description
Tagged as [CAREER]
Andy Leonard : Creating is Hard
Introduction This post is the forty-seventh part of a ramble-rant about the software business. The current posts in this series can be found on the series landing page...
Database Administration Operation Road Map | DBA Philosophy
Webpage without description
In Recovery... | Do yourself a favor... Trust No One
Webpage without description
Going Big with SSDs « Voice of the DBA
Webpage without description
Tagged as [COMMUNITY]
What It Means To Me To Be A Volunteer | SQL Server Input/Output
Webpage without description
Tagged as [DENALI]
SQL Server “Denali”: Distributed Replay | James Serra's Blog
Distributed Replay is a new multi-threaded replay utility in Denali that should make load testing much easier.
Product Guide for SQL Server "Denali" released | James Serra's Blog
Explains what is contained in the Product Guide for SQL Server Denali.
SQL Server on Windows Server Core part 2–Configuring Server Core - Insufficient data from Andrew Fryer - Site Home - TechNet Blogs
Notes and queiries from a Microsoft technical evangelist for the IT Professional working in the UK
SQL Server White Paper Template - Powered by Google Docs
Webpage without description
Tagged as [DISCUSS]
Tricky Questions « Voice of the DBA
Webpage without description
Tagged as [EDUCATION]
Adam Machanic : Data Education: Food For Your Brain
I've written here before about Data Education , the training company I recently launched, building off my previous company Boston SQL Training. Things have moved...
Free SQL Server Webcasts Coming Up | Brent Ozar PLF | Brent Ozar PLF
Our new Technology Triage Tuesdays webcast series is going really well. Every Tuesday at 11:30AM Central, we get together for a free 30-minute training session.
First annual SQLRelay annouced for 3rd - 6th October, visit one of over 13 regional UK based SQL user groups - Tony Rogerson's ramblings on SQL Server
Tony Rogerson's ramblings on SQL Server
FREE SQL Training In Los Angeles! « Marlon Ribunal's Note On SQL Server
Webpage without description
Tagged as [HUMOR]
LIGHTSABER_OUTCOMES_PIE_CHART.jpg
Webpage without description
The Stages of Growth | Brent Ozar PLF | Brent Ozar PLF
Everyone poops and everyone grows. We all reach that growth stage in our own time, but sooner or later we all encounter it. Once you reach a growth stage you
WIFI_SSID_CHOICES.jgp
Webpage without description
Tagged as [MASHUP]
Any questions about the SQL Server MCM that you would like to have answered? | LinkedIn
Any questions about the SQL Server MCM that you would like to have answered?
In search of SQL Server Skills … » SQL Server Plan Cache – Reading List
Webpage without description
Tagged as [MULTIMEDIA]
Slide decks from Dallas Tech Fest Sessions - SQL Server with Mr. Denny
This last Saturday I spoke at Dallas Tech Fest, where I had two great groups in my two sessions. As promised here are the slide decks for the two sessions which I...
The Periodic Table of DMVs Webcast Video | Brent Ozar PLF | Brent Ozar PLF
Watch this week's episode of Technology Triage Tuesdays where Tim Ford covers the Periodic Table of DMVs: http://www.youtube.com/watch?v=ku3tu-PC1zw Next
Tagged as [PERFORMANCE]
Can You Dig It? – Researching Index Scans | Strate SQL
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. It’s been a while since the last plan cache series
Tagged as [RESPECT]
Debugging the deadlock but for the scheduler: Part 1 of 2 « TroubleshootingSQL
Webpage without description
Tagged as [RTM]
SET TRANSACTION ISOLATION LEVEL (Transact-SQL)
Webpage without description
Using the SQL Server Service Startup Options
Webpage without description
Tagged as [SCRIPT]
Gradually Deleting Data in SQL Server | Glenn Berry's SQL Server Performance
Webpage without description
Recursively Enumerating Local and AD Groups | Sev17
Webpage without description
Tagged as [SITE]
Database Administrators - Stack Exchange
Webpage without description
Tagged as [SQLGPLUS]
Google + Hangouts | Home Of The Scary DBA
Webpage without description
Tagged as [SQLPASS]
Andy Leonard : Why I Love the PASS Summit
Introduction I was chatting with my friend and business partner Brian Moran ( @briancmoran ) about PASS and shared how the PASS Summit 2004 was a turning point in my...
Allen White : [OT] On Community
Last fall, and winter, and spring I was part of the PASS Election Review Committee . It was interesting, sometimes fun, sometimes frustrating, but a very rewarding...
PASS Elections 2011 > Home
PASS Elections 2011
SQLPASS Summit 2011: Meet New People | LittleKendra.com
Would you like to meet new people at the SQL PASS Summit conference this year? Here's how.
I am a Big Bro - RumblingDBA - SQLServerCentral.com
Webpage without description
I’m a Big (SQL) Sister! | Yanni Robel
Webpage without description
Tagged as [TOOL]
redgate – SQL Tab Magic – Preview | The Lone DBA
Webpage without description
Tagged as [WARNING]
T-SQL functions do no imply a certain order of execution
Author: Remus Rusanu Subject:SQL Server Blog
SQL Awesomesauce » Blog Archive » We Are TOTALLY Amused: A T-SQL Error
This has to be the best error I've ever seen: Msg 195, Level 15, State 10, Line 2 'SUM' is not a recognized built-in function name. Uhm, I'm sorry to
How compressed is your backup?… - CSS SQL Server Engineers - Site Home - MSDN Blogs
Webpage without description
0 notes
Text
Wednesday Weekly #sqlserver Links for 2011-32
View Feed XML
36 great articles (1) brings HUMOR (2) to DISCUSS (1) make MASHUP (2) concerning SQLPASS (8) showing ALTERNATIVE (3) helps ADMIN (1) involves EDUCATION (0) by MSFT (3) as WARNING (0) to BOOKMARK (1) have SCRIPT (1) deserve RESPECT (1) improves PERFORMANCE (3) about CAREER (3) on COMMUNITY (0) with TOOL (2) encourages RTM (1) is MULTIMEDIA (3) link SITE
Current Feed Content
SQL Server Deadlocks Due to Character Data Type Conversion When Using SQL Server JDBC drivers - Microsoft SQL Server Tips & Tricks - Site Home - MSDN Blogs
Tagged as WARNING
Email this Share this
Implementing SSL encryption for SQL Server in a DNS forwarding environment - Microsoft SQL Server Tips & Tricks - Site Home - MSDN Blogs
Tagged as WARNING
Email this Share this
SQLSaturday Home
Tagged as SITE
Email this Share this
Remember Your First High School Dance? | Arnie Rowland
Tagged as SQLPASS
Email this Share this
Now is a good time to start planning your 2012 conference schedule. - SQL Server with Mr. Denny
Tagged as EDUCATION The 2011 conference season is starting to come to a close. There are only a few large conferences left such as VM World, SQL PASS, and Dev Connections. Many people...
Email this Share this
What SQL Server Books Do You Recommend? | SQL Aloha
Tagged as DISCUSS Brad M. McGehee, Director of DBA Education, Red Gate Software
Email this Share this
24 Hours of PASS - Fall 2011 > Home
Tagged as SQLPASS 24 Hours of PASS - Fall 2011
Email this Share this
Reading Pages
Tagged as RTM
Email this Share this
3.2.4 Higher-Layer Triggered Events
Tagged as RTM
Email this Share this
Programming blog: MCTS
Tagged as MASHUP
Email this Share this
YOU, THE CUSTOMER, YOUR SPOUSE, FIRST DRAFTS
Tagged as HUMOR
Email this Share this
Karen Lopez: @datachick
Tagged as COMMUNITY Karen Lopez ( http://www.twitter.com/datachick ) is Sr. Project Manager & Architect. An active tweeter, Karens passion for data is apparent, and she shares a...
Email this Share this
Performance Troubleshooting Using SQL Nexus - SSWUG.ORG Article
Tagged as ADMIN Microsoft SQL Server database help and articles, SharePoint, .Net, Business Intelligence, newsletter, list servers, forums, scripts, faqs, videos, and daily news
Email this Share this
The CONNECTIONPROPERTY TSQL Function | youdidwhatwithtsql.com
Tagged as ALTERNATIVE The CONNECTIONPROPERTY function can be used to obtain information about the current connection. The information available is similar to the
Email this Share this
The SQL Server Query Optimizer
Tagged as RESPECT
Email this Share this
SQL Server A to Z - GO | Cleveland DBA
Tagged as ADMIN
Email this Share this
Lee Everest's SQL Server, etc. weblog | TSQL upper case first letter of each word
Tagged as ALTERNATIVE
Email this Share this
Microsoft Certifications and MVP's - What are they? | James Serra's Blog
Tagged as CAREER Explains what exactly are Microsoft certifications and what are Microsoft MVP's.
Email this Share this
I Am Going to Be a Big Brother #sqlpass #firsttimers « Tradney's Blog
Tagged as COMMUNITY
Email this Share this
Chennai SQL Server User Group and me - LivingForSqlServer - SQLServerCentral.com
Tagged as COMMUNITY
Email this Share this
Getting the Default Data and Log path using PowerShell « TroubleshootingSQL
Tagged as ALTERNATIVE
Email this Share this
Microsoft "How Do I" videos - Nick MacKechnie - Site Home - MSDN Blogs
Tagged as MULTIMEDIA
Email this Share this
How to Run Programs as a Domain User from a Non-domain Computer | James Serra's Blog
Tagged as ALTERNATIVE How to Run Programs as a Domain User from a Non-domain Computer
Email this Share this
Enforcing Complex Constraints with Indexed Views « spaghettidba
Tagged as ALTERNATIVE
Email this Share this
Sample DBA Resumes | Brent Ozar PLF | Brent Ozar PLF
Tagged as CAREER Nobody knows who I am. Yes, I know, you think I waltz into restaurants without a reservation, get the best table in the house, and Rick Bayless brings the
Email this Share this
Working out how long a SQL Server backup/restore will take
Tagged as SCRIPT Script using sys.dm_exec_requests output to show the progress and estimated completion time for a database backup or restore operation.
Email this Share this
I’m A Part Of Things Greater Than Myself, The POSSE Is Here. | SQL Server Input/Output
Tagged as COMMUNITY
Email this Share this
Professional Organization of SQL Server Educators | Bringing Technical Education to Texas
Tagged as SITE
Email this Share this
Alexander Kuznetsov : Reads involving UDFs under READ_COMMITTED_SNAPSHOT may seem inconsistent.
Tagged as WARNING When a select uses scalar or multi-statement UDFs under READ_COMMITTED_SNAPSHOT, we might not get consistent results as of the time our select began - I will provide...
Email this Share this
Paul White: Page Free Space : SQL Server, Seeks, and Binary Search
Tagged as PERFORMANCE The following table summarizes the results from my last two blog entries, showing the CPU time used when performing 5 million clustered index seeks: In test 1,...
Email this Share this
How to find out how much CPU a SQL Server process is really using
Tagged as ALTERNATIVE Someone has reported a performance issue for your application. When you look into the database server you see CPU utilization is very high and the SQL Server...
Email this Share this
SQLServerCentral.com Best Practices Clinic: Part 5 - SQLServerCentral
Tagged as DISCUSS Free Microsoft SQL Server articles, news, forums, scripts and FAQs.
Email this Share this
SSMS – Query result options - Discard result after query executes - Nakul's Blog
Tagged as ALTERNATIVE As most of the readers of my post know, I have always tried to find features of the SQL Server Management Studio (SSMS) that boost productivity & allow for...
Email this Share this
Guide To MCITP: SQL Server 2008 Administration - SQLServerCentral
Tagged as CAREER Free Microsoft SQL Server articles, news, forums, scripts and FAQs.
Email this Share this
Purchasing hardware for SQL Server: What not to do#
Tagged as ADMIN Purchasing hardware for SQL Server? Find out what mistakes people make most often when making their shopping lists – and what’s at stake.
Email this Share this
Download Companion Content for Microsoft Official Courses (MOC)
Tagged as SITE Download companion content for Microsoft Official Courses (MOC) from this page.
Email this Share this
0 notes