SQL Server - Kerberos and KRB_AP_ERR_MODIFIED
On a routine scan of Event Viewer System, Logs I found this message on 4 different servers hosting SQL Server...
2012-03-09
3,084 reads
- Interests: Performance Tuning Database Servers, Running and Coffee
SQL Server – netstat monitoring and tuning performance
To display network connections and various network interface statistics – netstat is a handy command – line based tool.
Why is it...
2012-03-08
1,317 reads
SQL Server – sys.master_files and list all database files
Use the system view “sys.master_files” for a single view of databases and database files.
Instead of using sys.sysfiles joing to sys.sysdatabases...
2012-03-07
1,451 reads
SQL Server 2005 to SQL Server 2008 R2 upgrade considerations
1) SQL Server 2008 R2 Reporting Services doesn’t support Windows 2003 (or R2) Itanium based servers
2) SQL-DMO support is stopped...
2012-03-06
1,166 reads
SQL Server – How to troubleshoot query timeouts
Common reasons for query time-outs are :
1) The application starts using a query not optimal for the index
2) Hardware changes\...
2012-03-04
4,382 reads
sql server scripts and managing databases
Managing a large SQL Server inventory requires an efficient management processes.
Following on from DBA productivity and less is more , this...
2012-03-01
1,296 reads
SQL Server Agent Job Steps
To list a SQL Server Agent Job Steps use the T-SQL example below.
This example displays the step id, SQL Server...
2012-02-28
1,965 reads
Powershell Get-EventLog and Event Log messages
This post explains how to list Event Log Messages with Powershell Get-EventLog , on multiple servers and output the results to...
2012-02-25
2,005 reads
SQL Server - DBA Team FAQ
Developers constantly ask about placing the latest code\feature\process\third party applications onto Production Database Servers.
I’m building an FAQ to supply Developers...
2012-02-24
1,119 reads
SQL Server – Powershell Active Directory search
Working with Powershell and Active Directory simplifies some complex tasks for the DBA.
Active Directory is LDAP compliant. This means the...
2012-02-20
1,267 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers