Rolling your own index lookups
Over the past few weeks, I’ve been training developers in what they really need to know about SQL Server to...
2011-08-01
1,342 reads
Blog Posts
SQL Server “Denali”: Project Apollo
Project Apollo is a new feature in CTP3 of SQL Server Denali that enables a new columnstore index that offers...
2011-08-01
1,667 reads
Telecommuting - Hype or Happening? - Making the Case to your Higher-ups
We've seen the argument before, that working from home, actually increases productivity. This is one of the major cases in...
2011-08-01
2,540 reads
We Have Another New Contributor…
I’d like to introduce you all to my friend Ian Treasure who has kindly volunteered to write some posts and...
2011-08-01
611 reads
PowerPivot – Creating Hierarchies
Hierarchies are one of the long awaited features that will now be available in the latest version of PowerPivot. Hierarchies...
2011-07-31
4,840 reads
Spoke at #sqlsat81
I presented two sessions this weekend in Birmingham AL at SQL Saturday 81. I was in the first slot of...
2011-07-31
1,451 reads
Lookup functions in SSRS 2008 R2 - III
Introduction
This is the final post to discuss the last Lookup function Multilookup(). The other two – Lookup() and LookupSet() have already...
2011-07-30
11,351 reads
SQL Saturday #85 Orlando
SQL Saturday #85 is quickly approaching. It will be held in sunny Orlando, FL so if you live in the...
2011-07-30
2,054 reads
The Good, the Bad and the Ugly SQL Cursor types
T-SQL cursors are generally bad approach and are often misused. In today’s world of correlated subqueries, CTE’s, recursive CTE’s, ranking...
2011-07-30
1,937 reads
Big Numbers
What had me reflecting on numbers was an article in the Financial Times (Conduit of Contention if you can find...
2011-07-29
1,497 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers