The Art of Performance Tuning
Performance tuning often gets called an art as people feel that a certain knack or innate talent comes into play....
2014-09-04 (first published: 2014-08-28)
8,789 reads
Blog Posts
Top ADO.Net Interview and General FAQs
1. What is ADO.Net?
ADO.Net is set of components (classes) that are used to access data based on disconnected dataset and XML.It...
2014-09-04
1,278 reads
Why You Should Go to SQL Saturday
SQL Sat Puerto RicoHello Dear Reader! Soon SQL Saturday #318 in Orlando FL will be here. The SQL Community does...
2014-09-04
875 reads
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
786 reads
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
3,047 reads
Audit Webinar Tomorrow (4 September 2014)
I will be given a webinar on how to audit SQL Server through MSSQLTips.com.
Webinar Registration Link
The abstract:
Don’t become a statistic....
2014-09-03
507 reads
Automated Source Control: A Librarian For Your Database Objects, Part 3
As I mentioned earlier, we use Perforce as our source control package, so all of the scripts presented here are...
2014-09-03 (first published: 2014-08-27)
7,370 reads
Off to Flowcon 2014
With all of the work on a deployment pipeline and Continuous Integration (CI) and Continuous Delivery (CD) I’ve worked on,...
2014-09-03
811 reads
PASS Summit 2014 Announcements
In case you do not receive the PASS connector, here are some announcements for this year’s summit on Nov 3rd...
2014-09-03
817 reads
Restoring Toggle Results Window as Ctrl+R in SSMS
Recent versions of SQL Server Management Studio have unmapped Control+R as the toggle for the Results window in a typical...
2014-09-03
1,871 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...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Forums
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
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers