Running a script on multiple servers
One of my favorite features of SQL Server Management Studio (SSMS) is the ability to run a script on multiple...
2012-03-02
2,734 reads
Want to write for Microsoft?
Edit: The group I’m speaking to is the Content Team, not the Books Online (BOL) team!
Edit: Updated with FAQs and...
2012-03-02
733 reads
Re-blog – February 24 – March 1
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-02
472 reads
SQL Server 2012 (“Denali”): Database Recovery Advisor
Database Recovery Advisor is a new feature in SQL Server 2012 that introduces significant user experience enhancements to the ways DBAs...
2012-03-02
1,048 reads
A Script A Day - Day 29 - The Importance of Being Idle
Today’s script is also one I used in my migration on Wednesday. It again uses string manipulation to generate a...
2012-03-02
537 reads
A Script A Day - Day 28 - String Manipulation
Today’s script is one that I used earlier this week. On Thursday I migrated a server from SQL Server 200...
2012-03-02
538 reads
Clearing Job Notifications - HELP!
I have inherited a SQL 2005 server with SQL Agent job notifications in place, and a request to clear the...
2012-03-02
921 reads
PepsiCo Women’s Inspiration Award Winner – If I can do it, so can you…
An inspiring story. A hard one, and one that comes from someone with talent.
I like seeing stories like this, and...
2012-03-02
1,017 reads
Introducing SQL Roundup
Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll...
2012-03-02
994 reads
MDX SSRS Parameter Values
<rant> One of the most frustrating things about working with the Microsoft BI Stack is after you go through all...
2012-03-02
9,352 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