Choosing the Right Analysis Services: MOLAP vs. Tabular Recording and Q&A
I hope you were able to attend my free webinar on Choosing the Right Analysis Services: MOLAP vs. Tabular on...
2014-02-17
1,745 reads
Blog Posts
Everything Is Awesome
If you don’t have kids you might not get the title of the post, it’s part of the theme song...
2014-02-17
633 reads
First Presentation Ever And My 50th Post
Last Monday was the first time I've ever presented anything. Honestly, it was the first time really speaking in public...
2014-02-17
661 reads
Get performance statistics for queries and query plans that are cached by SQL Server for faster query execution
You can use the following two DMVs to give you that information:
sys.dm_exec_cached_plans – You can use this dynamic management view to...
2014-02-17
1,055 reads
Home Workspace: Standing Desk
Ever since I worked in an office with adjustable standing desks, I’ve been thinking about getting a standing desk for...
2014-02-17
489 reads
Interest In SQL Server Seems To Be Declining?
Amusing myself for a minute at Google Trends. Anyone missing 2005?
2014-02-17 (first published: 2014-02-12)
3,556 reads
Make Your Storage Administrator Your Best Friend
That guy or gal over there going on and on about spindles and IOPS – that’s your SAN admin. For the...
2014-02-17 (first published: 2014-02-12)
1,634 reads
Presenting at the kickoff Lynchburg Va SQL User Group meeting
There’s a new SQL Server user group starting up over in Lynchburg, VA. It’s first meeting is February 27, 2014...
2014-02-17
727 reads
The CHOOSE keyword
G’day,
I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced...
2014-02-17
1,552 reads
The RedMonk Programming Language Rankings: January 2014 #programming
The RedMonk Programming Language Rankings: January 2014
As long as we have been doing our programming language rankings here at RedMonk,...
2014-02-17
898 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers