page contents
Tag Archives: SQL Agent

SQL Server Compatibility Levels

Have you ever wondered what versions of SQL Server related to the compatibility levels? This article will show you the levels and also how to change existing databases to different SQL releases. This is a list of all SQL Server Compatibility Levels: Product Database Engine Version Compatibility Level Designation Supported Compatibility Level Values SQL Server […]

Leave a comment Continue Reading →

SQL Saturday #493 (Silicon Valley)

I have been really lucky the past two weeks as I was able to attend two separate SQL Saturday events back to back. For me, it is a day where I can both learn and talk with others about my passion with Microsoft SQL Server. The latest SQL Saturday #493 in Mountain View, CA (Silicon […]

2 Comments Continue Reading →

SQL Saturday #511 (Redmond)

One of the things I really look forward to recently is SQL Saturday as it is a day where I can both learn and talk with others about my passion with Microsoft SQL Server. The latest SQL Saturday #511 in Redmond on 2 April 2016 was no exception to this wonderful community of SQL server […]

Leave a comment Continue Reading →

How to: Move SQL Databases (System)

This is the second article about moving system databases and I just got motivated writing it after reading Erik Darling‘s article Moving Databases with ALTER DATABASE. I wrote my rough draft in an earlier article (that I ended up putting up on my site) on how to move system databases in SQL Server 2008R2. In […]

2 Comments Continue Reading →

How to: Move SQL Databases (User)

This is an article that I have been meaning to write for a while and I just got motivated writing it after reading Erik Darling‘s article Moving Databases with ALTER DATABASE. I wrote my rough draft in an earlier article (that I ended up putting up on my site) on how to move system databases […]

Comments Off on How to: Move SQL Databases (User) Continue Reading →

Moving the System Databases in SQL Server 2008R2

One of the more common tasks you will encounter in moving a system or user database from one physical location to another location. For example, Microsoft recommends that we place our backups, data files, transaction logs and tempdb files on four separate drives. However, the installer by default will place the system databases (Master, Model […]

2 Comments Continue Reading →

HOW TO: Use the Database Engine Tuning Advisor in Microsoft SQL Server

Before we begin, I want to provide a little background on this tool. Database Engine Tuning Advisor (DTA) is a component of SQL Server Management Studio, which is an integral part of Microsoft SQL Server, the database management application. This tool is used for improving query performances by examining the way queries are processed and […]

Comments Off on HOW TO: Use the Database Engine Tuning Advisor in Microsoft SQL Server Continue Reading →

SQL Server Maintenance Solution by Ola Hallengren

I have been meaning to talk about this topic for a while now and tonight I made sure that I put out the good news. Today, I want to introduce you to the SQL Server Maintenance Solution by Ola Hallengren which is a script that will create a series of scripts that will perform SQL agent jobs […]

1 Comment Continue Reading →

BEST PRACTICE: SQL Server 2005 to present: Instant Initialization for database files

This is a well-known and often mentioned best practice that I have recently found out that is not implemented much. I was even surprised to see that most installer packages to even include Microsoft’s SQL Server install do not set this feature up. Instant Initialization has been around since Windows XP and SQL Server has taken advantage of […]

Comments Off on BEST PRACTICE: SQL Server 2005 to present: Instant Initialization for database files Continue Reading →

SQL Job Agent fails when Windows name change

Have you ever had a server that had a name change, but you also had a SQL server database on it and now all of your SQL jobs fail? Let’s say that your server used to be named IP-0A7653F2 and had SQL Server installed with some SQL jobs configured on it, but now it is called […]

Comments Off on SQL Job Agent fails when Windows name change Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.