Option 1 – Using Windows built-in Administrator Account If you have installed the SQL Server with the Windows Administrator in a sysadmin role, you can log in to the server then into the SSMS with that account. After you log in, in the Object Explorer go to Security > Logins > Double Click on SA … Continue reading Lost SA Password? Don’t worry! Use these 2 methods to reset your SA Password!
In the first part of this article, which you can find here, I discussed some of the most common SQL Configuration options available through sp_configure. There are plenty of options that you can play with, but in this second article, I’ll talk about a few more important settings that didn’t fit in the last post. Some … Continue reading SQL Server Configuration – Part 2
If you’ve ever went through the process of installing SQL Server, you’ll know that it’s very simple. Provide an admin password, pick your directories and viola, server is installed. The downside of this simplistic setup is that many configuration options are at their default values. 99 times out of a 100, this will not be … Continue reading SQL Server Configuration, sp_configure And Options You Need To Know – Part 1
Introduction One of the many new features of SQL Server 2016 is called a Stretch Database, sometimes referred to by the technical term Remote Data Archiving (RDA). In a nutshell, this feature allows you to copy data to the Microsoft Azure Cloud. It can be useful for data archiving by reducing the amount of data … Continue reading Stretch Database – Remote Data Archiving
The basic form of storage is a single physical disk, be it a hard disk drive, or more recently, a solid state drive. One single unit can provide storage for the Operating System, Applications, SQL Server, etc. While you can certainly run SQL Server on a single physical disk and you may find it cost … Continue reading RAID Array Levels and SQL Server
The processor(s) in your server have been advertised to run at a certain frequency, for example 3.0GHz. This article will help you identify if your processor is indeed running at the advertised speed, and if it’s not, what you can do about it. First, in order to be able to obtain real time information about … Continue reading Processor Power Settings – How to ensure your SQL Server is running optimally.
Hi folks! My name is Vedran Ikonic. I'm a Database Administrator currently working at TMW Systems, based out of Mayfield Heights, OH. If you want to know more about me, head over to the About page where I indulge a little more about myself. I've crossed paths with TMW Systems about a year ago when … Continue reading The Pilot