This past Tuesday, the 19th of September, I started broadcasting a series of webinars which cover all the material in my SQL Server Internals classes that I’ve been delivering around the world for almost 20 years. I’ll even be able to add additional information not included in the classes because our time constraints are not quite so strict. As Microsoft added new features to the SQL Server product, I had to remove some still relevant content […]
Talks on Managing Data and Applications Anywhere
Before SQL Server 2016, configuration referred to instance-wide settings. But with Azure SQL Database not giving us access to any instance-level information or giving us any instance-level control, we only can see information and control settings for a specific database. So now, a new SQL Server 2016 feature allows us to have a bit more control of individual databases. And once a feature gets tested and verified in Azure, it’s ported to the SQL Server on-premises code. We now have […]
Long ago (in SQL Server years) many metadata changes were implemented with special one-off stored procedures. For example, we had sp_addindex and sp_dropindex, as well as sp_addtype, sp_droptype, sp_addlogin and sp_droplogin. For changing certain database properties, we had sp_changedbowner and sp_dbcmptlevel, to name a few. Gradually, Microsoft has started replacing these procedures with the more generic DDL commands ADD, DROP and ALTER. This is both good news and bad news. It’s good because these commands are more efficient and more […]
DB Best will be hosting a series of FREE workshops in the Midwest region with Kalen Delaney presenting. The workshops will focus on ‘Getting the most out of the SQL Server Engine”. Kalen Delaney is a SQL Server MVP, renowned author of the SQL Server Internals book series. With over two decades of SQL Server experience, Kalen has been a frequent speaker and authority on all things SQL Server. The workshops will include extensive Hands On Lab sections facilitated by […]
Even though Harvey’s impact will be felt mainly in Texas, it has been having a big effect on my life here in the Beautiful Pacific Northwest today. I was planning on traveling to Houston next Monday, the 28th, and then on to Austin and Dallas, for a series of workshops, which I was calling my Texas Tour. The worst of the storm might be over by Monday, but I am well aware of potential flooding problems in Houston post-storm. And […]
Over the next month, I’ll be presenting a free workshop in seven cities in the U.S. The workshop will include hands-on labs that allow you to explore new features of the relational engine for both SQL Server 2016 and SQL Server 2017. For more details, and to register, check the links below. Remember, the workshops are FREE and include both breakfast and lunch!
Last week I had a terrific opportunity to give a few SQL Server presentations in the Washington, DC area. I stayed in Reston, Virginia, and spoke at the Microsoft office in Chevy Chase, Maryland. On Tuesday evening I was able to take the metro into DC itself and spend several beautiful hours walking around the National Mall.
As I promised a couple of weeks ago, this post will show you how to look inside a page to see what is actually stored there. I’ll just be looking at data pages, and only a very basic example, just so you get the idea. But once you get familiar with looking inside pages, there are many mysteries about SQL Server data storage that you can solve on your own. I’ll mention a few of them at the end of […]
I’ve been heads-down updating Microsoft’s Hands-on Labs, originally written for SQL Server 2016 CTP3, into something that showcases not only the SP1 release of SQL Server 2016, but also some of the new SQL Server 2017 features. One of the most exciting new features is Adaptive Query Processing, not to be confused with another awesome new feature called Automatic Query Tuning! So I will not be able to continue my blog series on Clustered Indexes this week. (Don’t worry, it’s […]
In a post from two weeks ago, I told you that this week I would show you how to look inside pages to see the NEXTPAGE and PREVPAGE pointers. When I started to write this, I realized that before I can show you how to look inside the pages, I need to show you how to find out what pages to look at. So I’m going to juggle this blog schedule a bit, and this week I’ll show you how […]