Available Now: Microsoft SQL Server 2012 Service Pack 4

Service Pack - @SeniorDBA

Microsoft’s SQL Server development team has delivered the final service pack release for SQL Server 2012. This latest service pack is now available for download on the Microsoft Download Center and will be available to Visual Studio Subscriptions, MBS/Partner Source, and VLSC. SQL Server 2012 Service Pack 4 (SP4) contains a roll-up of released hotfixes as well as more than twenty improvements centered around performance, scalability, and diagnostics based on the feedback from their customers and the SQL community.

SQL Server 2012 Service Pack 4 includes:

  • All fixes and Cumulative Updates (CUs) for SQL Server 2012 up to and including SQL Server 2012 SP3 CU10.
  • Scalability and performance improvements for SQL Server.
  • Additional monitoring capabilities through enhancements in DMV, Extended Events and Query Plans and the ability to clone the database including statistics with DBCC CLONEDATABASE.
  • New improvements based on Connect feedback items filed by the SQL Server Community.
  • Some of the improvements originally introduced in SQL Server 2014 SP2 and SQL Server 2016 SP1.

Continue reading “Available Now: Microsoft SQL Server 2012 Service Pack 4”

Advertisements

Free Download: SQL Server Management Studio 17.3

SQL Server

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server.

Microsoft has announced the latest release of SQL Server Management Studio (SSMS) in October. This release features improved compatibility with previous versions of SQL Server and a stand-alone web installer.

Get it here:

Continue reading “Free Download: SQL Server Management Studio 17.3”

Detailed SQL Server Version Information

SQL Server - SeniorDBA

Microsoft’s SQL Server database engine has gone through various versions over the many years it has been one of the most popular solutions for database design. Some of the versions also support databases created under the older versions of the engine. This table helps you understand what support is available from those various SQL Server versions.

Continue reading “Detailed SQL Server Version Information”

Rebuild and Restore Master Database in SQL Server

database - @SeniorDBA

The Master database is important to your SQL Server instance. This database records all the system-level information for your SQL Server system. This includes instance-wide metadata like logon accounts, endpoints, linked servers, system configuration settings, and records for the existence of all other databases and their file locations.

SQL Server cannot start if the Master database is unavailable. The core information of master database is recorded in a physical file called master.MDF files, and the transaction logs are stored on to the masterlog.LDF file. This means the all user and login details for the instance and the information about all the other databases on that instance are stored on the master database.

If anything happens to the master database you can’t start or use your SQL Server instance. As a Database or System Administrator, it is essential that you to know the symptoms that may indicate the corruption or damage in your Master database so you can troubleshoot those types of issues correctly.

Continue reading “Rebuild and Restore Master Database in SQL Server”

SQL Server 2016 Version Differences

SQL Server 2016 - @SeniorDBA

There are often questions about what features are available in the different versions of SQL Server 2016 SP1. Continue reading “SQL Server 2016 Version Differences”

How to Create a SQL Server Logon Trigger

Login - @SeniorDBA

You may want to log the event each time a user logs into your database. This can be easily done by starting SQL Server Managements Studio (SSMS) and running the following code in Transact-SQL: Continue reading “How to Create a SQL Server Logon Trigger”

SQL Server 2017 – Windows, Linux, and Docker

SQL Server 2017 - @SeniorDBA

SQL Server 2017 is available as a Release Candidate (RC2, August 2017) and Community Technical Preview (CTP) , which represents a step towards making SQL Server a platform that gives you more choices when it comes to development languages, data types, and operating systems by making it available the to Linux users, as a Linux-based Docker containers, and traditional Windows users.

New features as described by Microsoft: Continue reading “SQL Server 2017 – Windows, Linux, and Docker”