acheter chaussures christian louboutin 2014

acheter chaussures puma 2014

acheter chaussures nike air jordan 2014

Wednesday, October 07, 2015     | Register
Welcome !
Welcome to sqlCrunch! The idea behind sqlCrunch is simple; categorize and summarize links to SQL Server articles/blogs and present these links via a website. The benefits are twofold; portability and sharing. As a DBA, I'm constantly finding myself thinking about scripts or whitepapers that I used in the past, but can't remember where I saved it (if at all). By adding it to sqlCrunch, the link is saved for my future reference and is available for others to share as well.

In late 2008, I redesigned the pages of this site to mirror the chapters in my SQL Server 2008 Administration in Action book. Each chapter has a corresponding page on the site which supplements the chapter's content by linking the reader to additional information and best practices.

Please use the RSS feed to keep up to date with changes. I'm constantly adding new links and I welcome your feedback

Rod Colledge

Recently added to sqlCrunch


Mirroring a Large Number of Databases in a Single SQL Server Instance


How many databases on a single SQL Server instance can be setup for Mirroring? 1, 10 or it depends? Find out in this technical note from the SQLCAT team ... Source : Technical Note -



Using Service Broker instead of Replication


Have you ever considered using Service Broker as an alternative to replication? Denny has, and shares the technical aspects in this post ... Source : Denny Cherry -



SQL Server Myth Busters


For those that missed it, Paul ran a series of posts earlier this year covering common SQL Server myths. Find them all here ... Source : Paul Randal -



Bad habits to kick : ignoring I/O


A great post from Aaron covering a series of tips for reducing disk I/O, a sure fire way of improving performance ... Source : Aaron Bertrand -



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


Another Whitepaper from the SQLCAT team, this one covering the importance of an appropriately configured storage system matched to the I/O pattern of the application ... Source : Whitepaper -



SSD Benchmarking


Another great series from Paul, this one examining the performance of SSDs under various workload types ... Source : Paul Randal -



SQL Azure Best Practices


Based on their real world customer experiences, the SQLCAT & Azure teams have posted some great best practice documents for Azure, including "SQL Azure FAQ", "Comparing Azure with SQL Server" and "Security Guidelines for Azure" ... Source : SQLCAT Team -



Using SSAS as a PowerPivot Data Source


Using an SSAS data source as part of a PowerPivot solution throws up some interesting challenges, and in this post, Marco covers the major ones ... Source : Marco Russo -



Creating Sparklines in PowerPivot


Sparklines, new in Excel 2010 and Reporting Services 2008 R2, can also be used in PowerPivot as Patrick shows us in this post ... Source : Patrick LeBlanc -



Distinct Count Optimization Using Solid State Devices


This technical note covers a real world example of how Solid State devices improved cube performance when accessing distinct count measures ... Source : Technical Note -



SSIS : Data Flow paths


Will SSIS execute a data flow path if there are no qualifying records? Josef walks us through an example ... Source : Josef Richberg -



Develop Reporting Services Reports Using SSAS Data


This whitepaper from the SQLCAT team focuses on the technical concepts and techniques used in implementing SSRS reports using an Analysis Services cube as the data source ... Source : Whitepaper -



TCP Offloading


Take a deep dive with the CSS team into the internals of a TCP Chimney/Offloading problem from one of their customers ... Source : Evan Basalik - CSS SQL Server Engineers -



Finding Enterprise Only Features in Your SQL Server 2008 Database


As Glenn points out in this post, one of the annoying things with restoring large databases that use enterprise features such as compression, is that it doesn't fail until the end of the restore process if the server instance performing the restore is not running enterprise edition, potentially wasting hours of time. Glenn goes on to show us how we can use a DMV before we perform the restore to determine if any enterprise features are being used ... Source : Glenn Berry - Blog Post



SQL Azure–what it is and what it isn’t


The description says it all. John Paul Cook takes us on a quick tour of SQL Azure ... Source : John Paul Cook -



The importance of Unit Testing in BI


Unit testing BI solutions is as important (if not more so) than any other solution. In this post, Davide walks us through the benefits and usage of a tool he's developed and placed on codeplex called queryunit ... Source : Davide Mauri -



Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment


This whitepaper from the SQLCAT team is written for architects and administrators looking to deploy PowerPivot throughout an Enterprise ... Source : Whitepaper -



Median calculation in DAX


Marco shows us a neat trick for getting a MEDIAN calculation working in PowerPivot ... Source : Marco Russo -



MDX - Aggregating by member_caption


Richard uses a recursive MDX query to aggregate a dimension hierarchy by member caption, solving a problem whereby, for example, the same customer name exists in different states ... Source : Richard Lees - Blog Post



Cube Writeback in Excel 2010


Although Analysis Services has supported cube writeback for many years, client support has been limited. Excel 2010 improves support for this feature dramatically as Richard shows us in this post ... Source : Richard Lees - Blog Post



Scale-Out Querying for Analysis Services with Read-Only Databases


This white paper from the SQLCAT team describes recommended design techniques and methodologies to maximize the performance and scalability of SQL Server 2008 Analysis Services deployments by using read-only query servers ... Source : Whitepaper -



Using the SSIS Data Viewer


How do you go about debugging complex SSIS data flows with millions of rows when you're only interested in a handful of records? Todd shows us an interesting technique using the data viewer in combination with multicast, conditional splits, sorts and derived columns ... Source : Todd Mcdermid - Blog Post



Report Server Diagnostic Reports


How do you manage the usage, content, permissions and overall health of your SSRS environment? Michael shows us how he manages it ... Source : Michael Davis -



Monitoring SQL Server Virtual Log File Fragmentation


The number of Virtual Log Files (VLFs) in a database can have a direct impact on its performance. In this article, Tom walks us through a powershell script he developed which automates the checking of VLFs across all databases in a given instance ... Source : Thomas LaRock -



Why NUMA matters to admins


NUMA or SMP? Brent talks about what NUMA is, and an example of why it's important we understand it as DBAs ... Source : Brent - Blog Post



Server Migration Checklist


What's involved in making sure a SQL Server migration goes smoothly? Lots ….. Merrill presents us with his checklist ... Source : Merrill Aldrich -



Proven SQL Server Architectures for High Availability and Disaster Recovery


Another great whitepaper from the SQLCAT Team. This one describes five common High Availability and Disaster Recovery architectures for enterprise deployments of SQL Server ... Source : Whitepaper -



IO, IO, It’s Off To Disk We Go!


How do you determine that storage is a performance bottleneck on your system? Denny provides some hints from the perspectives of SQL Server, Windows and the Storage Array itself ... Source : Denny Cherry -



Solid Q Journal


If you don't already know about it, the team at SolidQ are now producing a monthly online journal packed with well written and high quality SQL Server tips and articles. Check it out here ... Source : Greg Low -



Getting Partition Offset information with Powershell


Disk partition alignment is a big issue, with unaligned partitions contributing to disk bottlenecks and various other problems as a result. In this post, Jonathan walks us through a powershell script used to collect this information, and when combined with other scripts, formatted in a nice HTML report ... Source : Jonathan Kehayias -



Using Diskpart and WMIC to Check Disk Partition Alignment


In this post, Paul talks about the disk partition alignment problem, and then a couple of tools that can be used for inspecting the alignment offset values on a server's disk partitions ... Source : Paul Randal -



Tuning Data Warehouse Performance with SQL Server Profiler


In this post, Richard walks us through the process of tuning a Data Warehouse using SQL profiler, and covers some of the important differences when compared to tuning an OLTP database ... Source : Richard Lees - Blog Post



Publishing Master Data with Subscription Views


Subscription views are used in Master Data Services to hide the complexity of the underlying schema from applications consuming master data. In this post, the MDS team describes this feature, and then walks us through the implementation process using an example ... Source : MDS Team -



Does SSAS Support MSDTC Transactions?


In this post, Darren helps us discover whether SSAS supports distributed transactions started within SSIS, and further, whether or not this is desirable ... Source : Darren Gosbell - Blog Post



Improving Excel's Cube Performance


Richard goes behind the scenes with Profiler to discover why Excel sometimes performs poorly when running Analysis Services queries ... Source : Richard Lees - Blog Post



PowerPivot for SharePoint: Single Server Installation


Installing PowerPivot for SharePoint involves a number of steps, and getting them right (and in the right order) is crucial for a pain-free installation. This WhitePaper walks through the steps involved in a single server installation ... Source : Whitepaper -



MDX - Group by measure range dynamically


Another great MDX script from Richard, this one providing a dynamic means to aggregate members by the range of their measure ... Source : Richard Lees - Blog Post



Excel, Cube Formulas, Analysis Services, Performance, Network Latency, and Connection Strings


This technical note from the SQLCAT team looks at how the performance of Excel reports connecting to Analysis Services cubes over slow network links was improved by configuring 3 different connection string settings ... Source : Technical Note -



Data Conversion in SSIS


How do you convert data from one type to another in SSIS? Eric walks us through a few options and the benefits and limitations of each ... Source : Eric Johnson -



My Kerberos Checklist…


Kerberos….. The dreaded K word …. Adam Saxton de-mystifies the beast in this great post ... Source : Adam W. Saxton - CSS SQL Server Engineers - Blog Post



SQL Server Hardware Checklist


Which server properties do you collect/document in a SQL Server hardware audit? Brad offers his own comprehensive list for consideration ... Source : Brad McGehee -



Easy Ways to Detect I/O Pressure in SQL Server 2008


In this post, Glen offers a series of DMV scripts that can be used to determine the existence of I/O pressure, an important diagnostic skill for any DBA ... Source : Glenn Berry - Blog Post



Free ebook: Introducing Microsoft SQL Server 2008 R2


A great (free) e-book on SQL Server 2008 R2 covering the new features in R2 for both DBAs and Business Intelligence professionals ... Source : Stacia Misner -



Top 10 Hidden Gems in SQL 2008 R2


There's lots of press on the big new features in SQL Server 2008 R2, but this post takes a look at some of the lesser known new features such as sysprep, SMB support, enhanced setup and unicode compression ... Source : Technical Note -



Bob Dorr's SQL Server I/O Presentation


Bob Dorr gives us his slide deck and speaker notes for his legendary presentation on SQL Server I/O. Don't miss this one ... Source : Bob Dorr - CSS SQL Server Engineers - Blog Post



Fusion-IO ioDrive Review


A great review of the Fusion-IO SSD drive from BrentO ... Source : Brent - Blog Post



Copyright (c) 2015   |  Privacy Statement  |  Terms Of Use

acheter chaussres nike air max 2014

acheter chaussures nike free run 2014