The Curious Engineer

All blogs / Databases

CSS SQL Server Engineers

learn.microsoft.com/en-us/archive/blogs/psssql

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services team.

DatabasesPerformance / optimizationDistributed systems / cloudMicrosoft blogsMSDN archive

’10’15’20’25
Posts
620 from 8 Nov 2006 to 19 Oct 2018
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/psssql/feed.xml

2018 9

  1. Understanding Optimizer Timeout and how Complex queries can be Affected in SQL Server
  2. AGLatency report tool V2.2 introduction
  3. July 10, 2018 Windows updates cause SQL startup issues due to "TCP port is already in use" errors
  4. Lesson learned from an Availability Group performance case
  5. Troubleshooting data movement latency between synchronous-commit AlwaysOn Availability Groups
  6. Installation of SQL Server 2017 failing with 'VS Shell installation has failed with exit code 1638'
  7. Uniqueifier considerations and error 666
  8. SQL Setup ToolSuite Introduction (3) – SQL Registry Viewer Version 2.2
  9. SQL Setup ToolSuite Introduction (2) – Product Browser

2017 16

  1. Changes to hashing algorithm for self-signed certificate in SQL Server 2017
  2. How to safeguard SQL Server on Linux from OOM-Killer
  3. New season, New software, New servicing model
  4. SQL Nexus 6.0 is released to github
  5. SQL Server : large RAM and DB Checkpointing
  6. You may see “out of user memory quota” message in errorlog when you use In-Memory OLTP feature
  7. Unable to issue alter table for a memory optimized tables
  8. Memory optimized table variable and cardinality estimate
  9. Unable to restore a backup - Msg 3241
  10. Why am I getting so many checkpoint files when I have In-Memory OLTP enabled?
  11. A few new things in XML plan to help you troubleshoot query performance
  12. Be aware of 701 error if you use memory optimized table variable in a loop
  13. Importance of choosing correct bucket count of hash indexes on a memory optimized table
  14. Solving SQL Connectivity issues: A new guided walk through just got published
  15. Pssdiag & Sqldiag Manager update
  16. Why can’t I get a parallel plan when rebuilding my index?

2016 49

  1. Unable to connect to SQL Server AlwaysOn Listener on Azure due to misconfigured subnet mask
  2. SQL Nexus 5.5.0.1 was released
  3. Unable to drop a user in a database
  4. Backup to remote Azure URL failed due to throttling at VM level
  5. SQL 2016 -- Why can’t I STRETCH my database (I have the right user name and password)?
  6. Default auto statistics update threshold change for SQL Server 2016
  7. Proxy settings & backup to URL (Azure blob storage)
  8. Why “SQL Server Configuration” section on my Azure Virtual Machine is not available?
  9. Unable to connect to SQL Server on azure VM due to an extra NSG applied to subnet
  10. Why am I getting NULL values for query_plan from sys.dm_exec_query_plan?
  11. Why do I get the infrastructure error for login failures?
  12. Tips & Tricks on ‘cloning’ Azure SQL virtual machines from captured images
  13. New memory grant query hint MIN_GRANT_PERCENT came to rescue
  14. Bob is Moving To BOBSQL
  15. SQL 2016 - It Just Runs Faster: XEvent Linq Reader
  16. SQL 2016 - Leverages On Demand MSDTC Startup
  17. SQL 2016 - It Just Runs Faster: In-Memory Optimized Database Worker Pool
  18. SQL 2016 - It Just Runs Faster - AlwaysOn AES-NI Encryption
  19. SQL 2016 - It Just Runs Faster: AlwaysOn Parallel Compression / Improved Algorithms
  20. SQL 2016 - It Just Runs Faster: AlwaysOn Log Transport Reduced Context Switches
  21. SQL 2016 - It Just Runs Faster - BULK INSERT Uses Vector Instructions (SSE/AVX)
  22. SQL 2016 - It Just Runs Faster: Column Store Uses Vector Instructions (SSE/AVX)
  23. Why do we see ENCRYPTION_SCAN locks in a SQL server
  24. SQL 2016 - It Just Runs Faster: Multiple Log Writer Workers
  25. SQL 2016 - It Just Runs Faster: Larger Data File Writes
  26. SQL 2016 - It Just Runs Faster: Larger Data File Writes
  27. SQL 2016 - It Just Runs Faster: Indirect Checkpoint Default
  28. SQL 2016 - It Just Runs Faster: SOS_RWLock Redesign
  29. Deadlock Monitor Also Grants Locks
  30. SQL 2016 - It Just Runs Faster: Dynamic Memory Object (CMemThread) Partitioning
  31. SQL 2016 - It Just Runs Faster: Updated Scheduling Algorithms
  32. SQL 2016 - It Just Runs Faster: Automatic Soft NUMA
  33. Solve your tempdb problems with memory optimized tables
  34. SQL 2016 - It Just Runs Faster: Instant File Initialization
  35. Repeated login failures on an Azure SQL Virtual Machine
  36. SQL 2016 - It Just Runs Faster: LDF Stamped
  37. SQL 2016 - It Just Runs Faster: Automatic TEMPDB Configuration
  38. Unable to connect to SQL Server on Azure Virtual Machine–VNET Problem
  39. SQL 2016 - It Just Runs Faster: -T1117 and -T1118 changes for TEMPDB and user databases
  40. SQL 2016 - It Just Runs Faster: Spatial Index Builds Faster
  41. SQL 2016 - It Just Runs Faster: TVPs with Spatial Column(s)
  42. SQL Server Parallel Query Placement Decision Logic
  43. SQL 2016 - It Just Runs Faster: Native Spatial Implementation(s)
  44. SQL 2016 - It Just Runs Faster: DBCC Extended Checks
  45. Moving your Azure SQL Virtual Machines to a different resource group
  46. SQL 2016 - It Just Runs Faster: DBCC Scales 7x Better
  47. Not every extended event is suited for all situations
  48. SQL 2016 - It Just Runs Faster Announcement
  49. TLS 1.2 Support for SQL Server 2008, 2008 R2, 2012 and 2014

2015 42

  1. Wanting your non-sysadmin users to enable certain trace flags without changing your app?
  2. What to do when you run out of disk space for In-Memory OLTP checkpoint files
  3. Spool operator and trace flag 8690
  4. SQL Server 2016 Temporal Data Assists Machine Learning Models
  5. MultiSubnet = TRUE Is Now Default Behavior
  6. Will SQL Server use ‘incomplete’ or ‘dirty’ statistics during online index rebuild?
  7. The given network name is unusable because there was a failure trying to determine if the network name is valid for use by the clustered SQL instance
  8. Are My Statistics Correct?
  9. In-Memory OLTP files –what are they and how can I relocate them?
  10. Using the SSMS ConnectionDialog
  11. How to get up and running with Oracle and Linked Servers
  12. Error 17053 when using third party network storage device / SMB file share
  13. What build of SQL Server are you using?
  14. Sparse Files – Supported on both NTFS and REFS
  15. How It Works: SQL Server (SQLNCLI11) ODBC Driver–Keyset Cursor
  16. Getting the latest SQL Server Native Client
  17. Upcoming end of support for SQL Server 2005
  18. Not able to use PFX format certificate in SQL Server?
  19. Identifying SQL Server 2014 New Cardinality Estimator issues and Service Pack 1 improvement
  20. Operating System Error (665 – File System Limitation) Not just for DBCC Anymore
  21. How to get unstuck when using SQL Aliases
  22. Error in XML document. Hexadecimal value 0x1F, is an invalid character
  23. SQL Server Page Life Expectancy (PLE)
  24. XEvent Timestamp is a large integer value not the expected datatime value
  25. Server’s “Max Degree of Parallelism” setting, Resource Governor’s MAX_DOP and query hint MAXDOP–which one should SQL Server use?
  26. Forced parameterization to the rescue
  27. Pssdiag Manager update 12.0.0.1001 released
  28. What is RESOURCE_GOVERNOR_IDLE and why you should not ignore it completely
  29. Understanding SQL Server’s Spatial Precision Filtering
  30. Does statistics update cause a recompile?
  31. Reporting Services: Error creating HTTP endpoint - Access is Denied
  32. Moving Reporting Services off of a Cluster
  33. Does rebuild index update statistics?
  34. How It Works: MAX DOP Level and Parallel Index Builds
  35. Running SQL Server on Machines with More Than 8 CPUs per NUMA Node May Need Trace Flag 8048
  36. Frequently used knobs to tune a busy SQL Server
  37. Troubleshooting Memory Issues with Reporting Services
  38. SQL Server and SSDs – RDORR’s Learning Notes - Part 1
  39. #Error When Rendering Report
  40. Do I really need to use DTC Transactions?
  41. A faster CHECKDB – Part IV (SQL CLR UDTs)
  42. JDBC: This driver is not configured for integrated authentication

2014 36

  1. How It Works: sp_server_diagnostics – spinlock backoffs
  2. How come sys.dm_exec_requests.cpu_time never moves?
  3. A faster CHECKDB – Part III
  4. SQL Server MAX DOP Beyond 64 – Is That Possible?
  5. SQL CLR assembly fails verification with “Unable to resolve token”
  6. A Partitioned Table May Limit the Runtime MAX DOP of Create/Alter Index
  7. Power View in Excel won’t render from SharePoint
  8. VSS backup of AlwaysOn Secondaries
  9. Having performance issues with table variables? SQL Server 2012 SP2 can help!
  10. The Additive Design of SSAS Role Security
  11. How It Works: XEvent Output and Visualization
  12. Read this if you have transactional replication configured and plan to upgrade from SQL 2008/2008 R2 to SQL 2012/2014
  13. Slow query using non-deterministic user defined function
  14. Getting Cross Domain Kerberos and Delegation working with SSIS Package
  15. Kerberos Configuration Manager updated for Analysis Services and SQL 2014
  16. These resources may help resolve your issue….
  17. Using SQL Server in Microsoft Azure Virtual Machine? Then you need to read this…
  18. REPL_SCHEMA_ACCESS wait type
  19. Capping CPU using Resource Governor – The Concurrency Mathematics
  20. How It Works: Behavior of a 1 Trillion Row Index Build (Gather Streams from SORT)
  21. How to grab multiple parent/child elements from XML Data Source
  22. SharePoint Adventures : Using Claims with Reporting Services
  23. Version 9.04.0013 of the RML Utilities for x86 and x64 has been released to the download center
  24. RS, SharePoint and Forefront UAG Series – Intro
  25. RS, SharePoint and Forefront UAG Series – Part 2 (Operational Reports)
  26. RS, SharePoint and Forefront UAG Series – Part 3 (Power Pivot Gallery - Silverlight)
  27. RS, SharePoint and Forefront UAG Series – Part 4 (Power View - Export to PowerPoint)
  28. SQL Server 2014: TEMPDB Hidden Performance Gem
  29. How It Works: FileStream (RsFx) Garbage Collection–Part (2)
  30. I think I am getting duplicate query plan entries in SQL Server’s procedure cache
  31. SQL Server 2014’s new cardinality estimator (Part 1)
  32. Don’t Rely On a Static IP Address for Your SQL Database
  33. SQL Nexus 4.0 Released to codeplex
  34. sp_reset_connection – Rate Usage (Don’t fight over the grapes)
  35. Can’t Connect to SQL when provisioning a Project App in SharePoint
  36. As The World Turns: SQL Server NUMA Memory Node and the Operating System Proximity

2013 52

  1. Spatial Index is NOT used when SUBQUERY used
  2. How Simple Parameterization works
  3. Kerberos Configuration Manager updated for Reporting Services
  4. Spatial Indexing: From 4 Days to 4 Hours
  5. All about RollbackSnapshotTempDB...
  6. Cumulative Update 2 to the RML Utilities for Microsoft SQL Server Released
  7. SQL Connection Pool Timeout Debugging
  8. Every time I ‘ATTACH DATABASE’ SQL logs error 1314 for SetFileIoOverlappedRange
  9. Microsoft CSS @ PASS Summit 2013
  10. Invalid or loopback address when configuring SharePoint against a SQL Server
  11. Error during installation of an SQL server Failover Cluster Instance
  12. How It Works: Maximizing Max Degree Of Parallelism (MAXDOP)
  13. Interpreting the counter values from sys.dm_os_performance_counters
  14. [SQL 2012 query plan enhancement] I want to know why my query is not parallelized
  15. When is throttling in Windows Azure SQL Database really throttling….
  16. Service status watcher in SQL Server Management Studio – How it works
  17. Power View display issues with Page Viewer Web Part
  18. Optimizing partition split when the partition is not empty
  19. How It Works: SQL Server 2012 Database Engine Task Scheduling
  20. Error trying to access SharePoint List from Power Query
  21. After applying Service Pack 1 for SQL Server 2012 you may encounter a known issue! Details inside…..
  22. Tracking down Power View Performance Problems
  23. When Does sp_prepare Return Metadata
  24. DReplay Message: “Active connections exceed 8192, connection 8409 is waiting.”
  25. High CPU Troubleshooting with DMV Queries
  26. A performance issue involving CLR garbage collection and SQL CPU affinity setting
  27. Getting a SharePoint List Data Source to work with Reporting Services Native Mode
  28. How It Works: The I/O Path: SQL Server Running in Windows Azure Virtual Machine (IaaS)
  29. Why won't my PowerPivot for Excel 2010 workbook upgrade to Excel 2013?
  30. SharePoint Adventures : Claims, Named Pipes and Kerberos
  31. SharePoint Adventures : When connectivity is not connectivity
  32. SQL Server–Storage Spaces/VHDx and 4K Sector Size
  33. Using PowerShell to discover Reporting Services 2012 in SharePoint
  34. AlwaysON - HADRON Learning Series: lock_redo_blocked/redo worker Blocked on Secondary Replica
  35. AlwaysON - HADRON Learning Series: HADR_SYNC_COMMIT vs WRITELOG wait
  36. How It Works: Always On–When Is My Secondary Failover Ready?
  37. SQLIOSim Checksum Validations
  38. The Case of Anti-Virus filter drive interference with File Stream Restore
  39. PowerPivot Table Import Wizard cannot find provider
  40. System Center Advisor is now free
  41. SQL Server 2012 partitioned table statistics update behavior change when rebuilding index
  42. switchoffset built-in function can cause incorrect cardinality estimate
  43. Temp table caching improvement for table valued parameters in SQL Server 2012
  44. Unable to register .NET framework assembly not in the supported list
  45. RS: Database Engine does not meet edition requirements
  46. Breaking Down 18056
  47. Under rare conditions, using IN clause can cause unexpected SQL behavior
  48. Query hint QUERYTRACEON is now documented publically
  49. Don’t change value of that parameter
  50. AppDomain unloading messages flooding the SQL Server error log
  51. How can I get that user out of my table quickly
  52. Getting a Power View report within Excel 2013 to work with SharePoint

2012 59

  1. Uneven query executions with parallelism
  2. How It Works: CMemThread and Debugging Them
  3. SQLCLR and sp_OA* procedures are not compatible
  4. Azure SQL Database Import/Export Service - Change always brings both challenges and benefits
  5. How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks)
  6. How It Works: SQL Server 32 bit PAE/AWE on (SQL 2005, 2008, and 2008 R2) – Not Using As Much RAM As Expected!
  7. SQL Server 2012 Setup just got smarter…
  8. AlwaysOn ERROR: Log backup for database "MyDB" on secondary replica created backup files successfully but could not ensure that a backup point has been committed on the primary.
  9. FileNotFoundException with Microsoft.AnalysisServices.Xmla
  10. How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower
  11. Analysis Services - Errors when trying to add a User as a Server Admin
  12. Ack! Where the heck did Azure Reporting and Data Sync go??!?!
  13. Using a Windows Azure worker role to generate reports using Azure Reporting
  14. How Can Reference Counting Be A Leading Memory Scribbler Cause?
  15. Microsoft CSS @ PASS Summit 2012
  16. Worker thread governance coming to Azure SQL Database
  17. T-SQL Update Takes Much Longer Than The Matching Select Statement
  18. SQL Server: Correlating Timestamps From Various Data Points
  19. Revisiting Inside Tempdb….
  20. Bulk Insert and Kerberos
  21. How It Works: SQL Server AlwaysOn Lease Timeout
  22. AdomdConnectionException using PerformancePoint hitting Analysis Services
  23. How It Works: Online Index Rebuild - Can Cause Increased Fragmentation
  24. Installing SQL Server on Windows 8
  25. Strange Sch-S / Sch-M Deadlock on Machines with 16 or More Schedulers
  26. SharePoint Adventures : Reporting Services, Claims and One Way Trusts
  27. SETSPN -A with Windows 2012 does a duplicate check upfront
  28. SharePoint Adventures : AccessDeniedException when a user tries to Add Subscription
  29. PowerShell and AlwaysOn - Gotcha - Exception setting "ConnectionString": "Keyword not supported: 'applicationintent'."
  30. How It Works: XEL Display in SQL Server Management Studio (SSMS) Row Limit
  31. How It Works: SQL Server (BCP, Database I/O, Backup/Restore, …) Reports Operating System Error (665, 1450 or 33) when writing to the file - BIG DATA
  32. SocketException when upgrading Reporting Services from SQL 2008/R2 to SQL 2012
  33. PowerPivot : When versions get mixed up…
  34. Where Did My Availability Group (AG) Go?
  35. SharePoint Adventures : Access Denied errors when using RS 2012 with a Claims SharePoint Site
  36. SharePoint Adventures : “The connection either timed out or was lost” with RS DataSource to SSAS
  37. Could not load file or assembly System.EnterpriseServices
  38. How It Works: DROP AVAILABILITY GROUP Behaviors
  39. How It Works: When is the FlushCache message added to SQL Server Error Log?
  40. AlwaysON - HADRON Learning Series: Worker Pool Usage for HADRON Enabled Databases
  41. SQL Rally 2012 recap
  42. CSS will be at SQL Rally
  43. Clarification about the two LPIM upgrade rules that did not FAIL
  44. BISM: value of the 'EffectiveUserName' XML for Analysis property is not valid
  45. Behavior Change When Handling Character Conversions SQL Server’s ODBC Driver (SQL 2012 – Version 11.xx)
  46. Working with Power View: Some controls on this presentation can't be activated
  47. Working with Power View: Click to Interact is not available
  48. How It Works: HealthCheckTimeout Interval Activities
  49. SQL Server 2012: RML, XEvent Viewer and Distributed Replay
  50. How It Works: XEvent Action vs Field data values.
  51. AlwaysON - HADRON Learning Series: Automated Failover Behaviors (Denali - Logging History Information, FCI and Default Health Capture, sp_server_diagnostics)
  52. SetFileIoOverlappedRange Can Lead to Unexpected Behavior for SQL Server 2008 R2 or SQL Server 2012 (Denali)
  53. SQL Server 2012 - True Black Box Recorder
  54. A faster CHECKDB – Part II
  55. Analysis Services Thread Pool Changes in SQL Server 2012
  56. Management Studio tricks you may or may not know about
  57. The case of the incorrect page numbers
  58. How It Works: sys.dm_tran_session_transactions
  59. How It Works: sys.dm_io_pending_io_requests

2011 62

  1. A faster CHECKDB – Part I
  2. Exporting via HTML instead of MHTML
  3. Distributed Replay for SQL Server 2012
  4. SQL Server: Clarifying The NUMA Configuration Information
  5. Error 1803 and model size change in SQL Server 2012
  6. The week that was PASS 2011 & Moving on…
  7. Easy JDBC Logging
  8. A Better solution for the Windows 7 SP1 ADO GUID changes
  9. After Applying SQL Server 2008 R2 SP1 Error 9013 is logged (The tail of the log for database %ls is being rewritten to match the new sector size of %d bytes …)
  10. RML Questions
  11. Inside the SQL Server Clinic…
  12. The SQL PASS Summit comes again to Seattle and CSS will be there…
  13. The DMV sys.dm_os_memory_clerks May Show What Appears To Be Duplicate Entries
  14. SQL Server 2008/2008 R2 on Newer Machines with More Than 8 CPUs Presented per NUMA Node May Need Trace Flag 8048
  15. How compressed is your backup?…
  16. Stored procedure recompile caused by alter table on temp table
  17. How It Works: Return codes from SQLIOSim
  18. Trace shows the incorrect Session Login Name
  19. SQL Server 2008 R2 does not start when applying certain hotfix updates
  20. Inappropriate usage of high isolation level isn’t just about blocking when it comes to performance
  21. How It Works: FileStream (RsFx) Garbage Collection
  22. Tracking Down Missing Indexes in SQL Azure
  23. Dipping My Toes Into SQL Azure – Part 2 – Protection Mechanisms
  24. JDBC 1.x: “She sure was a good ship”…
  25. Dipping My Toes Into SQL Azure
  26. Pssdiag/Sqldiag Configuration Manager released to codeplex
  27. Slow performance and out of memory issues caused by large batch
  28. SharePoint Adventures : ADFS Setup – Part 2
  29. SharePoint Adventures : ADFS Setup – Part 1
  30. New extended event to track writes to the snapshot sparse file
  31. Why the Query Designer Table Listing could be empty
  32. NOT (LinkedServertoSQLAzure) where Provider=’MSDASQL’ and DSN=’SQL Server Native Client’
  33. Why does this query consumes so much CPU?
  34. AlwaysON - HADRON Learning Series: Maximum Failovers Within Specified Period
  35. MS11-028 may cause issues with SQL, Exchange and PowerShell
  36. Conversion issues moving from VS 2005 to VS 2008
  37. System Center Advisor: Finishing off my first list of advice….
  38. RS Report Performance Relief in CU7
  39. Why am I getting prompted for Credentials?
  40. System Center Advisor: What is the email all about?…
  41. System Center Advisor: Anything interesting before I catch a plane…
  42. System Center Advisor Day 3: What happened to my alerts?
  43. System Center Advisor: The Next Day….
  44. Atlanta becomes a product….System Center Advisor
  45. To 1433 or not to 1433...that is the question
  46. Think Negative (with RS Visibility)
  47. SharePoint Adventures : Why isn't Claims working with SSRS?
  48. What URL to use for Azure Reporting
  49. SharePoint Adventures : How to identify if you are using Claims Authentication
  50. SharePoint Adventures : Using Kerberos with the Report Server
  51. Did your backup program/utility leave your SQL Server running in an squirrely scenario? (Version 2)
  52. SharePoint Adventures : Setting up Reporting Services with SharePoint Integration
  53. AlwaysOn - HADRON Learning Series - Automatic Page Repair Increases SQL Server High Availability (HA) Capabilities
  54. Why can’t I open SQL Server Management Studio
  55. Resource Governor and MAXDOP, Parallel plan generation
  56. RML How Are Comparison Diffs Calculated
  57. Deploying CLR Assembly hangs with Visual Studio 2010
  58. SQL Server - New Drives Use 4K Sector Size
  59. Profiler Shows Negative (Strange) EventSequence Values
  60. SQL Denali - DReplay/XEProfiler or RML Utilities
  61. SQL Server 7.0: “She sure was a good ship”….
  62. Discussion About SQL Server I/O

2010 65

  1. Tracking database recovery progress using information from DMV
  2. How It Works: Error 18056 - The client was unable to reuse a session - Part 2
  3. AlwaysON - HADRON Learning Series - Running DBCC On A Secondary
  4. AlwaysON - HADRON Learning Series - New DMVs
  5. AlwaysON - HADRON Learning Series - What Is HADRON?
  6. HOW IT WORKS: IO Affinity Mask - Should I Use It?
  7. Microsoft Atlanta Begins….
  8. The week that was PASS…
  9. CSS once again comes to the SQL PASS Summit
  10. How It Works: SQL Parsing of Number(s), Numeric and Float Conversions
  11. Query Performance and multi-statement table valued functions
  12. How It Works: Extended Event (sqlos.wait_info*)
  13. Numbers are better than letters…
  14. Query performance and plan cache issues when parameter length not specified correctly
  15. Case of using filtered statistics
  16. Error 17953 - SidePageTable::Init() DeviceIoControl() : Operating system error 1(Incorrect function.) encountered.
  17. Slow query performance because inaccurate cardinality estimate when using anti-semi join following upgrade from SQL Server 2000
  18. Query performance and table variables
  19. Why use SQL Server 2008 R2 BPA? Case 1: Missing Updates…..
  20. How It Works: Timer Outputs in SQL Server 2008 R2 - Invariant TSC
  21. How It Works: Enumeration of sys.messages
  22. Replay Result Set Event (Replay * Events)
  23. When a full dump isn’t really a full dump…
  24. How It Works: Error 18056 - The client was unable to reuse a session with SPID ##, which had been reset for connection pooling
  25. SQL 2008 FileStream Fails to Enable After Setup on Cluster that uses Veritas Mountpoints
  26. Installing SQL Integration Services after SQL Cluster Setup has Completed
  27. Why does PREEMPTIVE_OS_GETPROCADDRESS Show a Large Accumulation?
  28. Sampling can produce less accurate statistics if the data is not evenly distributed
  29. Why is my SQL Clustered Instance changing authentication modes?
  30. Why doesn't SQL Server use statistics and index on this computed column?
  31. Revisiting an old SSRS performance topic again…
  32. My Kerberos Checklist…
  33. Known issues installing SQL 2008 R2 BPA relating to Remoting
  34. Introducing the SQL Server 2008 R2 Best Practices Analyzer (BPA)…
  35. Where did the SQL Server Instance disappear? The clue may be in the WMI logs!
  36. How It Works: SqlDataReader::RecordsAffected and Why it Returns -1
  37. SQLIOSim - Is Error: Unable to get disk cache info really an error?
  38. How It Works: Spinlock Of Type LPE_BATCH
  39. Don’t touch that schema!!!
  40. SQL Server 2008 R2 New Non-Yield Ring Buffer Information
  41. How It Works: The SQLAgent Log File
  42. Reporting Services, Scale Out and Clusters…
  43. Going dark next week…..
  44. RS Content Types and SharePoint 2010
  45. Follow-up to Questions from Europe PASS 2010….
  46. Error 18056 can be unwanted noise in certain scenarios
  47. Europe PASS, a volcano, Live Meeting, and SQL 2008 R2 BPA….
  48. AWE Allocated Values Reported Incorrectly (Large or Negative Value)
  49. How It Works: Orphan DTC Transaction (Session/SPID = -2)
  50. An important change for the Microsoft Lifecycle Support Policy….
  51. The case of the additional indexes
  52. How It Works: Soft NUMA, I/O Completion Thread, Lazy Writer Workers and Memory Nodes
  53. How to troubleshoot database corruption errors and System Center…
  54. Unable to load CLR assembly intermittently
  55. What SPN do I use and how does it get there?
  56. How It Works: SQL Server 2008 NUMA and Foreign Pages
  57. TCP Offloading again?!
  58. Did you start your SQL Server Engine correctly?
  59. Microsoft CSS once again a big part of SQL European PASS Summit…
  60. Mainstream vs Extended Support and SQL Server 2005 SP4: Can someone explain all of this?….
  61. How to have a Select All Multi-Value Cascading Parameter
  62. How to get a x64 version of Jet?
  63. High CPU after upgrading to SQL Server 2005 from 2000 due to batch sort
  64. Important SQL Server and Windows “End of Support” Dates you should know about….
  65. DBCC CHECK commands encounter problems and reports errors

2009 107

  1. ‘Cannot Generate SSPI Context’ and Service Account Passwords
  2. SQL 2008 - New Functionality to the dm_os_ring_buffers for Connectivity Troubleshooting
  3. DBMail has Suddenly Stopped Working
  4. InvalidReportParameterException with Data Driven Subscription
  5. High CPU with Reporting Services 2008
  6. Report Builder and Firewalls
  7. Timeout when deploying SQL CLR objects from Visual Studio 2005 or 2008 but not from Management Studio
  8. How It Works: SQLIOSim CTRL+C vs Close Window
  9. Doctor, this SQL Server appears to be sick….
  10. Unable to run SQL CLR procedure with System.Security.SecurityException
  11. SQL Server 2005 Cumulative Update or GDR fails when trying to rename the mssqlsystemresource files
  12. How It Works: Controlling SQL Server memory dumps
  13. How It Works: How many databases can be backed up simultaneously?
  14. The SQL Server Wait Type Repository…
  15. Reduce locking and other needs when updating data - Better Performance
  16. Should I have a SNAC with my cumulative update?
  17. Reporting Services and the MS09-062 GDR (GDI+)
  18. Microsoft CSS is back at PASS again…
  19. Reporting Services: What’s my version?
  20. Did your backup program/utility leave your SQL Server running in an squirrely scenario?
  21. If you use linked server queries, you need to read this….
  22. You may not see the data you expect in Extended Event Ring Buffer Targets….
  23. How It Works: What are the RING_BUFFER_RESOURCE_MONITOR telling me?
  24. The Future of SQL Server Express Installation and Voting with Microsoft Connect
  25. Another update for the Support Policy for Virtualization for SQL Server….
  26. Distributed Queries – Remote Login Permissions and Execution Plans
  27. Come on 64bit so we can leave the mem….
  28. SSMS Fails to restore with SQL 2000 instances and SSMS Versioning Explained….
  29. High CPU consumed by Resource Monitor due to low virtual memory
  30. SQL Server Cumulative Update or Service Pack Fails With - CREATE DATABASE failed
  31. Why doesn't SQL Server use index seek with this query?
  32. SQL Server Setup prompts with “The installed product does not match the installation source(s).” (Part I)
  33. PRB: RML Utilities – OStress QryBindColumnStorage: unknown/unhandled SQL datatype
  34. Using DateDiff can cause query performance problems in SQL 2005 and 2008
  35. How To Test Drive SQL Server Clustering For Free
  36. How far can you push Windows?….
  37. Attach of the Clone (… Databases)
  38. Q&A on Latches in the SQL Server Engine….
  39. When in doubt, Reboot!
  40. Installing .NET 3.5 Framework for SQL Server 2008 on a Windows 7 / Windows 2008 RC2 Builds
  41. Zero Byte Attachments in Email Subscriptions
  42. SQL Server on Windows 7 / Windows 2008 R2 with more than 64 CPUs
  43. SQL Server 2005 Setup Failure (Multi-Core, Tri-Core, …)
  44. SQL Server and Large Pages Explained….
  45. RDTSCTest CPU Speed Output Clarified
  46. Trying to keep up with Version Numbers….
  47. SQL Server TempDB – Number of Files – The Raw Truth
  48. SQL Server, Lock Manager, and “relaxed” FIFO….
  49. How It Works: SQL Server Timings and Timer Output (GetTickCount, timeGetTime, QueryPerformanceCounter, RDTSC, …)
  50. How It Works: SQL Server Engine Exception Handling
  51. How a log file structure can affect database recovery time
  52. An update for Standard SKU Support for Locked Pages….
  53. SQL Server Support Policy for Failover Clustering and Virtualization gets an update…
  54. Upgrading Windows with RS 2005
  55. How It Works: DBCC MemoryStatus Locked Pages Allocated and SinglePageAllocator Values
  56. SQL Server reports working set trim warning message during early startup phase
  57. How Do I Determine Which Dump Triggers Are Enabled
  58. SSIS 2005 and the .NET Garbage Collector
  59. How to use FileStream feature in an ASP.NET Web Application that uses Forms or Anonymous authentication
  60. SQL, Powershell, Windows, Oh My!
  61. Why Should I Use Extended Events in SQL Server 2008?…
  62. SQL Server, Locked Pages, and Standard SKU…
  63. SQL Server and the Bad CPU
  64. Speaking at European PASS 2009….
  65. SQL Server 2008 SP1 and Cumulative Updates Explained.....
  66. The 3 Things you Need to Know to Install SQL 2005 on Windows 2008 Cluster
  67. Troubleshooting sp_xp_cmdshell_proxy_account Errors
  68. Updated Errors may occur after configuring Analysis Services to use Kerberos authentication on Advanced Encryption Standard Aware Operating Systems
  69. SQL 2005: SQL Server Configuration Manager Error: Connection to target machine could not be made in a timely fasion.
  70. SQLDumper unable to generate mdmp files in SQL Server 2008 Failover clusters
  71. Parallel Index Creation performance issue
  72. SQL Server: What is a COLD, DIRTY or CLEAN Buffer?
  73. How It Works: What Are The Event Source Names Used By SQL Server
  74. How to fix your SQL Server 2008 Setup before you run setup (Part II)....
  75. SQL Server 2008 Ring Buffer Entries
  76. How to use computed columns to improve query performance
  77. SocketException when creating a new Report Server Database
  78. Sparse File Errors: 1450 or 665 due to file fragmentation: Fixes and Workarounds
  79. How It Works: SQL Server - VDI (VSS) Backup Resources
  80. Troubleshooting: SQL Server (2005, 2008) Performance Counter Collection Problems
  81. How It Works: Almost Everything You Wanted To Know About The SQL Server (2005, 2008) Performance Counter Collection Components
  82. You encounter error message "The system cannot find the file specified" when attempting to perform backups using sqlvdi
  83. SQL Server 2005 and 2008 Setup Failures (Compressed DATA Directory)
  84. How It Works: Resource Governor 'INTERNAL' Group
  85. SQL Server 2005 or 2008 Reporting Error 17883 - Stalled Scheduler Warnings
  86. SQL Server: Is CHECKDB A Necessity?
  87. How to copy DTS 2000 packages between servers (and from SQL 2000 to SQL 2005 and SQL 2008)
  88. Searching for Duplicate SPN's got a little easier
  89. How It Works: File Stream Compression with Backup/Restore
  90. PRB: RML Utilities - ReadTrace processing fails with "Attempt to use an invalid variant type"
  91. RML Utilities: Recommended SQL Server 2008 updates for ReadTrace processing
  92. How to troubleshoot leaked SqlConnection Objects (.NET 2.0) - Part 2
  93. SQLIOSim: Default Testing Pattern
  94. Why aren't my subscriptions working?
  95. PRB: RML Utilities - Reporter errors during report rendering
  96. Hot It Works: SQL Server SuperLatch'ing / Sub-latches
  97. INF: Multi-Machine Replay Using ORCA and OSTRESS
  98. How It Works: Statistics Sampling for BLOB data
  99. PRB: RML Utilities - ReadTrace and how to workaround MARS
  100. WMI Provider Error Access is denied - while changing SQL Server account password
  101. How It Works: sys.dm_os_buffer_descriptors
  102. How It Works: SQL Server Sparse Files (DBCC and Snapshot Databases) Revisited
  103. "Error: SharePoint is installed but not configured" when installing the RS Add-in on Windows 2008
  104. ReadTrace Generates Unexpected Connect Node - Not Really
  105. Filtering Trace Data Without Loading In Profiler or Database Table
  106. Installing SQL Server 2005 SP3 or SQL Server 2008 on builds prior to XP SP3 Can lead to Bug Check (0xF4, Blue screen, Critical Process Termination)
  107. WMI Provider Error: Access is denied. [0x80070005] from SQL Server Computer Manager

2008 87

  1. SQL 2005 JDBC Driver and Database Mirroring
  2. Failure to load Report Manager due to truncated UserAgent string
  3. Using SQLIOSim to Diagnose SQL Server Reported Checksum (Error 824/823) Failures
  4. SQL Server (2005 and 2008) Trace Flag 1118 (-T1118) Usage
  5. How It Works: SQL Server No Longer Uses RDTSC For Timings in SQL 2008 and SQL 2005 Service Pack 3 (SP3)
  6. How It Works: SQL Trace and MARS Connections
  7. INF: RML Utilities: Turning on Trace Flags
  8. How It Works: What is behind the SQLCLR wait category in SQL Server 2008 Activity Monitor
  9. Should I run SQLIOSim? - An e-mail follow-up from SQL PASS 2008
  10. RSWindowsNegotiate and 401.1 Error when using RS 2008
  11. PRB: RML Utilities - ReadTrace -M or -MF parameters cause processing to fail with SQL 2008 trace files
  12. INF: RML Utilities - You cannot use 9.01 Reporter against performance analysis database loaded by down-level ReadTrace
  13. Microsoft CSS at the PASS Summit 2008
  14. PRB: RML Utilities - Setup may Always Prompt for Report Viewer 2008 Redistributable
  15. How It Works: SQLIOSim - Running Average, Target Duration, Discarded Buffers ...
  16. Cumulative Update 1 to the RML Utilities for Microsoft SQL Server Released
  17. RML Utilities: ReadTrace may encounter assertion building the partial aggregates
  18. SQL Server Support in a Hardware Virtualization Environment
  19. RML Utilities: ReportViewer Bug Affects SQL Server Management Studio and Reporter Utility
  20. TCP Chimney Offload – Possible Performance and Concurrency Impacts to SQL Server Workloads
  21. How to fix your SQL Server 2008 Setup before you run setup...
  22. Welcome to SQL Server 2008 Patching
  23. Reporting Services Windows Service will not start after applying MS08-052
  24. How it Works: SQL Command Mode Parsing
  25. SQL Server (2000, 2005, 2008): Recovery/Rollback Taking Longer Than Expected
  26. Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account
  27. SQL Server 2005 Setup Fails in WOW (x86) On Computer With More Than 32 CPUs
  28. How It Works: 17888 - All Schedulers on Node Appear Deadlocked
  29. SQL Server 2008 Management Tools Basic vs Complete Explained....
  30. How to Rebuild System Databases in SQL Server 2008
  31. How It Works: Creating An EndPoint Adds An Entry To SysLogins
  32. SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1 explained...
  33. Using Locking Like Synchronization Object
  34. Why you should read the Release Notes for SQL Server 2008
  35. IsNumeric Returns (1/TRUE) and I Expected (0/FALSE)
  36. How It Works: SQLIOSim [Audit Users] and .INI Control File Sections with User Count Options
  37. Timeouts when connecting to Named Instances
  38. Is it really the released version of SQL Server 2008?
  39. SQL Server 2008, Visual Studio 2008 SP1, and .Net Framework 3.5 SP1 explained....
  40. How It Works: Attention, Attention or Should I say Cancel the Query and Be Sure to Process Your Results
  41. SQL Server 2005 Encounters Exception During Install When System has Odd Number of Processors or Logical Processors Per Core
  42. Supporting SQL Server 2008: The system_health session
  43. SQL Server I/O Bottleneck, I don't have one, YES YOU DO!
  44. SQL Server, Windows Server 2008, and the Windows Firewall
  45. Get Ready for SQL Server 2008
  46. How It Works: Trace (.TRC) File Security
  47. How It Works: More on DBCC Shrink* Activities
  48. Helpful Hint: Making Review of a Query Plan Easier
  49. Query Performance issues associated with a large sized security cache
  50. How It Works: SQL Server 2005 - Possible data recovery when checksum failure reported
  51. SQL Server 2005 SP3 and Self-Service Hotfixes
  52. How It Works: What is a Sleeping / Awaiting Command Session
  53. Changes introduced in CU#7 may impact Analysis Services backup and sync operations
  54. How It Works: SQL Server Checkpoint (FlushCache) Outstanding I/O Target
  55. Troubleshooting xp_cmdshell failures
  56. How It Works: File Streams Requires Integrated Security (Windows Authentication)
  57. European PASS Conference 2008
  58. How It Works: SQL Server Page Allocations
  59. Microsoft to Increase Use of SQL Server 2005 Best Practices Analyzer (SQLPBA) - So Should You
  60. SQL Server 2005 Memory Limits and Related Questions
  61. SQLIOSim is "NOT" an I/O Performance Tuning Tool
  62. How It Works: Non-Yielding Resource Monitor
  63. How It Works: SQL Server 2005 DBCC Shrink* May Take Longer Than SQL Server 2000
  64. How It Works: SQL Server 2008 Backup Compression, Database Compression and Total Data Encryption
  65. How It Works: SQL Server 2005 SP2 Security Ring Buffer - RING_BUFFER_SECURITY_ERROR
  66. How It Works: DBCC ShrinkDatabase / ShrinkFile (Tabular)
  67. How It Works: Shapshot Database (Replica) Dirty Page Copy Behavior (NewPage)
  68. How It Works: SQL Server 2005 I/O Affinity and NUMA Don't Always Mix
  69. How It Works: SQLIOSim - Checksums
  70. SQL Server Working Set Trim Problems? - Consider...
  71. How It Works: Debugging SQL Server Stalled or Stuck I/O Problems - Root Cause
  72. How It Works: Linked Servers and Collation Compatibility
  73. How it Works: SQL Server Per Query Degree Of Parallelism Worker Count(s)
  74. How It Works: SQL Server 2005 Connection and Task Assignments
  75. How It Works: SQL Server 2005 Database Snapshots (Replica)
  76. How It Works: How does SQL Server Backup and Restore select transfer sizes
  77. High waits on CLR_MANUAL_EVENT and CLR_AUTO_EVENT
  78. How It Works: SQL Server Backup Buffer Exchange (a VDI Focus)
  79. How It Works: SQL Server 2005 NUMA Basics
  80. How It Works: Conversion of a Varchar, RPC Parameter to Text from a Trace (.TRC) Capture
  81. How It Works: What is Restore/Backup Doing?
  82. How It Works: File Stream the Before and After Image of a File
  83. SQLIOSim - Error Request Could Not Be Performed - Unable to get disk cache info
  84. RML Utilities Install Fails with MSI (Windows Installer) Error #2755
  85. How It Works: SQL Server Engine Error Messages
  86. How It Works: System Sessions
  87. SQL Server 2008 - Resource Governor Questions

2007 23

  1. RML Utilities for Microsoft SQL Server Released
  2. RML (READTRACE/OSTRESS) Utilities for SQL Server 2005
  3. Do I have to assign the Lock Pages in Memory privilege for Local System?
  4. Database compatibility and new features
  5. Follow-up to PASS 2007 Summit
  6. Microsoft PSS is back for the PASS 2007 Summit!
  7. SQL Server 2000 with high LOCK_HASH spinlock contention
  8. SQL Server 2005 - RDTSC Truths and Myths Discussed
  9. NUMA Connection Affinity and Parallel Queries
  10. How to configure Database mirroring for use with ODBC applications?
  11. The SQL Server Working Set Message
  12. SQLIOSim - Outstanding I/O Warnings
  13. SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained
  14. SQL Server 2005 Performance Dashboard Reports
  15. SQL Server 2005 SP2 – Trace Event Change – Connection Based Events
  16. PSS Service Center Labs for PASS 2006
  17. SQL Server 2005 Performance Statistics Script
  18. SQL Server 2005 Service Pack 2 has released! Linked Server GUI is back!
  19. Daylight Savings Time (DST) Changes for 2007 and their impact on SQL Server
  20. SQL Server Urban Legends Discussed
  21. The Importance of the Trace Event Sequence Column and SQL Server 2005 SP2 Changes
  22. SQL 2005 Setup Failures
  23. SQLServerCentral Interview with Bob Dorr from Microsoft PSS

2006 13

  1. Sample chapter
  2. How to get the new book
  3. A New Book on SQL Server 2005 Troubleshooting
  4. Follow-up to PASS 2006
  5. SQL Server becomes sluggish or appears to stall on 64 bit installations
  6. What happened to SQLIOStress?
  7. What do I need to know about SQL Server database engine I/O?
  8. Have you heard about the SQL Server Always-On Solution Reviewed Program?
  9. SQL Server 2005 SP2 will introduce new messages to the error log related to timing activities.
  10. The PSS Service Center at PASS 2006
  11. PSS Presentations at PASS 2006
  12. Microsoft PSS SQL is coming to PASS 2006
  13. Welcome to the Microsoft PSS SQL Team Blog