A better way to find missing indexes
I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a...
2013-11-11
984 reads
My SQLRally Experience
The past week I had the pleasure to attend SQLRally Amsterdam.
I took a flight from Tel-Aviv to Amsterdam and got...
2013-11-11
788 reads
SSRS Map Layers Parameter
With the new Map control in SSRS 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If...
2013-11-15 (first published: 2013-11-11)
1,507 reads
Troubleshooting Database Mirroring Configuration
From my last post, http://coffeeandsql.com/2013/11/10/70-457-reviewer-15-implement-database-mirroring/, you were able to successfully setup a database mirroring. For further monitoring and checking if...
2013-11-11
1,066 reads
Floating Fill Factors, Automation at work!
A while back I saw a wonderful article on BrentOzar.com by Kendra Little. In the comments, Aaron Morelli mentioned that...
2013-11-11
443 reads
Veterans Day 2013
Tonight I’ll be talking again with my children about Veteran’s Day, what it means to me, and what I hope...
2013-11-11
500 reads
Second Presentation – Lessons Learned
Since my presentation at Orlando SQL Saturday seemed to go well (standing room only, all positive feedback) I submitted to...
2013-11-11
518 reads
Analysis Services Server Activity Monitor 2014 0.0.0.1 Alpha Released
This morning I am happy to announce the release of an alpha version of the SSAS Activity Viewer for SQL Server 2014 CTP2. The name has had a slight...
2013-11-11
13 reads
MDX+SSRS #34 – Query not returning results: there are good reasons
When we are learning MDX, we unavoidably have to deal with the tools we use. Adding confusions about the behaviors...
2013-11-10
3,047 reads
70-457 Reviewer #15 Implement Database Mirroring
This reviewer is part of lesson in Implementing High Availability in SQL Server 2012. This covers about 12% of the...
2013-11-10
546 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers