Browse by Tags

Tagged Content List
  • Blog Post: AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.

    Author : Sanjay Mishra Reviewers : David P. Smith (Active Network), Mike Ruthruff (Bungie Studios), Matt Neerincx, Luis Carlos Vargas Herring, Piyush Ranjan, Steven Schneider   My job provides me opportunity to work across different sections of customers – some customers who like all defaults...
  • Blog Post: AlwaysOn Availability Group in Windows Azure VM: Client Connectivity Scenarios

    Author : Sanjay Mishra Contributors : Piyush Ranjan, Steven Schneider Reviewers : Ed Muth, Chuck Heinzelman, Silvano Coriani, Rama Ramani, Juergen Thomas, Cephas Lin, Lori Clark, Luis Carlos Vargas Herring Once you have created AlwaysOn Availability Groups in Windows Azure VM ( tutorial ) and created...
  • Blog Post: Scaling-out SQL Server disks and data files on Windows Azure Virtual Machines…a real-world example

    Authors: Tim Wieman , Sanjay Mishra Technical Reviewers: Silvano Coriani, Cindy Gross, Chuck Heinzelman, Shep Sheppard, Mike Weiner, Nicholas Dritsas, Steve Howard, James Podgorski, Juergen Thomas, Ewan Fairweather This blog will demonstrate a real-world customer example of scaling out Microsoft...
  • Blog Post: Be aware of the difference in isolation levels if porting an application from Windows Azure SQL DB to SQL Server in Windows Azure Virtual Machine

    [One more post recovered from SQLCAT.com archives.] Author : Sanjay Mishra, Tim Wieman Technical Reviewers : Mike Weiner, Shep Sheppard, Prem Mehra, Chuck Heinzelman, James Podgorski, Silvano Coriani, Madhan Arumugam Ramakrishnan, Sunil Agarwal, Guy Bowerman Windows Azure SQL Database...
  • Blog Post: SQLCAT.Com - eBook Downloads

    As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication. MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated...
  • Blog Post: SQL Server Self-Service Kit : Provisioning SQL Server as a Service

    Some great work is being done by the Windows Server and System Center CAT related to Hybrid Cloud and… Wait for it… Provisioning SQL Server as a Service! A snippet from the recent blog post Provisioning SQL Server as a Service with the System Center stack ; “Can I use System...
  • Blog Post: Performance Guidance for SQL Server in Windows Azure Virtual Machines

    Authors : Silvano Coriani, Jasraj Dange, Ewan Fairweather, Xin Jin, Alexei Khalyako, Sanjay Mishra, Selcin Turkarslan Technical Reviewers : Mark Russinovich, Brad Calder, Andrew Edwards, Suraj Puri, Flavio Muratore, Hanuma Kodavalla, Madhan Arumugam Ramakrishnan, Naveen Prakash, Robert Dorr, Roger...
  • Blog Post: Technical Reference Guides for Designing Mission-Critical Solutions using SQL Server are available

    The Technical Reference Guides for Designing Mission-Critical Solutions provide planning and architecture guidance for various mission-critical workloads deployed by users. These guides reflect the knowledge gained by the CAT team while working with customers on mission-critical deployments, many of...
  • Blog Post: Writing New Hash Functions for SQL Server

    Author: Thomas Kejser Contributors/Reviewers: Alexei Khalyako, Jerome Halmans, Fabricio Voznika, Sedat Yogurtcuoglu, Mike Ruthruff, Tobias Ternstrom and Steve Howard In this blog, I will explore ideas for extending SQL Server with new, fast hash functions. As will be shown, the high speed, built in functions...
  • Blog Post: Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot

    Author : Shaun Tinline-Jones Reviewers : Mike Ruthruff, Sanjay Mishra, Alexei Khalyako Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot...
  • Blog Post: Unintended Consequences of Scalar-Valued User Defined Functions

    Author: Chuck Heinzelman Reviewers: Kevin Cox, Dan Jones, Lara Rubbelke During a customer engagement, we noticed a query that was taking a long time to execute. We saw that the query had a scalar-valued User Defined Function (UDF) encapsulating functionality in the SELECT clause. To understand...
  • Blog Post: Unexpected Consequences of Multiple Result Sets

    Author: Chuck Heinzelman Reviewers: Kevin Cox, Kun Cheng, Michael Thomassy In a recent customer engagement, I was presented with a problem that I have seen in the past and am surprised that I don’t see more often. Take the following table as an example: CREATE TABLE dbo.ResultSetTest...
  • Blog Post: SQL Server Migration Assistant (SSMA) v5.0 just released!

    Exciting news as earlier this week the SQL Server Product Group announced the release of SQL Server Migration Assistant (SSMA) v5.0! A product with the goal of further simplifying the user experience in automating the migration of Oracle, Sybase, MySQL and Microsoft Access databases to SQL Server or...
  • Blog Post: Optimize Recursive CTE Query

    Author : Shaun Tinline-Jones Reviewers: Lubor Kollar; Conor Cunningham; Steve Howard; Kun Cheng; James Podgorski; Jimmy May; Joseph Sack; Welly Lee; Neeraj Joshi; Keith Bauer Introduction We recently assisted a global ISV to address a performance issue related to a poor performing recursive...
  • Blog Post: 32- and 64-Bit Connectivity from the Same Machine

    Author: Chuck Heinzelman Reviewers: Steve Howard, Carl Rabeler, Shaun Tinline-Jones, Mike Weiner, Murshed Zaman I was recently involved in a customer lab testing the Microsoft Business Intelligence stack. I noticed an interesting behavior when working on one of my test servers. Here’s...
  • Blog Post: Linked Servers to SQL Azure

    Authors: Kevin Cox & Michael Thomassy Contributors: Lubor Kollar Technical Reviewers: Shaun Tinline-Jones, Chuck Heinzelman, Steve Howard, Kun Cheng, Jimmy May Overview Connecting directly to a SQL Azure database from a reporting tool (like Microsoft Excel and PowerPivot, or SQL Server...
  • Blog Post: How to tell which version of SQL Server data access driver is used by an application client

    In a recent engagement with an ISV, we’ve run into a sporadic application failure problem when the application is deployed in a mixed environment. It comes down to finding out which version of SQL Server driver the application uses for connection. In the mixed environment, some application server...
  • Blog Post: New Release of SQL Server Migration Assistant (SSMA) includes migration from MySQL and to SQL Azure

    Wanted to let the community know the SQL Server Product Group just released version 4.2 of the SQL Server Migration Assistant! With this version, Microsoft has announced the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL! Microsoft refreshed the existing SSMA...
  • Blog Post: Character data type conversion when using SQL Server JDBC drivers

    Author: Kun Cheng Reviewers: Wanda He, Kevin Cox, Michael Thomassy, Peter Scharlock In a recent customer engagement, I ran into an interesting situation, which I’d like to share, especially with SQL Server users using Microsoft JDBC drivers. It started with typical SQL Server performance tuning exercise...
  • Blog Post: Moving the Transaction log file of the Mirror Database

    Author: Sanjay Mishra Reviewers: Prem Mehra, Mark Souza, Kun Cheng, Nicholas Dritsas, Thomas Kejser Recently I worked with a customer who has deployed database mirroring for a very large database (~ 1 TB) between two data centers that are about 400 miles apart. I got an email from the customer...
  • Blog Post: Enabling Partition Level Locking in SQL Server 2008

    Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin Cox, Kun Cheng In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate the feature, here’s a bit of background about...
Page 1 of 1 (21 items)