Improvements with SSMS 2016
The staple of every SQL Server developer's world, SSMS has been impossible to usurp for the majority of us. However,...
2016-07-19 (first published: 2016-07-11)
3,622 reads
Monday Morning SQL Break – July 11, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. I spent the weekend with family...
2016-07-11
876 reads
Same Query, Different Servers, Different Performance. Now What?
Based on the number of times I see this question on forums, it must be occurring all the time. You...
2016-07-19 (first published: 2016-07-11)
2,430 reads
Tips to Fix Database Consistency Errors – Reported By DBCC CHECKDB
Overview
While working on SQL Server, sometimes users get stuck in annoying situations when database become inaccessible. After executing DBCC CHECKDB...
2016-07-11
6,093 reads
ETL Modularity
Imagine for a moment that you’ve built a software thing. In fact, we’ll call it Thing. You put a lot...
2016-07-18 (first published: 2016-07-11)
2,091 reads
Basic Statistics with SQL – Introduction
I was a student of statistics in school and college. I didn’t get to use much of anything I learned...
2016-07-10
679 reads
SQL Server – String_Escape function in SQL Server 2016
Hi friends, in SQL server 2016 another string function that introduced is String_Escape. This function can escape special characters within...
2016-07-10
1,525 reads
Join me for a free SQL Performance webcast on July 14th!
With less than we week away, I can say that I’m really excited to reach more people in the community...
2016-07-08
407 reads
Dallas, TX Fallen Officers Relief Fund
If you want to make a Donation to the Dallas, TX Fallen Officers Relief Fund, Please click this Link.
http://bluealert.us/
2016-07-08
401 reads
Converged virtual architectures and SQL Server licensing
Hyper-converged compute architectures, meaning clusters of physical servers with self-contained storage configured for a traditional SAN-less solution, are growing in...
2016-07-08
593 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers