sqlmashup

Wednesday Weekly #sqlserver Links for 2011-37

Posted on September 14, 2011 by Robert Matthew Cook

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…

Posted in Uncategorized

T-SQL Tuesday #22 – Data Presentation #tsql2sday

Posted on September 13, 2011 by Robert Matthew Cook

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

Posted in Uncategorized

#powershell deepest folder top 1 alphabetical

Posted on September 7, 2011 by Robert Matthew Cook

Get-ChildItem -path “C:\getdeepestfolder\top1alphabetical\” -recurse | Sort-Object -property @{Expression={[regex]::matches($_.FullName, “\\”).count}; Ascending=$false} | Select-Object -property “FullName” -first 1

Posted in Uncategorized

Wednesday Weekly #sqlserver Links for 2011-36

Posted on September 7, 2011 by Robert Matthew Cook

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

Posted in Uncategorized

Wednesday Weekly #sqlserver Links for 2011-35

Posted on August 31, 2011 by Robert Matthew Cook

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.

Posted in Uncategorized

#sqlserver meta-URLs

Posted on August 26, 2011 by Robert Matthew Cook

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?

Posted in Uncategorized

Wednesday Weekly #sqlserver Links for 2011-34

Posted on August 24, 2011 by Robert Matthew Cook

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…

Posted in Uncategorized

	codegumbo » Wh… on [blog] What Should PASS Be?…
	If PASS Closed Its D… on [blog] What Should PASS Be?…

Current Feed Content

Tagged as [ADMIN]

Tagged as [ALTERNATIVE]

Tagged as [BOOKMARK]

Tagged as [CAREER]

Tagged as [COMMUNITY]

Tagged as [DENALI]

Tagged as [DISCUSS]

Tagged as [EDUCATION]

Tagged as [GEEK]

Tagged as [HUMOR]

Tagged as [MASHUP]

Tagged as [MSFT]

Tagged as [MULTIMEDIA]

Tagged as [PERFORMANCE]

Tagged as [RTM]

Tagged as [SCRIPT]

Tagged as [SQLGPLUS]

Tagged as [SQLPASS]

Tagged as [TOOL]

Tagged as [WARNING]

Current Feed Content

Tagged as [ADMIN]

Tagged as [ALTERNATIVE]

Tagged as [BOOKMARK]

Tagged as [CAREER]

Tagged as [COMMUNITY]

Tagged as [DENALI]

Tagged as [DISCUSS]

Tagged as [EDUCATION]

Tagged as [GEEK]

Tagged as [HUMOR]

Tagged as [MASHUP]

Tagged as [MULTIMEDIA]

Tagged as [PERFORMANCE]

Tagged as [RESPECT]

Tagged as [RTM]

Tagged as [SITE]

Tagged as [SQLPASS]

Tagged as [TOOL]

Tagged as [WARNING]

Current Feed Content

Tagged as [ADMIN]

Tagged as [ALTERNATIVE]

Tagged as [BOOKMARK]

Tagged as [CAREER]

Tagged as [COMMUNITY]

Tagged as [DENALI]

Tagged as [DISCUSS]

Tagged as [EDUCATION]

Tagged as [HUMOR]

Tagged as [MASHUP]

Tagged as [MULTIMEDIA]

Tagged as [PERFORMANCE]

Tagged as [RTM]

Tagged as [SCRIPT]

Tagged as [SITE]

Tagged as [SQLGPLUS]

Tagged as [SQLPASS]

Tagged as [TOOL]

Tagged as [WARNING]

Current Feed Content

Tagged as [ADMIN]

Tagged as [CAREER]

Tagged as [COMMUNITY]

Tagged as [DISCUSS]

Tagged as [EDUCATION]

Tagged as [GEEK]

Tagged as [HUMOR]

Tagged as [MASHUP]

Tagged as [MULTIMEDIA]

Tagged as [RTM]

Tagged as [SCRIPT]

Tagged as [SITE]

Tagged as [SQLPASS]

Tagged as [WARNING]

Recent Posts

Recent Comments

Archives

Categories