Ten Years and Counting …
On March 8, 2014, I reached ten years of service at Magenic Technologies. When I started in 1999 (don’t do...
2014-03-14
813 reads
Blog Posts
Uniquifiers: all rows or the duplicate keys only?
Some days ago I was talking with my friend Davide Mauri about the uniquifier that SQL Server adds to clustered...
2014-03-14
894 reads
Virtual SQL Playground Adventure: Building The Virtual Environment
Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual...
2014-03-14 (first published: 2014-03-03)
3,673 reads
:CONNECT in SSMS
Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...
2014-03-13
1,446 reads
Index Fragmentation
So you’ve setup a bunch of indexes in your database to tune the queries coming in. They’re all running much...
2014-03-13
2,477 reads
Quick tip: Querying AD with xp_logininfo
We all have blind spots in our knowledge. We don’t know they are there and when we are thinking through...
2014-03-13
739 reads
Real-time query access with PDW
The Parallel Data Warehouse (PDW) officially supports Analysis Services as a data source, both the Multidimensional model (ROLAP and MOLAP modes) and...
2014-03-13
1,550 reads
Some Notes On Writing A Question Of The Day
I wrote Write The Perfect Question (Of The Day) last week and yesterday dropped a note here about my latest...
2014-03-13
469 reads
Speaking at Midlands PASS Chapter tonight
The Midlands PASS Chapter is an official PASS (Professional Association for SQL Server) chapter located in Columbia, SC. It’s free...
2014-03-13
461 reads
SSRS Top N and Bottom N reporting with Duplicates
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-13 (first published: 2014-03-03)
2,966 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers