Syncing your calendars
I have a desktop computer, a laptop, and a iPhone. I frequently add meetings to my Outlook calender on my...
2012-05-30
1,970 reads
James Serra's Blog
Columnstore indexes and memory
Columnstore indexes are built and processed completely in memory. You will receive an out-of-memory error if you do not have enough memory...
2012-05-23
1,459 reads
What happens when a SSAS Tabular model exceeds memory?
If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database...
2012-05-24 (first published: 2012-05-21)
3,781 reads
Being careful in SSAS to not make a cube/dimension unprocessed
A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes...
2012-05-21 (first published: 2012-05-16)
3,143 reads
Data Warehouse vs Data Mart
I see a lot of confusion on what exactly is the difference between a data warehouse and a data mart....
2012-05-14
30,939 reads
Fast Track Data Warehouse Reference Guide for SQL Server 2012
I have previously blogged about Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference...
2012-05-02
2,671 reads
SSAS File System Error
I received this error the other day when trying to process a particular SSAS cube:
Error 18 File system error: The...
2012-04-30
2,908 reads
SQLSaturday in Houston Presentation
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at Houston SQLSaturday.
Here is the PowerPoint presentation: Scaling...
2012-04-22
928 reads
SQL Server 2012: Certification Upgrade Info
As a follow-up to my SQL Server 2012: New Certification Info, Microsoft Learning has announced the certification tracks for the SQL Server...
2012-04-18
7,448 reads
SQLSaturday in Houston
I will be speaking at the Houston SQLSaturday this upcoming Saturday (April 21st). Below is info on my session, which...
2012-04-16
630 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
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