Follow this quick procedure in order to upgrade from SQL Server 2008. Note that the same process applies when upgrading to later versions of the product, such as 2014, 2016, etc. Microsoft’s SQL ...

Data developers are still learning about all the new goodies that arrived with SQL Server 2022, which is chock full of new features and enhancements such as ledger for blockchain security. Microsoft ...

When you try to connect SQL Server 2008 instances with a one way mirroring set up, connection attempts fail with a KeyNotFoundException. This can be worked around by adding "Failover Partner=" string ...

I've been trying to install SQL Server 2017 Developer Edition inside a Docker container based on windowsservercore:1903, but I get install errors on the initial piece, which is installing the SQL 2008 ...

Microsoft issued some reminders this week that July 9, 2019, is the last day of patch support for SQL Server 2008 and SQL Server 2008 R2. The servers will no longer get security patches after that ...

With Extended Support for SQL Server 2008 and SQL Server 2008 R2 ending in July 2019, to be followed six months later by the end of Extended Support for Windows Server 2008 and 2008 R2 in January 2020 ...

Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem ...

A reader has prompted Microsoft to launch a vast new resource for easing the SQL Server set-up process. Okay, just maybe it's a coincidence. Anyway, reader Brian M.'s complaint about the difficulties ...

SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

Ok, by now my first upgrade experience with Katmai is well-documented. So I thought I’d pass along some of my other experiences and some of the things I’ve learned. My Vista upgrade: I have a copy of ...