Sqlserver-dba.com - SQL Server support and SQL Server Performance Tuning
    SQL Server DBA:Everything | DBA Scripts | Powershell Scripts | DBA checklists | SQL Antipattern | Wait Stats

Follow sqlserver-dba.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

For any SQL Server issue send email to: jack@sqlserver-dba.com

Daily & Exclusive Content

SQLServer-DBA.com Links

Dba_db2_button

dba-ninja.com

Recent Posts

SQL Server DBA Jobs


November 29, 2021 How to detect if the guest account is disabled

November 25, 2021 How to get last logon of user on Domain Controllers using Powershell

November 23, 2021 How to INSERT INTO EXEC with extra column

November 19, 2021 Microsoft Ignite Book of News

November 18, 2021 Run SSMS as a different user

November 16, 2021 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database

November 10, 2021 My Top 4 sessions at PASS Data Community Summit 2021

November 09, 2021 How to get the SQL View definition

November 02, 2021 How to copy Powershell data to Clipboard

October 20, 2021 SQL Server 2019 upgrade considerations

October 07, 2021 How to use Database Compatibility to increase your migration success

October 04, 2021 How to start SSMS as a different Windows login

September 23, 2021 How to capture SQL login details with Extended Events

September 15, 2021 How to add members to the Administrators group with Powershell

September 07, 2021 How to view the current Powershell session security permissions

August 31, 2021 How to get Active Directory Group Scope - Local Domain, Global Group, Universal Group with Powershell

August 26, 2021 How to resolve a hostname or ip address with Powershell

August 03, 2021 How can I execute t-sql with a Proxy account

July 29, 2021 AWS-RDS SQL Server limitations

July 26, 2021 Array-based replication versus vSphere Replication

July 14, 2021 How to fix Invalid comparison due to NO COLLATION

July 12, 2021 How to fix BACKUP LOG cannot be performed because there is no current database backup

July 02, 2021 How to recover SSMS auto recover scripts after crash

July 01, 2021 How to capture SQL Server database RESTORE details with Extended Events

June 22, 2021 Installing Ola Hallengren SQL Server Maintenance Solution on AWS RDS

June 21, 2021 Get free disk space for mount points using Powershell

June 14, 2021 How to check SSAS service status with Powershell

June 08, 2021 How to check SSRS service status with Powershell

June 04, 2021 How to get count of GROUP BY columns

June 02, 2021 How to fix operating system error code 80(The file exists.) in SQL Agent Job during BULK LOAD

June 01, 2021 How to check a SQL Server connection is encrypted with SSL

May 28, 2021 5 minutes in a DBA's head - Separating the Application and Database server

May 27, 2021 How to find a module for a powershell cmdlet with Get-Command

May 27, 2021 Banner ads for sqlserver-dba.com

May 24, 2021 How to fix Column in table is invalid for creating a default constraint

May 21, 2021 How to use SORT_IN_TEMPDB to increase your index rebuild performance

May 19, 2021 How to use your DNA knowledge to increase your DBA skills

May 14, 2021 How to fix the SSMS LoaderPackage package did not load correctly

May 11, 2021 How to register an SPN for SQL Server

May 10, 2021 How to get disk capacity from remote server using Powershell Get-PSDrive

April 30, 2021 How does the Service Principal Name process work

April 22, 2021 How to identify the the current user on Powershell

April 20, 2021 How to configure SQL Server static port with Powershell

April 19, 2021 How to capture deadlocks using system_health Extended Events

April 12, 2021 Find Recycle Bin location and clear down with Powershell

March 30, 2021 How to secure Powershell

March 29, 2021 How to get database role securables

March 26, 2021 How to parse sys.fn_xe_file_target_read_file faster

March 25, 2021 Quick access to Failover Clustering cheatsheet

March 23, 2021 SQL Server Performance Tuning

March 22, 2021 How to get the Always On Availability Group DNS name per database

March 19, 2021 How to restore Always On Availability Group databases

March 18, 2021 How to view SQL Server logging on Linux

March 14, 2021 What does LSN mean in SQL Server?

March 13, 2021 How To Check SQL Windows Services Stopped Time And Who Stopped with powerhsell

March 11, 2021 Microsoft adutil - FAQ

March 10, 2021 How to force failover on Clusterless Availability Groups with FORCE_FAILOVER_ALLOW_DATA_LOSS

March 09, 2021 How to view Service Principal Names in Active Directory

March 01, 2021 How to extract Active Directory users with Get-ADGroup and Get-ADGroupMember

February 24, 2021 How to fix Database might contain bulk logged changes that have not been backed up for Always On

February 16, 2021 Does SQL Server require a restart after memory change

February 11, 2021 How to debug Kerberos and LDAP for SQL Server

February 04, 2021 Understanding SQL Server Orphaned Users

January 29, 2021 How to identify sql server version for target Podman or Docker Container Imager

January 27, 2021 Find SQL database Orphaned Users SQL script

January 22, 2021 How to get all Domain Controllers in Active Directory Forest with Powershell

January 12, 2021 Quick access to SQL Server Always On Availability cheatsheet

January 04, 2021 List the differences between Kerberos and NTLM

December 31, 2020 How to find Active Directory users with Get-ADUser search filter

December 23, 2020 How to use STRING_AGG to concatenate strings with grouping

December 09, 2020 How to bcp export file with encoding ascii

November 18, 2020 How to fix Msg 7390 - The requested operation could be performed

November 17, 2020 How to find physical path for SQL Server backup on Container

November 09, 2020 How to fix Msg 7347 - linked server returned data that does not match expected data length for column

November 02, 2020 How to check SQL Server Filegroup file sizes

October 08, 2020 How to check if SQL Server Agent is running using t-sql

August 23, 2020 How to check if Puppet is reboots a windows server with Powershell

July 28, 2020 How To Use Transparent Data Encryption To Increase Your Security

July 09, 2020 Quick Fix: How to display hours minutes seconds between two dates

July 06, 2020 Use Get-ADPrincipalGroupMembership with other Active Directory domains

July 03, 2020 On-Demand Instant File Initialization status with sys.dm_server_services

June 30, 2020 Error Message:The UPDATE statement conflicted with the REFERENCE constraint

June 29, 2020 How to master Mount-Diskimage in Powershell

June 29, 2020 Error Message: The RPC server is unavailable during SQL Setup

June 09, 2020 How to find list of AD groups of a user from SQL Server

May 29, 2020 Error Message : String or binary data would be truncated

May 13, 2020 How to search SQL Server Agent Command Text for a string

April 29, 2020 How to measure Transparent Data Encryption (TDE) Performance

March 30, 2020 How to find Active Directory groups with Get-ADGroup search filter

March 27, 2020 How To Automate SQL Server Vulnerability Assessment

March 25, 2020 How to create a PSCredential object

March 23, 2020 Error Message: The EXECUTE permission was denied on the object ‘xp_prop_oledb_provider’, database ‘mssqlsystemresource’

March 02, 2020 How to capture query errors using SQL Server Extended Events

February 25, 2020 SQL Server Docker and Container Cheat Sheet

February 17, 2020 Quick Fix: DELETE statement conflicted with the REFERENCE constraint

February 03, 2020 How to successfully separate email in Powershell

January 28, 2020 How to add SSMS to the PATH variable with Powershell

January 23, 2020 How to migrate wide Excel worksheet into SQL Server table

January 22, 2020 How to get ODBC drivers using Powershell

January 17, 2020 How to fix the two most common causes of SQL Server BACKUP LOG Failures

January 14, 2020 The mysterious case of Pseudo SIMPLE RECOVERY model and the transaction log explosive growth

January 13, 2020 How to trace SQL Server Backup

January 08, 2020 A great way to Link SQL Server and MongoDB with BI Connector

December 31, 2019 How to list computer shares with Powershell and WMI

December 19, 2019 How to use Database Tuning Advisor via command line

December 11, 2019 How to fix Exception caused by space in text for Powershell form

December 04, 2019 How to stop Dialogresult closing your Powershell GUI application

April 25, 2018 How to script CREDENTIALS for SQL Server migration

April 13, 2018 Global platforms and local developer community differences

April 12, 2018 Should I use SQL Change Data Capture for data audit ?

April 09, 2018 Alter database compatibility on all databases in a SQL Server Instance

April 06, 2018 Attempted to read or write protected memory.This is often an indication that other memory is corrupt

March 20, 2018 UPDATE STATISTICS GETTING SLOWER

March 06, 2018 Msg 16955 – Could not create an acceptable cursor

February 16, 2018 SQL Server , Meltdown and Spectre FAQ

February 08, 2018 How to calculate last time Wait Statistics were cleared

January 20, 2018 Wait Stats

January 01, 2018 How to get DOMAIN login name with Powershell Get-ADGroupMember

December 30, 2017 Top 10 most popular SQL Server articles for 2017

December 14, 2017 Powershell input parameter via command line

December 08, 2017 SQL Server Agent Job History Log Not showing any rows

December 05, 2017 Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.

November 27, 2017 Type Conversion may affect cardinality estimate in query plan

November 24, 2017 How to list CLR objects inside a SQL Server database

November 14, 2017 Automatic Index Tuning by default on Azure sql server

October 26, 2017 Cumulative Update 5 for SQL Server 2016 SP1

October 20, 2017 Separating the Application and Database server

October 18, 2017 How to disable a database user

October 14, 2017 SSRS migration and renaming the ReeportServer database

October 12, 2017 How to change SQL Server 2016 Database default locations for data and log files

October 02, 2017 Troubleshooting SQL CLR memory pressure

October 01, 2017 Advertising options on sqlserver-dba.com

September 21, 2017 12 factor app and database services

September 13, 2017 How to add a user-defined SQL Server error message and send message to the Windows event log

September 07, 2017 How to find SQL Server Instance Default Path and Instance Default Log Path

September 06, 2017 MS SQL 2016 Management Studio Silent Install

August 24, 2017 Top 30 SQL Blogs & Websites for Microsoft SQL Server Administrators

August 16, 2017 Disaster Recovery Powershell Script to check for failed Windows services

August 09, 2017 How to list Extended stored procedure for public

July 27, 2017 How to add a row in Powershell System.Data.Datatable

July 18, 2017 Service Exit Code 1077 and false negatives

July 14, 2017 Largest FREE Microsoft eBook Giveaway

July 04, 2017 Post disaster recovery SQL Server database checkout script

June 30, 2017 Chinese build the most powerful computer in the world

June 29, 2017 SQL Server and Petya

June 26, 2017 The Reporting Server Instance could not be found

June 22, 2017 Difference between @@servername and SERVERPROPERTY(ServerName)

June 13, 2017 Unable to connect to Microsoft Distributed Transaction Coordinator (MS DTC) to check the completion status of transaction

June 06, 2017 Enable full text search for Msg 7609 Full text search is not enabled or a full text component cannot be loaded

June 01, 2017 How to Check Powershell version

May 16, 2017 5 easy ways to protect SQL Server against Ransomware attacks

May 12, 2017 Msg 15151, Level 16, State 1, Line 1 Cannot alter the login 'Domain\Group', because it does not exist or you do not have permission.

May 10, 2017 Powershell find command and copy a file

May 07, 2017 Windows folder permissions with Powershell Get-ACL

May 02, 2017 Powerhsell Get-ChildItem folders only

May 01, 2017 Read SQL Server Error Logs with Powershell and SMO

April 30, 2017 Ultimate psychology guide - MEMORY

April 25, 2017 Powershell monitor log file for string with select-string and regex

April 19, 2017 Powershell get-childitem and date modified

April 18, 2017 How to write to a sql error to windows server event viewer

April 17, 2017 SQL Server 100 cpu diagnose

April 15, 2017 Script to check if a SQL database has a backup

April 14, 2017 With great ignorance comes great confidence

April 12, 2017 Powershell script to check disk space on remote servers

April 11, 2017 Configurations eating up sql server performance

April 07, 2017 Simple Ideas to improve the life of a DBA

April 06, 2017 How to mount an ISO - Disk Image File

April 05, 2017 Data Migration Assistant for SQL Server 2016 Upgrade

April 04, 2017 Strategies for sql server performance tuning

March 30, 2017 How to write a conditional substring in sql

March 28, 2017 Powershell insert into sql table

March 24, 2017 SQL Server Stuff and comma delimited column

March 20, 2017 Monitoring development v production environment

March 14, 2017 Focus on the DBA basics with the 95 - 5 rule

March 08, 2017 SQL Query to check Vmware cpu and memory overcommit

March 03, 2017 How to check the transaction log size in SQL Server

March 01, 2017 Powershell append to file by joining two files

February 27, 2017 Troubleshootoing performance problems in sql server with sys.dm_os_wait_stats

February 24, 2017 How to check SQL Server AlwaysOn High Availability is enabled

February 23, 2017 Powershell script to report SQL Error Log

February 22, 2017 How to backup the SQL Server SystemResource db – mssqlsystemresource

February 21, 2017 Help command in sql for undocumented commands

February 20, 2017 Resource database in SQL Server SystemResource db - mssqlsystemresource

February 17, 2017 How to shrink tempdb when Event ID 1101 Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'

February 15, 2017 SQL Memory usage query and cachestore_sqlcp

February 12, 2017 Guiding principles of wait time analysis

February 11, 2017 T SQL Antipatterns - SQL Antipattern #010

February 10, 2017 Windows Server 2012 empty recycle bin

February 07, 2017 Get cumulative update number for SQL Server Version

February 06, 2017 SQL Server uptime query

February 05, 2017 What is causing sql Cache Pressure

February 04, 2017 Ultimate GLOBALISATION guide

February 03, 2017 Helpful sql commands to manage SQL Agent Jobs

February 02, 2017 How to find of the QUOTED_IDENTIFIER used for stored procedure

January 31, 2017 How to get row count for every table in database

January 27, 2017 Skills required for rapid development

January 24, 2017 xp_cmdshell copy – access is denied

January 23, 2017 Will placing a large data column as an index INCLUDE impact sql query performance

January 22, 2017 Backup failures SQLVDI: Loc=CVDS::Close. Desc=Open devices!. ErrorCode=(0).

January 21, 2017 The future of the DBA profession

January 20, 2017 How to shrink SQL Server database transaction log file initial size

January 18, 2017 ASYNC_IO_COMPLETION during sql server backup

January 17, 2017 Microsoft ACE OLEDB 12.0 provider is not registered on the local machine

January 16, 2017 Notes on Performance Tuning very large databases for OLTP

January 15, 2017 Database Tuning Advisor Performance

January 14, 2017 Warren Buffett Billionaire Tips

January 13, 2017 Detach versus Offline

January 12, 2017 How to get FQDN of multiple servers with Powershell

January 11, 2017 How Busy is my SQL Server

January 10, 2017 Error 17836 Length specified in network packet payload did not match number of bytes read; the connection has been closed

January 09, 2017 ERROR 8623 The query processor ran out of internal resources and could not produce a query plan

January 08, 2017 FROM REDCAR TO RUST

January 07, 2017 How to check if a file exists with xp_fileexist

January 06, 2017 Difference between TCP and UDP network protocols

January 04, 2017 A 5 MB hard drive in 1956 needed a forklift

January 03, 2017 How to monitor Blocked Processes with SQL Alert and email sp_whoisActive report

January 01, 2017 The politics of Calais , border control and Brexit

December 30, 2016 Schrodinger’s backup - A warning for DBAs

December 29, 2016 10 most visited pages on sqlserver-dba.com for 2016

December 22, 2016 Privatisation can help upgrade public infrastructure

December 21, 2016 GRANT VIEW DEFINITION to script out tables

December 20, 2016 Limitations of xp_logininfo

December 09, 2016 SQL Server restart times using Powershell

November 30, 2016 Impact of Brexit on IT contractors

November 26, 2016 Using SQL Server Express in Production

November 25, 2016 Social Conformity and questioning authority

November 23, 2016 Display all files in a directory with master.sys.xp_dirtree

November 15, 2016 Powershell script - Get the SQL Server Instance status with Get-Service

November 15, 2016 Disadvantages of using sp_MSforeachdb

October 29, 2016 How to find Longest running queries in SQL Server

October 29, 2016 Global Population Growth, Box by Box Ted Talk

October 12, 2016 How can I tell if hyperthreading is on Windows 2012

September 20, 2016 How to schedule Powershell Script with Task Scheduler

September 06, 2016 Lots of NULL values can cause trouble

September 05, 2016 ALTER INDEX REBUILD clears sys.dm_db_index_usage_stats

September 02, 2016 7 mistakes DBAs make on CV or resume

September 02, 2016 5 ways globalisation has impacted IT

September 01, 2016 Is a LOG BACKUP allowed on a SIMPLE RECOVERY database

August 31, 2016 How to turn AUTO_SHRINK off

August 29, 2016 7 Essential Steps to Recover a Corrupt SQL Server Database

August 26, 2016 DBA vacancy at Travelers - UK based

July 22, 2016 Get Last Windows boot up time with Powershell

July 20, 2016 How to list Domain Controllers in a Domain with nltest

July 11, 2016 Hypothetical Indexes

July 05, 2016 Microsoft Enterprise Advantage Licensing on MPSA

July 04, 2016 Query to find non – sargable sql statements – SQL Antipattern #009

June 30, 2016 Set owner failed for database an exception occurred in smo - Msg 15110, Level 16, State 1, Line 1

June 29, 2016 BT and Oracle cloud link up

June 24, 2016 Danger of maintaining SQL backup copies in different locations

June 06, 2016 Trace flag 610 and High performance data loading

May 27, 2016 How to check my SQL permissions

May 25, 2016 Troubleshooting SQL Server Service Broker

May 21, 2016 Show me the wait stats

May 06, 2016 SQL Service hanging with Change Pending Error

April 15, 2016 Msg 8116 - Argument data type sql_variant is invalid for argument 1 of function

April 13, 2016 Powershell script – Function to return server disk capacity

April 12, 2016 How to reduce THREADPOOL wait type

April 05, 2016 Are you sleeping enough? Take the sleep test

April 04, 2016 Principle of Least Privilege

March 30, 2016 Forceseek table hint to the rescue

March 24, 2016 SQL Server Backup – Restore vs Detach – Attach : which method is faster?

March 23, 2016 How to monitor progress of Online Index Rebuild

March 22, 2016 How to monitor progress of Offline Index Rebuild

March 21, 2016 How to check SQL Server password policy

March 20, 2016 Increase speed of a NOT EQUAL operator and a workaround using a computed column

March 19, 2016 How to delete millions of rows in batches

March 18, 2016 How to create a table in another FILEGROUP using SELECT INTO

March 17, 2016 How to complete an INSERT in batches for large data sets

March 14, 2016 How to understand CXPACKET wait type resource description in Sys.dm_os_waiting_tasks

March 13, 2016 The 90 – 90 rule – SQL Antipattern #009

March 12, 2016 How to create a DBA skills matrix

March 11, 2016 How to audit DML statements based on server principal name

March 09, 2016 What is acceptable database server performance testing

March 08, 2016 New Database request checklist

March 07, 2016 Managing security for SQL restores

March 06, 2016 How to use xp_readerrorlog parameters to search SQL Error Logs

March 05, 2016 Lockard Principle and database theft

March 04, 2016 How to fix - Lock request timeout period exceedd Error 1222

March 03, 2016 How to use GO command for multiple execution of sql statements

March 02, 2016 How to add a sql table to a different FILEGROUP

March 01, 2016 Powershell script: Powershell equivalent of Linux top

February 29, 2016 Is AntiVirus Software required on a SQL Server

February 28, 2016 Premature optimization - SQL Antipattern #008

February 27, 2016 How to use Deductive and inductive logic for sql troubleshooting

February 26, 2016 SSMS Query Options – Discard results after execution

February 24, 2016 SQLCMD and blank password

February 23, 2016 How to get the sql object name using the Resource Id

February 21, 2016 3 ways to identify an expert

February 20, 2016 Top 5 SQL Server Forums

February 19, 2016 3 methods to get the drive sizes with Powershell

February 18, 2016 How use Powershell Get-Service on a remote server without Powershell Remoting

February 16, 2016 SQL Script - How to find type of objects filling TempDB

February 15, 2016 Accidental complexity - SQL Antipattern #007

February 14, 2016 Top 4 Best SQL Editors

February 12, 2016 10 most popular sqlserver-dba posts for 2015

February 11, 2016 VM Snapshot Backup Review for databases

February 10, 2016 Powershell Script : How to copy a file on a remote share to a remote server

February 09, 2016 The economics of performance tuning

February 08, 2016 5 database subjects I'm researching

February 07, 2016 Performance Tuning by Committee - SQL Antipattern #006

February 06, 2016 Troubleshooting - Msg 845 - Time-out occurred while waiting for buffer latch type 3

February 05, 2016 Powershell Script - How to find Event Log entries for IO problems that could cause database corruption

February 02, 2016 How to capture DML for a single logon on database audit specification

February 01, 2016 Natural key versus Surrogate key on a 1 column table

January 31, 2016 DBA jokes

January 30, 2016 DRY or WET – SQL Antipattern #005

January 28, 2016 What does the FILE clause mean during a SQL Restore

January 27, 2016 Powershell Script – How to get windows logs events with Get-WinEvent for a date range

January 26, 2016 How to Audit user DML with SQL Server Extended Events

January 25, 2016 How to troubleshoot Flush Cache error message in SQL Server Logs

January 24, 2016 The future of jobs – 5.1 million job losses and the superstar economy

January 22, 2016 Blind Faith versus Test Oriented programming – SQL Antipattern #004

January 21, 2016 How to find VMWare ESX Host event messages using VPXV_EVENTS

January 18, 2016 SQL Script : How to find Nested Loops in Execution Plans for a specific table

January 17, 2016 SQL Silver Bullets and Easy Fixes - SQL Antipattern #003

January 16, 2016 The practise of Hard Coding – SQL Antipattern #002

January 15, 2016 How to spot a SQL Antipattern

January 14, 2016 How to copy a table from one database to another database

January 13, 2016 How to query Active Directory with xp_logininfo

January 12, 2016 How to export Excel worksheet columns into a html file with Powershell

January 11, 2016 How to list constraints of a table

January 09, 2016 How can I escalate a database issue

January 09, 2016 Fix: –NESTING_TRANSACTION_FULL wait type and how to reduce it

January 08, 2016 SQL Script - How to get the table size, index size and last user update

January 07, 2016 3 ways to have fun with DBCC PAGE

January 06, 2016 Why is SQL Server executing DBCC CHECKDB against my database at startup?

January 05, 2016 Troubleshooting ImpersonateSecurityContext in RING_BUFFER_SECURITY_ERROR

January 04, 2016 How to predict DBCC CHECKDB finish time

January 03, 2016 3 reasons to get help from the DBA

January 02, 2016 SQL Indexed View limitations

January 01, 2016 SQL Server Fix : - The media family on device xxxxx.bak is incorrectly formed. SQL Server cannot process this media family. Msg 3241, Level 16, State 7, Line 1

December 31, 2015 How to find sql transactions with large logs

December 29, 2015 How to fix System.OutOfMemoryException when using SSMS

December 28, 2015 How to return a character string from a sql datepart using DATENAME

December 26, 2015 How to deal with unexpectedly large transaction log files

December 22, 2015 VM Memory balloon performance counters

December 18, 2015 How to Generate a Perfmon System Diagnostics Report

November 30, 2015 Missing CLR data types on client - Microsoft.SqlServer.Types - geography and geometry

November 19, 2015 How to Calculate the size of sql results in KB?

November 17, 2015 Precalculated SQL Views data

October 31, 2015 7 Twitter Feeds every SQL Server DBA should follow

October 29, 2015 10 million passwords unmasked

October 28, 2015 5 websites that will make you a better SQL Server DBA

October 16, 2015 Using NULL as an ordinary value in sql code - SQL Antipattern # 001

October 14, 2015 Object Dependency in SQL Server

October 12, 2015 5 tricks to boost DBA productivity

October 05, 2015 How to understand the RING_BUFFER_SCHEDULE_MONITOR

September 29, 2015 How to create a temporary Stored Procedure using TempDB

September 14, 2015 sp_WhoIsActive utility for SQL Server troubleshooting

September 02, 2015 Performance Tuning – The wrong way

August 07, 2015 Powershell Add-Content – How to add another query result to an existing html report

August 01, 2015 Find Table Scans in Query Plan Cache

July 28, 2015 Memory grants and execution plans

July 24, 2015 Database has more than 1000 virtual log files which is excessive – informational message 9017

July 15, 2015 How to find CurrentClockSpeed and MaxClockSpeed using Powershell Get-WmiObject win32_processor

July 10, 2015 SQL Server Install Checklist

July 03, 2015 Find Windows pagefile location through command line and wmic

June 24, 2015 How to list all SQL Server Caches and use DBCC FREESYSTEMCACHE to clear

June 16, 2015 SQL Server gets slower until I restart

June 10, 2015 How to encrypt a file with AES encryption

June 09, 2015 How to find the SQL Server service pack is installed

June 05, 2015 Detach database breaks the DIFFERENTIAL backup chain when READ ONLY

June 02, 2015 Error 16955 – Could not create an acceptable cursor . Dynamic cursors and DISTINCT KEYWORD

May 29, 2015 How to troubleshoot Error 2601 Cannot insert duplicate key row in object '%.*ls' with unique index '%.*ls'. The duplicate key value is %ls.

May 28, 2015 Error 18456 State 5 Invalid User ID and managing failed logins

May 27, 2015 SQL Server Security Violations Report for t-sql tuesday

May 20, 2015 Error 7983 - User '%.*ls' does not have permission to run DBCC %ls for database '%.*ls'

May 19, 2015 How to automate Sql Server Configuration Manager settings

May 15, 2015 Troubleshoot SQL Security Error Ring Buffer Recorded - System Health

May 12, 2015 SQL Server Configuration Manager from Command Line

May 08, 2015 INSERT SELECT into existing table

May 06, 2015 dotNet framework 3.5 is a SQL Server 2012 prerequisite

May 05, 2015 Find database users mapped to db_owner role

May 04, 2015 What is First Normal Form, Second Normal and Third Normal Form

May 02, 2015 SMB 3.0 and SQL Server reading list

April 30, 2015 How to find the SQL Server Service Account

April 29, 2015 How to fix : Operarator used tempdb to spill data during execution warning

April 28, 2015 Backing up the tail log

April 27, 2015 How to use ISO-8601 for date and datetime

April 25, 2015 New database or new instance

April 25, 2015 Inside Google Data Centers

April 24, 2015 Execute permission was denied on the object

April 21, 2015 Security audit for SQL public role

April 16, 2015 The Agile DBA

April 07, 2015 Implicit conversion of data types in the query engine

March 30, 2015 Powershell script to report SQL Database Status

March 21, 2015 Researching FlashCopy Manager for backup and restore management

March 12, 2015 Find high IO read and write SQL Queries and display query plan

March 04, 2015 Execute Sp_table_privileges on all SQL Server instance databases

February 25, 2015 How to check UAC – User Account Control is enabled or disabled

February 19, 2015 Connect to SQL Server using port number

February 16, 2015 Xp_cmdshell – the most dangerous extended stored procedure on the planet

February 12, 2015 DROP SCHEMA script for multiple sql database users

February 06, 2015 The transaction log for database is full due to ACTIVE_TRANSACTION

February 03, 2015 How to crack the SQL Login password from sys.syslogins

February 02, 2015 OFFLINE Database files not deleted when DROP DATABASE is executed

February 02, 2015 Detach and Offline for moving databases

January 27, 2015 How to List SQL logins and database user mappings

January 25, 2015 Index column order in Index Missing Feature

January 24, 2015 Query VMWare vCenter VCDB database for guest and host details

January 14, 2015 How to select tables in a schema using sysobjects

January 13, 2015 Msg 15138 - The database principal owns a schema in the database and cannot be dropped.

January 10, 2015 How to tune every query

January 07, 2015 The EXECUTE permission was denied on the object sp_enum_dtspackages

January 06, 2015 Script to change database owner to sa for all user databases

January 03, 2015 Ask the Duck Your Question

January 02, 2015 SQL Injection Defence

January 01, 2015 Hot trends in database server management for 2015

December 29, 2014 Top 10 most active posts for SQLServer-DBA.com in 2015

December 26, 2014 How to go from New DBA to Advanced DBA

December 25, 2014 Database Performance Tuning Jobs

December 25, 2014 Bad indentation in stored procedures

December 24, 2014 Drop sysadmin with ALTER SERVER ROLE and DROP MEMBER

December 23, 2014 Interview with Author on essential SQL

December 15, 2014 bcp - export and import data on SQL Server

December 10, 2014 List all NT group logins with Powershell

December 08, 2014 Century of the System and managing complexity

December 06, 2014 Failure inserting into the read-only column and SET IDENTITY_INSERT ON

December 03, 2014 Simple example of WHILE loop to iterate through sys databases

November 25, 2014 BULK INSERT and ROLLBACK

November 18, 2014 Read a script file into Powershell CommandText with get-content

November 14, 2014 How to manage the IS_GRANTABLE security risk

November 11, 2014 How to decide on the Primary Key

November 10, 2014 Encrypting data in SQL Server

November 09, 2014 Isolate top waits for server instance since last restart or statistics clear

November 07, 2014 How to list all CLR objects and associated procedures

November 03, 2014 List all SQL jobs in Job Activity Monitor with Sp_help_job

October 15, 2014 How to Script SQL database role permissions and securables

October 13, 2014 Help Women At Risk in Bulgaria

October 09, 2014 Connect SQL Server 64 bit to odbc 32 bit

October 07, 2014 How to get the DNS API permissions in CLR assembly

October 04, 2014 Definition of a scalar value in a relational database

October 03, 2014 xp_cmdshell whoami – Determine which Windows Account is used

October 01, 2014 Where to maintain data integrity rules?

September 25, 2014 List enabled status of SQL Server Agent Jobs

September 23, 2014 How much free memory on the server?

September 22, 2014 How to find Active tables without a clustered index

September 20, 2014 Last known good backup – Assumption is the mother of all xxxx ups

September 17, 2014 How to choose Internet Explorer 64 bit version

September 16, 2014 Script to DROP CONSTRAINT and ADD CONSTRAINT for all CHECK CONSTRAINTS

September 15, 2014 Msg 5075 - The database collation cannot be changed if a schema-bound object depends on it

September 14, 2014 Full Recovery without Log Backups

September 13, 2014 Query Tuning cannot be taught over forums

September 10, 2014 Troubleshoot SDDDSM error messages

September 09, 2014 SQL Server DBA Checklists

September 07, 2014 Best of sqlserver-dba-com

September 06, 2014 How to List Task Scheduler Eventlog with messages using Powershell

September 05, 2014 Using the tcp: prefix for SQL Server connections : Force use of TCP protocol

September 04, 2014 Find the Root cause of a SQL Server Performance downgrade

September 03, 2014 Error 3621 - The statement has been terminated

September 01, 2014 Find database corruption with msdb.dbo.suspect_pages

September 01, 2014 SQL Server Memory: Any size page allocator replaces single and multi-page allocator

August 31, 2014 Delete a huge amount of data from a SQL Server table

August 29, 2014 Generate query results and attach to email using SQL Server Database Mail

August 29, 2014 How to output Query results to text file using bcp and queryout

August 27, 2014 How to start SQL Performance Tuning

August 27, 2014 DBA daily study habits

July 29, 2014 Msg 3257 :There is insufficient free space on disk volume during SQL Server Restore

July 15, 2014 Find SQL deprecated features with sys.dm_os_performance_counters

July 11, 2014 How to backup a single table with data in a database

July 10, 2014 Warning: Failure to calculate super-latch promotion threshold

July 04, 2014 Compatibility error when using MERGE. Incorrect syntax near 'MERGE'.

July 01, 2014 Perfmon SQL Server Deprecated Features Object

June 30, 2014 Troubleshoot high disk activity with STATISTICS IO

June 27, 2014 The specified DSN contains an architecture mismatch between the Driver and application

June 26, 2014 How to Export Active Directory Group Members with Powershell Get-ADGroupMember

June 23, 2014 Measuring SAN Performance with Avg Disk Transfer and disk bytes per second

June 19, 2014 How to Reduce the WRITE_COMPLETION wait type

June 17, 2014 How to identify the Primary Transaction Log file on a SQL Server

June 11, 2014 How To restore to lower SQL Server version

June 09, 2014 Business Objects versus SSRS

June 06, 2014 Export multiple Excel worksheets to a single SQL Server table

June 04, 2014 How to use sxstrace.exe – diagnose side-by-side errors

June 03, 2014 Predictability is the key to scalability

May 30, 2014 Difference between sys.objects and sysobjects

May 28, 2014 How to schedule a SQL Server Agent Job to execute once a year -(Annually)

May 27, 2014 Connect SQL Servers without using Linked Servers – OPENROWSET and OPENDATASOURCE

May 21, 2014 SQL Server RUNNABLE – SUSPENDED – RUNNING status model

May 19, 2014 How to drop a SQL column and find foreign keys with sp_fkeys

May 15, 2014 How to Predict SQL Server Performance

May 10, 2014 How to reduce DBMIRROR_EVENTS_QUEUE , DBMIRROR_SEND, DBMIRRORING_CMD, DBMIRROR_DBM_MUTEX wait types

May 08, 2014 Use Powershell Get-Hotfix to get all hotfixes on Windows server

May 06, 2014 How to get a list of software installed on a server using Powershell

April 30, 2014 How to install the Active Directory Module for Windows Powershell

April 28, 2014 Hide instance of SQL Server

April 26, 2014 Continual Improvement or kaizen

April 23, 2014 How to find SQL License type

April 20, 2014 Error 3266 : How to troubleshoot Error 3266 during a Restore

April 17, 2014 How to SET and check READ_COMMITTED_SNAPSHOT

April 16, 2014 What are your data needs?

April 09, 2014 List columns using INFORMATION_SCHEMA

March 25, 2014 Creating a Disaster Recovery Plan

March 24, 2014 Error 5171 – mdf is not a primary database file

March 21, 2014 Troubleshooting BACKUPTHREAD wait type

March 19, 2014 Troubleshooting Error: 18452, Severity: 14, State: 1


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer