SQL Server Trace Flags
A comprehensive list of trace flags for SQL Server that you can use to configure your server instance.
2013-07-05 (first published: 2010-06-03)
26,491 reads
Yusuf Anis
Ports that DBAs Need to Know
This article lists the essential TCP/UDP ports that an administrator running SQL Server or a cluster should know.
2011-10-28
11,894 reads
Blogs
Extended Events Misperceptions: Profiler is Easier, Part 2
I wrote a short blog post about the misperception that Profiler was easier than...
CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))
If you read the title to this post and your first thought was That’s...
sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019
sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...
Forums
2-node cluster, multiple SQL instances
Hi, What are the best practices/guidelines for this? Currently have a 2-node WSFC running...
Database Integrity Check jobs running for ever in Sql 2012
We have Database Integrity Check jobs running every early morning during off hours into...
Auditing System questions- no personal experience
Good Morning All -I have used triggers to do some basic auditing, but I...
Ask SSC