Steps to install a stand-alone SQL Server 2017 instance
In this tip we go over the basic steps to setup a new SQL Server 2017 stand-alone instance.
Percy Reyes has a Bach. Systems Engineering and Certified Senior Database Administrator focused on Microsoft SQL Server Internals with over 15+ years of extensive experience managing database servers on SQL Server 6.5, 7.0, 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, and 2017. He has in-depth knowledge and strong experience in database administration of SQL Server including installation and upgrading the database server and client tools, allocation system storage and planning future storage requirements for the database system, Backup/Restore operations, Indexing, Statistics, Integrity Checks, Database Maintenance, Database Reduction, Storage Engine, Replication, Monitoring, Optimization and Performance Tuning, In-Memory OLTP, Security and Compliance, Scalability, High Availability, Mirroring, Log Shipping, AlwaysOn, Failover Clustering, FileStream, Partitioning Very Large Tables, Disaster Recovery, Troubleshooting, and internals issues. Percy is always contributing to the SQL Community via twitter (@percyreyes) and writing in his blog and also as a frequent speaker about SQL Server technologies for over 10+ years at local user group meetings, webcasts, and national conferences. He can be reached at https://www.percyreyes.com.
- MSSQLTips Awards: Rookie of the Year Contender - 2014
Get Logical Hard Drive details with T-SQL and OLE Automation
One of the most important SQL Server DBA tasks is checking the logical hard drive details such as the total capacity, free disk space, and used space by data and log files of SQL Server databases. In this tip we look at a method to view this information i
SQL Server Index Report with Included Columns, Storage and more for all Tables in a Database
I am sure sometimes as SQL Server DBAs and Developers we would like to report on more detailed information about indexes on a table. One of the primary means to find the information is sp_helpindex which is a system stored procedure to check index summar
Using the SQL Server Default Trace to Audit Events
Many times we need to find important events that occurred on the database server, but we may not always have a process in place to capture this data. In this tip we look at some quick methods to view events that occurred in SQL Server like Shrink, AutoGr
Script Constraints, Primary and Foreign Keys for SQL Server Database
As SQL Server DBAs we may need to generate a script for the creation of all Primary Keys, Unique and Foreign Key constraints. We know with the SQL Server native tools that there is not a way to meet this need all at the same time. In this tip we look at t
Script out all SQL Server Indexes in a Database using T-SQL
Sometimes as a DBA we need to generate a T-SQL script for dropping and creating indexes in our SQL Server databases. However, SQL Server Management Studio does not have an easy way via the wizard to complete these tasks all at the same time. In this tip,
Script to Drop All Orphaned SQL Server Database Users
One important task as DBA is to manage security in our database server environments. Part of this is to administer the permissions for each user in each database. Sometimes there are orphaned Users (no login exists for the user) in a database and we may w
Microsoft SQL Server 2014 In-Memory OLTP: How fast is it?
In-Memory OLTP is a new feature of Microsoft SQL Server 2014 that was born in response to business and hardware trends. But how fast is it? How we can use it to optimize OLTP transactions? Why it is faster than transactions on disk based tables?
How to use DBCC CHECKPRIMARYFILE to attach several SQL Server databases in seconds
Have you ever had to attach databases on a SQL Server? This could be done using the SSMS GUI which is great if it is a one time thing, but if you have many databases this could take time. The other option is to write T-SQL code to do the attach, but thi
Error 601: Could not continue scan with NOLOCK due to SQL Server data
When we are querying SQL Server tables with/without the NOLOCK hint we may get a page corruption error like this: Could not continue scan with NOLOCK due to data movement. Today we will learn how to deal with this issue.
Specified LSN for repldone log scan occurs before current start error
When working with SQL Server replication there are times when you may get critical errors related to the Log Reader Agent. One of these errors is The specified LSN [xxx] for repldone log scan occurs before the current start of replication in the log [xxx
SQL Server Replication could not find stored procedure error 2812
One of the most important aspects in a SQL Server database server environment is security. This includes ensuring no object is dropped or modified as an error or intentionally without proper authorization. Many developers ignore, for example, the sp_MS%