Browse by Tags

• .NET/CLR Integration
• ADO.NET Programming
• Articles
• Book Review
• Bug Reports
• Business Intelligence
• Comparing TSQL/SQLCLR
• Compression
• Configuration
• Database Administration
• Deadlock
• Did You Know
• Disk IO
• DMV's
• Error Messages
• Extended Events
• Goals
• Internals
• LINQ to SQL
• Memory Allocation
• Miscellaneous
• MSDN Forums
• Networking
• Operating Procedures
• Operations Manager
• PASS
• Plan Cache
• Plan Explorer
• Policy Based Managment
• Powershell
• Presentations
• Product Reviews
• Programming
• Rants and Ramblings
• Security
• SQL Quiz
• SQL Sentry
• SQL Server 2008
• SQL Server 2008 R2
• SQL Server Denali
• SQLBits
• SSMS Addin
• Storage
• Team Foundation Server
• Transact-SQL
• TSQL2sday
• Upgrades
• Virtualization
• Wait Statistics
• Whitepapers
• XEvent A Day
• Year in Review

• Times they are a changing…

  If you follow me on twitter ( @SQLSarg ), you already know that this has been a week of big announcements for me. Wednesday afternoon Paul Randal ( Blog | Twitter ) announced that I joined SQLskills.com as a full time employee, and Thursday afternoon, Read More... Posted Friday, February 25, 2011 2:23 PM by Jonathan Kehayias | 5 Comments Filed under: Miscellaneous

• TSQL Tuesday #15 – Maintaining Your Sanity While Managing Large Environments

  This month’s TSQL Tuesday event is being hosted by Pat Wright (Blog | Twitter) and the topic this month is Automation! “ I figured that since many of you out there set a goal this year to blog more and to learn Powershell then this Topic should help in Read More... Posted Tuesday, February 08, 2011 12:19 AM by Jonathan Kehayias | 9 Comments Filed under: TSQL2sday

• Making Use of Plan Explorer in my own Environment

  Back in October 2010, I briefly blogged about the SQL Sentry Plan Explorer in my blog post wrap up for SQL Bits 7 and how impressed I was with what I saw from a Alpha demo standpoint from Greg Gonzalez ( Blog | Twitter ) while I was at SQLBits 7 in York.  Read More... Posted Wednesday, February 02, 2011 11:50 PM by Jonathan Kehayias | 4 Comments Filed under: Database Administration, Product Reviews, SQL Sentry, Plan Explorer

• Parsing the sqlserver.sql_text Action in Extended Events by Offsets

  A couple of weeks back I received an email from a member of the community who was reading the XEvent a Day blog series and had a couple of interesting questions about Extended Events.  This person had created an Event Session that captured the sqlserver.sql_statement_completed Read More... Posted Sunday, January 30, 2011 10:05 PM by Jonathan Kehayias | 2 Comments Filed under: Database Administration, Extended Events, SQL Server 2008, SQL Server 2008 R2, SQL Server Denali

• Using Substring() in XML FLOWR Queries

  Tonight I was monitoring the #sqlhelp hashtag on Twitter for a response to a question I asked when Randy Knight ( Twitter ) asked a question about using SUBSTRING in FLOWR statements with XML. #sqlhelp Is there a way to do a SQL Type "LIKE" Read More... Posted Monday, January 24, 2011 11:41 PM by Jonathan Kehayias | 2 Comments Filed under: Transact-SQL, Database Administration

• Did the Community Lose It’s Focus, or Did I?

  Late Thursday night, ok it was actually very early Friday morning, I wrote a blog post that stirred a bit of a controversy in the community.  While the outcome of the discussion that was sparked by that post in the community has been good, it is Read More... Posted Monday, January 10, 2011 7:05 PM by Jonathan Kehayias | 15 Comments Filed under: Rants and Ramblings

• Has the SQL Community Lost its Focus?

  Yesterday, Thomas LaRock’s blog post, WMI Code Creator , was brought to my attention by a member of the SQL Community. I subscribe to Tom’s blog in my blog reader so eventually I’d like to think that his post would have come to my attention, but to be Read More... Posted Friday, January 07, 2011 2:30 AM by Jonathan Kehayias | 27 Comments Filed under: Rants and Ramblings

• Using Extended Events in SQL Server Denali CTP1 to Map out the TransactionLog SQL Trace Event EventSubClass Values

  John Sansom ( Blog | Twitter ) asked on the MSDN Forums about the meaning/description for the numeric values returned by the EventSubClass column of the TransactionLog SQL Trace Event. John pointed out that this information is not available for this Event Read More... Posted Monday, January 03, 2011 2:39 AM by Jonathan Kehayias | 5 Comments Filed under: Extended Events, SQL Server Denali

• An XEvent a Day (31 of 31) – Event Session DDL Events

  To close out this month’s series on Extended Events we’ll look at the DDL Events for the Event Session DDL operations, and how those can be used to track changes to Event Sessions and determine all of the possible outputs that could exist from an Extended Read More... Posted Friday, December 31, 2010 3:00 PM by Jonathan Kehayias | 1 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (30 of 31) – Tracking Session and Statement Level Waits

  While attending PASS Summit this year, I got the opportunity to hang out with Brent Ozar ( Blog | Twitter ) one afternoon while he did some work for Yanni Robel ( Blog | Twitter ).  After looking at the wait stats information, Brent pointed out some Read More... Posted Thursday, December 30, 2010 10:00 PM by Jonathan Kehayias | 1 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (29 of 31) – The Future – Looking at Database Startup in Denali

  As I have said previously in this series, one of my favorite aspects of Extended Events is that it allows you to look at what is going on under the covers in SQL Server, at a level that has never previously been possible. SQL Server Denali CTP1 includes Read More... Posted Wednesday, December 29, 2010 10:30 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• Learn Who Started that Trace with the Default Trace

  This is not Extended Event related but it came from a question on Twitter about how to tell who and from what machine a server side trace was created, and there is no way to explain this in 140 characters so here’s a blog post.  This information Read More... Posted Wednesday, December 29, 2010 3:00 PM by Jonathan Kehayias | 4 Comments Filed under: Transact-SQL, Database Administration

• An XEvent a Day (28 of 31) – Tracking Page Compression Operations

  The Database Compression feature in SQL Server 2008 Enterprise Edition can provide some significant reductions in storage requirements for SQL Server databases, and in the right implementations and scenarios performance improvements as well.  There Read More... Posted Tuesday, December 28, 2010 10:00 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (27 of 31) – The Future - Tracking Page Splits in SQL Server Denali CTP1

  Nearly two years ago Kalen Delaney blogged about Splitting a page into multiple pages , showing how page splits occur inside of SQL Server.  Following her blog post, Michael Zilberstein wrote a post, Monitoring Page Splits with Extended Events , Read More... Posted Monday, December 27, 2010 10:00 PM by Jonathan Kehayias | 2 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali

• An XEvent a Day (26 of 31) – Configuring Session Options

  There are 7 Session level options that can be configured in Extended Events that affect the way an Event Session operates.  These options can impact performance and should be considered when configuring an Event Session.  I have made use of Read More... Posted Sunday, December 26, 2010 10:00 PM by Jonathan Kehayias | 0 Comments Filed under: Extended Events, SQL Server 2008, SQL Server 2008 R2, XEvent A Day, SQL Server Denali