Knee-Jerk Wait Statistics : PAGELATCH
Paul Randal adds another chapter to his thorough series on knee-jerk wait statistics, focusing on the often-misunderstood PAGELATCH_XX waits.
2015-11-05
5,574 reads
Additional Articles
SQL Server Reporting Services General Best Practices
Ghanesh Prasad discusses 12 best practices any developer or DBA should follow when working on a SSRS project.
2015-11-04
5,092 reads
So You Need to Expose JSON Endpoints
Even the most experienced programmers can be caught out unawares by software they've used for years without trouble. Dino Esposito explains why and how the JSON method in an ASP.NET MVC controller class suddenly started to cause an exception on a production server, and how he fixed the problem.
2015-11-03
2,813 reads
Webinar: Database version control - optional or required?
Join Justin Dearing and Elizabeth Ayer to hear about some of the key challenges of database version control, and why it's only a matter of time before it's as essential as good backups and high performance.
2015-11-03 (first published: 2015-10-13)
8,620 reads
A Skills Roadmap for DBAs in the Cloud Era
Cloud computing is on the move. Slowly but surely, businesses are transitioning more and more key pieces of infrastructure to the cloud in order to take advantage of cost, flexibility and agility benefits. And databases, the heart and soul of all applications, are the most critical component of this transition. Gerardo Dada explores the topic.
2015-11-02
3,769 reads
10 New Features Worth Exploring in SQL Server 2016
Greg Larson gives an in-depth look at ten of the new features you can expect from SQL Server 2016.
2015-10-30
8,121 reads
Top 10 Most Common Database Scripts
What are the scripts that a working DBA uses so often that they become part of the 'muscle memory'? Grant Fritchey asked the question on the forums of SQL Server Central. From the large response, Grant was able to pick out the ten most popular T-SQL commands, scripts, or fragments. It seems as if, despite the range of tasks we do, there are some common tools we use.
2015-10-29
9,303 reads
Using Power BI in a Hybrid Environment
This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores.
2015-10-28
2,633 reads
Simple Mathematical Formulas using the M Language
The Power BI desktop designer is a great tool; however, the hardest part of any Business Intelligence project is gathering and formatting the data into reportable datasets. John Miner explains how having a deeper understanding of the M language will help a BI developer in cases where the menus can not.
2015-10-27
2,906 reads
The Complete Guide to PowerShell Punctuation
It is the punctuation, the strange dollar signs, brackets and parentheses that bewilder anyone learning PowerShell. Add to that the aliases and you can bewilder everyone. The punctuation is essential, so here is the the complete PowerShell wallchart and guide to Powershell Punctuation. Thanks to Michael Sorens, PowerShell need no longer be perplexing.
2015-10-26
3,688 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers