New class: Immersion Event on Azure SQL Database and Azure VMs
We have a really cool new class debuting this October in Chicago: Immersion Event on Azure SQL Database and Azure VMs. It’s a 2-day class,
We have a really cool new class debuting this October in Chicago: Immersion Event on Azure SQL Database and Azure VMs. It’s a 2-day class,
As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that
You may not know this, but for the last six years I’ve been producing a bi-weekly newsletter for everyone signed up for our mailing list
As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that
As we head towards our 9th SQLintersection in May, I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet!
With the publication of our most recent Pluralsight course last month, we now have a whopping 50 online training courses available through Pluralsight, totally more
Last week there was a short discussion on Twitter about why PFS pages (damaged header, not individual PFS bytes) can’t be repaired (prompted by a
As Kimberly mentioned last week, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that
In Monday’s newsletter I discussed an email question I’d been sent and promised to blog about it. The question was “how can latch waits for
Although we won’t be presenting any Immersion Events in Europe in 2017, Kimberly and I will both be presenting workshops and sessions at SQLSaturday
We have a really cool new class debuting this May in Chicago: Immersion Event on PowerShell for SQL Server DBAs. It’s a 3-day class, taught
Our first new course of the year, and our 50th online training course with Pluralsight!! Erin’s latest Pluralsight course has been published – SQL Server: Introduction to Query
Last week I was sent an email question about the cause of LOGMGR_RESERVE_APPEND waits, and in Monday’s Insider newsletter I wrote a short explanation. It’s
In Monday’s Insider newsletter I discussed an email question I’d been sent about how to identify the transactions that had rolled back because of a crash, and
I’ve just released our second set of classes for 2017 for registration! Our classes in July/August will be in Bellevue, WA: IEPTO1: Immersion Event on Performance
The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the
Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011,
As we all wind down for the 2016 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’
Earlier today someone asked on the #sqlhelp Twitter alias if there is a history of database snapshot creation anywhere, apart from scouring the error logs.
By the end of December, we at SQLskills will have presented remotely (and a few in-person) to 94 user groups and PASS virtual chapters around the
This is something that came up recently on the Microsoft Certified Master DL, and is something I discuss in our IEPTO1 class because of the
This is a quick post to blog a script that allows spinlock statistics to be captured for a defined period of time (as I need
As we head into our 8th SQLintersection next month, I’m excited to say that it’s our most diverse, complete, and information-packed show yet! We have 3 precon
I’ve just released our first set of classes for 2017 for registration, including a new 3-day class on PowerShell! Our classes in April/May will be
The pages at each level of an index are linked together in a doubly-linked list (using the m_nextPage and m_prevPage fields in their page headers)
Due to scheduling issues, we’re not presenting any classes in Europe in 2017 or early 2018, so your last chance to come to one of
Tim’s first ever Pluralsight course has been published – SQL Server: Consolidation Tactics and Best Practices – and is just over two hours long. It consolidates (ha!) all of Tim’s
Erin’s new course is called SQL Server: Replacing Profiler with Extended Events and is just under 2.5 hours long. It’s based on her very popular user group/conference session
There’s a persistent myth that you cannot upgrade a database to a version more that is more then two versions newer. It’s not true. You
It’s finally ready! For the last two years, I’ve been working on-and-off on a new community resource. It was postponed during 2015 while I mentored
Yesterday in class we had a discussion around the conceptual problem of reconciling the fact that SQL Server does set-based operations, but that it does
Edit 10/30/19: the latest version of this script, with additions and adapted for newer versions is here. A question came up in class today about easily seeing the
Over the weekend there was a discussion on the MVP distribution list about the sys.dm_tran_database_transactions DMV and how one cannot use it to accurately determine
Through the end of July, we’re offering a complete single-instance health-check for a flat fee of US$2,500… One of the most popular services we provide
Erin’s new course is called SQL Server: Understanding and Using DBCC Commands and is just over 2.25 hours long. It covers all the documented DBCC commands and a
No, this isn’t an April fools joke. Microsoft announced today at the Build conference that they’ve made SQL Server 2014 (and 2016 when it ships)
My first post of the year is about our first Pluralsight course of the year! Jonathan’s new course is called SQL Server: Building Simple Asynchronous Applications and is just
The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the
Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011,
Through popular demand (our IEPTO2 class in Ireland in October 2015 sold out with 40 students!) we’ve managed to juggle a bit more of our schedule
As we all wind down for the 2015 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’
I’m running this survey to help the SQL Server team at Microsoft, who would like to get a broad view of current tempdb configurations. I’ll
An interesting corruption problem cropped up on the MCM distribution list yesterday and after I figured it out, I thought it would make a good
After the success of our brand-new class on Practical Data Science this week, we’ve decided to expand it to five days and bring it back
By the end of December, we at SQLskills will have remotely presented to 87 user groups and PASS virtual chapters around the world in 2015! We’d
In my Insider newsletter a couple of weeks ago, I discussed how index fragmentation is often considered when designing indexes, but index depth often isn’t. In
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] SQL Server 2014 (and
This year’s Fall SQLintersection conference in October is fast approaching and we’ve got some excellent full-day workshops lined up for you: Sunday 25th: Kimberly with Queries
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.