Run real-time SQL tracing at application level with a ORM….
If you ever need to know exactly what dml your application is running as you have an ORM as your...
2013-07-08
475 reads
Blog Posts
SQL Server: Part 5 : All About SQL Server Statistics : How to Detect outdated Statistics ?
In the last post, we have discussed about the auto update statistics threshold and concluded that auto updated statistics threshold are good...
2013-07-08
1,636 reads
Unlocking “Lock Pages in Memory” Option
Consider this scenario; Your production database server is new and with super configuration of 32 CPUs, 64G RAM, SAN Storage,...
2013-07-08
347 reads
Ready, Set, Go! Upcoming Speaking Events
Huge sandwich from recent trip to downtown Chicago
First, I want to acknowledge that I’ve been pretty quiet on here lately....
2013-07-07
735 reads
So how was your weekend?
It’s Sunday night now, weekend is almost over and was it just a few moments ago that it was Friday?...
2013-07-07
329 reads
SQL Server Quickie #6 – THREADPOOL Starvation
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Today I have...
2013-07-07
1,552 reads
Installing Microsoft Hyper-V 2012 on VMware ESXi 5.1
For a weekend project, I’m installing Hyper-V 2012 in my home lab. I was having troubles getting Hyper-V installed on...
2013-07-06
894 reads
Create a Named Set with all but one Member in MDX – SSAS
I was trying to create a Named set in SSAS 2008 using the MDX calculations. I wanted to include all...
2013-07-05 (first published: 2013-07-01)
1,694 reads
Getting Started With SQL Server 2014 the Easy Way
You know you want to at least take a look at the new Client Technology Preview (CTP) of SQL Server...
2013-07-05 (first published: 2013-07-01)
2,161 reads
Maidenhead SQL Server User Group – 9th July with Alex Whittles and John Martin
Another month and another evening of top quality free SQL Server goodness for those living/working in the Maidenhead area of...
2013-07-05
700 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