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
2,627 reads
On a routine scan of Event Viewer System, Logs I found this message on 4 different servers hosting SQL Server...
2012-03-09
2,627 reads
To display network connections and various network interface statistics – netstat is a handy command – line based tool.
Why is it...
2012-03-08
1,304 reads
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,437 reads
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,158 reads
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,318 reads
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,283 reads
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,950 reads
This post explains how to list Event Log Messages with Powershell Get-EventLog , on multiple servers and output the results to...
2012-02-25
1,973 reads
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,108 reads
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,253 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers