Azure Speed Testing
Have you ever wondered what Azure region would be the fastest to host your applications when those applications are accessed from your...
2016-05-11
1,553 reads
SQL Server – Cleaning Procedure Cache for a particular database
HI friends, most of the time we used DBCC FREEPROCCACHE to clear the procedure cache, clears the specific plan from...
2016-05-11
578 reads
Azure DocumentDB – Preparing, Loading and Querying Data
[read this post on Mr. Fox SQL blog] Recently I have been using Azure DocumentDB (aka CosmosDB) to validate several business use cases for a variety of application purposes. For those SQL DBA’s...
2016-05-10
15 reads
Azure DocumentDB – Preparing, Loading and Querying Data
[read this post on Mr. Fox SQL blog]
Recently I have been using Azure DocumentDB (aka CosmosDB) to validate several business use cases for a...
2016-05-17 (first published: 2016-05-10)
3,126 reads
Minimum Memory Grant Query Hint
This month Wendy Pastrick is the host for T-SQL Tuesday #78. This month we have to “learn something new and blog...
2016-05-19 (first published: 2016-05-10)
3,495 reads
Virtual SQL Servers, Actual Performance – PASS Virtualization VC Presentation
Tomorrow I’ll be presenting a new session for the PASSVirtualization Virtual Chapter called “Virtual SQL Servers, Actual Performance” tomorrow at...
2016-05-10
569 reads
Power BI Takeover–Webinar Recording and Q&A
Last week I did a little experimental webinar that was outside our (Pragmatic Works) norm. Instead of our traditional 1...
2016-05-19 (first published: 2016-05-10)
2,351 reads
Data Compression in SQL Server – Pros and Cons
SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU...
2016-05-10
36 reads
Getting your Cloud on
One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that...
2016-05-10
501 reads
Wait Types and Latch Classes Library
Great news from SQLSkills.”Announcing the comprehensive SQL Server Wait Types and Latch Classes Library” – Paul S. Randal http://www.sqlskills.com/blogs/paul/announcing-the-comprehensive-sql-server-wait-types-and-latch-classes-library/ It has...
2016-05-10
286 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
Practical SQL Server Development Tips for Better Database Projects
Working with SQL Server 2022 can be a great learning experience, but development tasks...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers