Powershell Fundamentals
I’ve had the opportunity this week to take class with Don Jones (blog | twitter), PowerShell guru and author of PowerShell...
2010-06-25
2,115 reads
How much memory is each SQL Server database using?
Whilst perusing the forums over at SQL Server Central today I stumbled across an interesting question regarding how to identify...
2010-06-25
579 reads
What Has Jack Been Up to?
It has been awhile since my last post mainly because I was on a working vacation in northern New England...
2010-06-25
465 reads
Lock Pages in Memory
It is generally recommended that 'lock pages in memory' be enabled for your SQL Servers to prevent the OS paging...
2010-06-25
9,671 reads
Speaking and Presenting Tips - Bullets
I’ve heard this before, it came up in the Tufte seminar I took, and it also was something that grated...
2010-06-25
1,106 reads
The Exceptional DBA of 2010
I’ve been a judge in this contest for the last 3 years, and each years we’ve had really good finalists,...
2010-06-25
824 reads
Growing the SQL Community – Carefully
If you’re a blogger or a twitterer or a SQL speaker or PASS volunteer, you do it because you have...
2010-06-25
567 reads
My SELECT statement has hung!
One of the first roadblocks many developers run into when using SQL Server for the first time is firing off...
2010-06-24
2,644 reads
PowerShell Script to Remove Old Backups
A Twitter user asked for a script to remove old backups, and I had one I built back in February,...
2010-06-24
1,137 reads
MDX webinar
Today I did a webinar on MDX solutions. For those of you interested you can grab the slides here and...
2010-06-24
1,219 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers