belle. sql. developer. dba. black ninja.

Search for:

belle @ DevTeach Vancouver 2009

Calendar

Popular Posts

• Resolving “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”
• Getting Table Columns in SQL Server
• SQL Server PowerShell : Basics – Connecting to SQL Server
• Creating Reports From SharePoint Lists Using SQL Server Reporting Services (SSRS)
• SQLXML : How to Work With XML Elements (or Nodes) in SQL Server
• How to Format Query Result as Comma Separated Values (CSV)
• Handling Division By Zero Scenarios in T-SQL
• SQL Server PowerShell : How to Backup SQL Server Databases Using SMO and PowerShell
• SQLXML : How to Use SQL Server XML Function exist()
• SQL Server PowerShell : How to Restore SQL Server Databases Using SMO and PowerShell

Recent Comments

• Blog Post: PowerShell: Restoring a whole heap of SQL Databases | IT.beta on SQL Server PowerShell : How to Restore SQL Server Databases Using SMO and PowerShell
• Will Seitz on SQL Server PowerShell : How to Restore SQL Server Databases Using SMO and PowerShell
• Shafi on Resolving “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”
• Pikesway on Creating Reports From SharePoint Lists Using SQL Server Reporting Services (SSRS)
• Jai on Resolving “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”

Categories

• BDC
• DBA Toolbox / T-SQL Scripts
• DevConnections 2007
• Ebooks
• Issues/Troubleshooting
• musings
• MySQL
• performance tuning
• Powershell
• Resources/References
• Security
• SharePoint
• SMO
• Speaking Engagements
• SQL Server 2008
• SQL Server 2008 Reporting
• SQL Spatial
• SQLPASS
• SQLXML
• SSRS
• T-SQL Tips and Tricks
• Teaching
• Tools
• Tutorials
• twitter
• Uncategorized

Archives

• July 2010
• June 2010
• April 2010
• March 2010
• February 2010
• January 2010
• November 2009
• October 2009
• September 2009
• August 2009
• June 2009
• May 2009
• April 2009
• March 2009
• December 2008
• November 2008
• October 2008
• September 2008
• August 2008
• July 2008
• June 2008
• May 2008
• April 2008
• March 2008
• February 2008
• January 2008
• December 2007
• November 2007
• August 2007
• June 2007

Black Ninja

• Programmatically and Selectively Revoke SharePoint Item-Level Permissions Using PowerShell
• Leverage 960.gs for Page Layout
• SharePoint 2010 Books – Which Ones to Buy?
• We’ve Added an Aztec Warrior to Our Team!
• SQL Ninja to Present Idera Webcast in March!

Brent Ozar

• How to Buy Your First Mac
• Why I’m Disappointed in the PASS Election Process
• Underemployed Developers: Meet Project Phoenix
• Help me stop a jerk from abusing #SQLHelp
• Things I’ve Been Reading Lately
• PASS Board of Directors Election 2010 #passvotes
• Guess Who Got My Old Job at Quest?
• Stop Using Twifficiency, You Bozos

SQLCAT

• Optimizing CREATE SET in Cube Calculation Scripts
• PowerPivot for SharePoint: Single Server Installation
• Analysis Services ROLAP for SQL Server Data Warehouses
• Increasing Throughput of Pipelines by Splitting Synchronous Transformations into Multiple Tasks
• PowerPivot Technical Diagram: PowerPivot Security Architecture
• New Release of SQL Server Migration Assistant (SSMA) includes migration from MySQL and to SQL Azure
• Loading data to SQL Azure the fast way
• Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products

CSS SQL Server Engineers

• Slow query performance because inaccurate cardinality estimate when using anti-semi join following upgrade from SQL Server 2000
• Query performance and table variables
• Why use SQL Server 2008 R2 BPA? Case 1: Missing Updates…..
• How It Works: Timer Outputs in SQL Server 2008 R2 - Invariant TSC
• How It Works: Enumeration of sys.messages
• Replay Result Set Event (Replay * Events)
• When a full dump isn’t really a full dump…
• How It Works: Error 18056 - The client was unable to reuse a session with SPID ##, which had been reset for connection pooling

Database Journal

• A Guide to Microsoft SQL Server Replication
• Introduction to SQL Server Proactive Caching
• Oracle Database 11g New Features for Table Partitioning
• Microsoft Sync Framework Beefs Up Collaboration
• Top 5 Oracle Database PL/SQL Job Interview Questions
• Book Review: Access 2010 Programmer's Reference
• Nine Steps to Troubleshooting SQL Server problems
• CouchDB - The Open Source NoSQL Database

Simple Talk

• Minesweeper in T-SQL
• Raw Materials: Healthy Caution or...Something Else?
• OUTPUT Clause Saves The Day
• The MERGE Statement in SQL Server 2008
• Switching from Selenium 1.x to WebDriver/Selenium 2 and HtmlUnit
• Setting up your own free Virtualized test environment
• Josef Richberg: DBA of the Day
• Oslo at rock bottom

Tags

Blogroll

• Black Ninja Software Blog
• Matthew Carriere’s Ruby on Rails and Mac

Blogroll - SharePoint

• Shereen Qumsieh’s SharePoint Fun
• Yaroslav Pentsarskyy’s Development Blog

Blogroll - SQL Server

• Brent Ozar
• Database Journal
• Jason Strate
• MSSQLTips
• Simple Talk
• SQL Server Performance
• SQLSkills
• SQLTeam

Recent Posts

• Free Software and Books for Unemployed Developers (thanks to Microsoft MVPs!)
• xkcd and Penny Arcade fixes for the day
• SSRS Tidbits – Common Tips, Tricks, Debugging and Other References (Part 1)
• Programmatically and Selectively Revoke SharePoint Item Level Permissions Using PowerShell
• SQLSaturday #43 (Redmond) – SQL Server Reporting and SQLServer/PowerShell

ModXBlog theme by Dreamweaver | Downloaded from Wordpress Themes