You pulled BUILTIN\Administrators, but are you auditing?
The conversation on local administrators having rights in SQL Server has proven to be interesting and at times entertaining. My...
2009-12-10
2,810 reads
Blogs
MDX Utility Belt of Calculations Part 3
This is part three in a series of blog posts that will help you build an arsenal of MDX calculations...
2009-12-09
1,503 reads
Electronic Health Records – What’s the Big Deal? (Part 3)
In the previous post in this series, I discussed the obstacles to implementing electronic health data systems. Because of these...
2009-12-08
1,264 reads
Fun With SQL Azure
Pinal Dave had a helpful post a few days ago about how to setup and configure SQL Azure. You will...
2009-12-08
1,844 reads
MDX Utility Belt of Calculations Part 2
This post is a part of a series of blog posts I am writing to give you a Batman-like Utility...
2009-12-07
1,703 reads
Please, Sir, I want some more… orphaned database users.
Permissions on our development servers are considerably less stringent than elsewhere with developers afforded the freedom to restore backup’s ad-hoc....
2009-12-04
2,270 reads
PASS Update #20
On the Friday at the end of the Summit we had a 4 hour Board meeting, welcoming new board members...
2009-12-03
1,286 reads
Linear Gauge Control: A Practical Use
SQL Server Reporting Services 2008 introduced several new features. One key feature was the inclusion of the Gauge Controls. I...
2009-12-02
5,427 reads
Fundamentals of Storage Systems – Capturing IO Patterns
We often take the advice given to us on forums or in articles at face value. Even though the authors...
2009-11-27
3,278 reads
Deploying Reports on Windows 7
Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate....
2009-11-27
2,033 reads
Blogs
Why I stopped using MCP for AI coding stuff
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers