Browse by Tags

• Configuration
• Database Administration
• Extended Events
• Internals
• Memory Allocation
• SQL Server 2008
• Transact-SQL

• 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 | 6 Comments Filed under: TSQL2sday

• T-SQL Tuesday #12 - Why are DBA skills necessary?

  This month’s TSQL Tuesday event is being hosted by Paul Randal (Blog|Twitter), and for November is a week early so that it doesn't clash with PASS.  For this month, Paul picked the topic  "why are DBA skills necessary?" which is quite Read More... Posted Tuesday, November 02, 2010 10:36 PM by Jonathan Kehayias | 0 Comments Filed under: TSQL2sday

• TSQL Tuesday #11 – Misconceptions - The Tempdb Log File and VLF Counts

  This post is part of the monthly community event called T-SQL Tuesday started by Adam Machanic ( blog | twitter ) and hosted by someone else each month. This month the host is Sankar Reddy ( blog | twitter ) and the topic is Misconceptions in SQL Server Read More... Posted Tuesday, October 12, 2010 11:18 PM by Jonathan Kehayias | 2 Comments Filed under: Database Administration, Internals, TSQL2sday

• TSQL Tuesday #11 Misconceptions – Enable AWE on 64bit SQL Servers

  This post is part of the monthly community event called T-SQL Tuesday started by Adam Machanic ( blog | twitter ) and hosted by someone else each month. This month the host is Sankar Reddy ( blog | twitter ) and the topic is Misconceptions in SQL Server Read More... Posted Tuesday, October 12, 2010 1:58 PM by Jonathan Kehayias | 2 Comments Filed under: Configuration, Database Administration, Internals, Memory Allocation, TSQL2sday

• TSQL Tuesday #11 – Physical IO’s Don’t Always Accumulate Wait Times

  It is time again for another TSQL Tuesday, this time hosted by my good friend and fellow MVP, Sankar Reddy ( Blog | Twitter ). This month’s topic is Misconceptions about SQL Server and as Sankar points out in this months, there are so many misconceptions Read More... Posted Tuesday, October 12, 2010 3:13 AM by Jonathan Kehayias | 8 Comments Filed under: Extended Events, SQL Server 2008, TSQL2sday

• T-SQL Tuesday #008: Turning Civilians into Soldiers

  This month’s T-SQL Tuesday, started by Adam Machanic ( Blog | Twitter ),  is being put on by SQLServerCentral author and MCM, Robert Davis ( Blog | Twitter ).  This month the topic is learning and teaching Read More... Posted Wednesday, July 14, 2010 12:53 AM by Jonathan Kehayias | 1 Comments Filed under: TSQL2sday

• TSQL2sday: Using sys.dm_exec_sql_text() to get the calling statement

  This week I have two posts for TSQL2sday .  Initially I wrote my first blog post , but as luck would have it, today a second topic for TSQL2sday popped up through the comments on my recent SQL Server Central Article, Using a Certificate Signed Stored Read More... Posted Tuesday, January 12, 2010 12:26 AM by Jonathan Kehayias | 4 Comments Filed under: TSQL2sday

• Downgrading from SQL 2008 to 2005

  Every couple of weeks on one of the forums someone will ask a question about how to restore a backup from SQL 2008 to SQL 2005.  The answer to the question is always, you can’t restore a backup to a lower version of SQL  Server.  If you Read More... Posted Monday, January 11, 2010 11:51 PM by Jonathan Kehayias | 7 Comments Filed under: TSQL2sday

• T-SQL Tuesday #001: Splitting Date/Time Ranges and Intersections

  At the end of November, Adam Machanic put out the invite to join a weekly blog party called TSQL Tuesday where bloggers have a given topic to blog about offering tips and tricks.  This weeks theme is Date/Time tricks so I thought I’d share a trick Read More... Posted Tuesday, December 08, 2009 3:17 PM by Jonathan Kehayias | 1 Comments Filed under: Transact-SQL, TSQL2sday