SQL Server Internals: Tempdb Part 2 SQL Server has been around for over 30 years, and I’ve been working with SQL Server for almost as long. I’ve seen a lot of changes over the years (and decades!) and versions of this incredible product. In these posts I’ll share with you how I look at some […]
Read More
Times have changed for the SQL Server® DBA. Not so long ago, SQL Server was a Windows-only application, and the SQL Server DBA didn’t really need to worry about other platforms. The toolset needed to manage SQL Server was well known and had been around for a quite a while. That all changed with the […]
Read More
SQL Server® has been around for over 30 years, and I’ve been working with it for almost as long. I’ve seen a lot of changes over the years (and decades!) to this incredible product. In these posts, I’ll share with you how I look at some of the features or aspects of SQL Server, sometimes […]
Read More
A lot of different factors go into SQL Server® performance, which can make troubleshooting performance problems difficult. However, there are many common SQL Server deployment mistakes that can impact SQL Server performance. In this presentation, you’ll learn about some of the common mistakes that can degrade SQL Server performance and how to avoid them. You’ll […]
Read More
Since the release of SQL Server® 2017 on Linux®, DBAs have been waiting for a native release of SQL Server Management Studio (SSMS) on Linux. At this point, Microsoft has stated that they have no plans for a native Linux version of SSMS. However, they have just released a preview version of SQL Operations Studio, […]
Read More
In Part 1 of this series, we looked at a brief description of in-memory tables, the syntax for creation, and benchmarked data insertion and update. Part 2 will continue with a concentration on the SELECT statement for benchmarking, and also touch on in-memory stored procedures. In-Memory SELECT Performance For the purpose of the following […]
Read More
I’ve always been fascinated by performance, and my careers and hobbies have shown this. I’ve been a rocket scientist, sports car driver, USAF fighter pilot, and now a SQL Server® geek. When in-memory tables first came out in SQL Server 2014, I was highly intrigued by the prospect of something that did not require the […]
Read More
What would you do if someone called your baby ugly? How far would you go to rekindle an estranged relationship with your wife, daughter, husband, or son? Have you ever suddenly realized that someone you knew you once loved may not be all that any longer? Sure, you go through the motions, but your heart […]
Read More
Making sure that database applications are running optimally is one of the biggest problems faced by DBAs on an ongoing basis. DBAs are constantly monitoring and managing performance while also reacting to end user complaints. When users have to wait longer than they are used to waiting for their applications to respond it is understandable […]
Read More
With the improvements in the Windows Server 2012 implementation it’s now feasible to install SQL Server on SMB network shares. This applies to both standalone SQL server installations as well as clustered SQL Server installation. Before that, it was possible with the use of trace flag 1807 but this was never a desired configuration. However, […]
Read More