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,530 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,530 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,301 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,435 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,156 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,297 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,279 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,946 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,963 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,105 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,251 reads
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Hi, This is my table and data CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_100]( [Id] [int] IDENTITY(1,1) NOT...
Hi All. I am seeing a scenario where SELECT is blocking a TRUNCATE statement...
Hi All, Need some help in tune a function which is reading TB's of...