Browse by Tags

  

Tagged Content List
  • Blog Post: SQL Server Statistics: Charting Volatile Data And Density Vector Values

    Summary : Tony O'Grady , a Microsoft Premier Field Engineer based in the UK, continues with his second post of 5 advanced articles on charting statistical data with SQL Server. In this post he explores how changes to the underlying data are reflected in cardinality estimations, explores some scenarios...
  • Blog Post: Introducing RAP as a Service from Microsoft Services Premier Support

    Hello everyone, my name is Yong Rhee and I’m a Premier Field Engineer. In this post, I’m excited to discuss a new Premier Support offering called Risk Assessment Program (RAP) as a Service. For those that are not familiar with RAP, it is a Microsoft Services Premier Support offering that...
  • Blog Post: Adventures in Installing the SQL Server AdventureWorks Sample Database

    Written by Mohit Gupta, Microsoft Premier Field Engineer. I was thinking of writing an article about Microsoft SQL Server T-SQL Basics; however, in order to do the examples and demos I wanted to use a database that’s readily available on the Internet, so I decided to use the common AdventureWorks...
  • Blog Post: How to keep end users happy during migration to SQL Server 2008

    Written by Sadeesh Poovalur, Senior Microsoft Premier Field Engineer, based in Canada. To achieve a smooth and seamless transition when upgrading versions of your SQL Server database(s), appropriate planning is required or you risk having unhappy users and/or malfunctioning database applications. There...
  • Blog Post: Groom your SQL Server for its ongoing health

    Pedro Azevedo Lopes shares his prescription for a better-looking SQL Server in his post About Maintenance Plans – grooming SQL Server : I admit I’m not a big fan of Maintenance Plans (the feature that goes by that name) mainly because of its “do or die” approach. So, it was not by chance that I wrote...
  • Blog Post: SQL Server Compression Estimator Now Available

    Written by boB Taylor , Principal Microsoft Premier Field Engineer. Now Available! A smaller, leaner database.  I have released my SQL Server Compression Estimator tool to CodePlex . One of the most exciting additions to SQL Server 2008 was the capability to apply data compression. The benefits...
  • Blog Post: SQL Saturday in Baton Rouge… is this Saturday!

    This post was written by Mike Huguet, Premier Field Engineer. Along with the team of PFEs presenting, Mike was an active participant in planning and organizing this event, and is one of its founders. SQL Saturday is a well-known, regularly scheduled training event for SQL Server professionals, as well...
  • Blog Post: 10 Top SQL Server Issues Uncovered By The SQL Server Risk Assessment Program

    Our very own editor-at-large by night and Microsoft Principal Premier Field Engineer by day (and night as well!) Arvind Shyamsundar takes us on a tour of some of the top issues detected across Microsoft’s broad customer base by the Microsoft Premier Support SQL Server Risk Assessment Program (a...
  • Blog Post: A Quick Look At System Center Advisor (SCA)

    Summary: Milad Aslaner , a Microsoft Premier Field Engineer based in Germany, gives us a quick peek at System Center Advisor (SCA), a freely available cloud-based service from Microsoft that enables you to assess your server configurations and proactively avoid problems. As you probably know by...
  • Blog Post: SQLSaturday 258, Istanbul Event Recap

    This write-up of SQL Saturday in Istanbul was provided by Turgay Sahtiyan, a Senior PFE specializing in SQL Server. Along with the team of PFEs presenting, Turgay was an active participant in planning and organizing this event, and is one of its founders. After SQLSaturday 258, Istanbul event, I would...
  • Blog Post: How To Convert SQL Server datetime Data To UTC Time

    Written by boB Taylor , Principal Microsoft Premier Field Engineer. As the world moves to a global economy, it becomes more and more important to capture time information with respect to Coordinated Universal Time ( UTC ). This format captures the date and time along with a time zone offset (offset...
  • Blog Post: SQL Server 2012 AlwaysOn FAQs

    Krishna Golla has a grab-bag of SQL Server 2012 AlwaysOn FAQs suitable for DBAs and Infrastructure types, covering everything from the hotfixes recommended for AlwaysOn, to whether Availability Groups can be defined outside a domain boundary. For example, in the Failover Scenarios section: 1. What happens...
  • Blog Post: A Microsoft SQL Server DMV/DMF Cheat-Sheet

      Written by Mohit Gupta, Microsoft Premier Field Engineer. I am asked this question by Microsoft SQL Server customers again and again: “What dynamic management views ( DMV ) or dynamic management functions ( DMF ) should I use?” The short answer is, as many as you need. The detailed answer is,...
  • Blog Post: The Case For Hosting a ConfigMgr SQL Database on a Dedicated SQL Instance

    Summary : Piotr Gardy , a Microsoft Premier Field Engineer based in Poland, provides us with recommendations on why (and how) a ConfigMgr database should be hosted on its own dedicated SQL Server instance. For more useful tidbits, please check out Piotr’s Polish language TechNet blog . ...
  • Blog Post: How To Monitor Deadlocks in SQL Server

    Written by Mohit Gupta, Microsoft Premier Field Engineer. Every now and then we have deadlocks taking place in SQL Server.  Most go unnoticed, either because the frontend application handles it gracefully.  Or no error is not reported out to the user. What is a Deadlock? Deadlocks happen when...
  • Blog Post: Microsoft PFE is at SQL Saturday 231!

    SQL Saturday is a well-known, regularly scheduled training event for SQL Server professionals and those wanting to learn about SQL Server. This event is run in partnership with the renowned SQL PASS association and features deep technical content from both community champions and speakers from the local...
  • Blog Post: An easy-to-use dashboard over the SQL Server System Health session

      SQL Server 2008 and above provide an amazing diagnostics capability in the form of the System Health extended events session. However, not everyone knows about it – part of the reasons being that there is not a convenient way to visualize the data collected therein. Our colleagues at the SQL Server...
  • Blog Post: SQL Iterators: Making the Life of a SQL Server DBA That Much Easier

    Written by boB Taylor , Principal Microsoft Premier Field Engineer. Many Microsoft SQL Server DBAs automate as many of their day to day processes as possible, freeing them to attend to higher impact activities. To do so, many DBAs leveraged two undocumented system stored procedures, namely sp_MSForEachDatabase...
  • Blog Post: Project Barcelona: A Revolution in Enterprise Metadata Management

    Written by Chris Tao, Microsoft Premier Field Engineer. Have you ever been asked the following questions when passing through the immigration counter to enter a foreign country? Who are you? Where are you from? Where are you going to? What are you doing here? Most people can usually answer these questions...
  • Blog Post: New for SQL Server: the SQLDiag Configuration Tool is Released

    Written by boB Taylor , Principal Microsoft Premier Field Engineer. The wait is finally over!  The SQLDiag Configuration Tool has been released. One of the most heavily used tools in the SQL Server Premier Field Engineer’s tool belt is PSSDiag . It is maintained by Microsoft’s Customer Service and...
  • Blog Post: Understanding SQL Server Cardinality Estimations by Charting Histogram to Actual Values

    Summary : Tony O'Grady , a Microsoft Premier Field Engineer based in the UK, helps us understand whether or not a SQL dataset is going to produce useful query statistics by looking for patterns in histogram values in comparison to actual values. He introduces SQL Server histograms and explains how SQL...
  • Blog Post: Backup your SQL 2012 database to Windows Azure blob storage!

    Our colleagues in Korea are always at the leading edge of technology. My friend Ji Yong Seong from the PFE Korea team has created a wonderful blog post on a new feature in SQL 2012 SP1 CU2 which enables backup / restore of databases to and from Windows Azure blob storage. Great stuff! Posted by Arvind...
  • Blog Post: A Microsoft SQL Server DMV/DMF Cheat-Sheet (Part 2)

    Written by Mohit Gupta, Microsoft Premier Field Engineer. In my last post I talked about how to get the list connections (e.g. who is connected and requests are they running on SQL Server). I talked about how to use dm_exec_connections, dm_exec_sessions and dm_exec_requests, we saw how powerful...
  • Blog Post: Project Barcelona: A Revolution in Enterprise Metadata Management – Part 2

    Written by Chris Tao, Microsoft Premier Field Engineer. In my last article , we discussed the nature of metadata, the need for metadata management in the modern enterprise, and some fundamental information about Project Barcelona. In this article, we will go through the Project Barcelona product UI ...
  • Blog Post: How To Activate the .NET Framework 3.5 on Windows 8 Without Internet Access

    Summary: Milad Aslaner , a Microsoft Premier Field Engineer (PFE) based in Germany, walks us through how you can activate the .NET Framework 3.5 on Windows 8 when you don’t have access to the Internet. Enjoy! I had to install SQL Server 2012 on my lab computer today. For those of you who...