SQL Saturday #79 South Florida
SQL Saturday in South Florida is quickly approaching in just 2 short weeks. As usual, if you are in the...
2011-08-03
649 reads
Blog Posts
SQL Server 2011 “Denali”: Get T-SQL query metadata without executing it
SQL Server 2011 “Denali” introduces couple of new procedures which enable you to read query metadata without executing it. Previous...
2011-08-03
1,020 reads
SSAS errors: DefaultMember(Measures,Measures) (1, 1) The ‘[xxx]‘ member was not found in the cube when the string, [Measures].[xxx], was parsed.
When attempting to browse an Analysis Services cube you may be presented with the following error message:
DefaultMember(Measures,Measures) (1, 1) The...
2011-08-03
996 reads
Updating Views
Written by Ian Treasure
Gethyn recently posted on deleting from a view. He used a common situation where several tables are...
2011-08-03
10,133 reads
August Monthly SQL Server Checklist
First day of the month and first Monday of the month. The list is coming out a bit late due...
2011-08-02
786 reads
Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions
SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than...
2011-08-02
617 reads
Bad Network Performance? Check the TCP Chimney Offload/Receive Side-Scaling/Network DMA Settings
We recently ran into a case where connecting to a Windows Server 2003 server with SQL Server installed on it,...
2011-08-02
15,668 reads
Fitting In-The Editorial
This editorial I wrote ran on SQLServerCentral a couple weeks back and generated a lot of comments, and more than...
2011-08-02
300 reads
I deem September 2011 – SQL Server Month
If you haven’t visited the SQL Saturday website you should take a look. There are SEVEN events planned during September around...
2011-08-02
556 reads
LAG’n’LEAD – New T-SQL Features in SQL Server Denali CTP3
Are you tired of doing self joins, just to get the value of a column in the previus/subsequent row, or...
2011-08-02
1,710 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