Tag Archives: sql server

Brad McGehee talking about tempdb issues

Brad presented a session that tries to help you identify and fix tempdb problems. Performance monitor is your friend. the local disks, avg read and write counters should help you determine if I/O is an issue. Watch for systems where … Continue reading

Posted in Blog | Tagged , , | Comments Off on Brad McGehee talking about tempdb issues

Brian Kelley on Security at SQL Server Connections

Random notes from Brian Kelley’s security talk. Brian spent a number of years working a a security guy for a bank in the Windows and infrastructure teams. Networking, the UDP port is 1434. This is the listener and browser for … Continue reading

Posted in Blog | Tagged , , | Comments Off on Brian Kelley on Security at SQL Server Connections

Extended Events at SQL Server Connections with Jonathan Kehayias

I was very interested to hear Jonathan Kehayias’ session on extended events. I know this is one of the areas i need work and it is becoming a more important part of SQL Server with each version. Beginning with a … Continue reading

Posted in Blog | Tagged , , | Comments Off on Extended Events at SQL Server Connections with Jonathan Kehayias

Brian Kelley talking Windows Internals for SQL Pros at DevConnections

I have known Brian for nearly as long as i have been running SQLServerCentral. He has been the guy that I called for security questions. He was a DBA, then became a security and auditing guy, and is now back … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Brian Kelley talking Windows Internals for SQL Pros at DevConnections