Dynamic Sorting in SSRS
Introduction
Many times while developing any report we come across a situation where we need to SORT the TABLE columns or...
2011-12-30 (first published: 2011-12-26)
21,210 reads
SQL Server A to Z – YEAR
SELECT 'Happy '+ DATENAME(dw, GETDATE())Welcome to the penultimate installment of SQL Server A to Z (it’s not often I get to...
2012-01-02 (first published: 2011-12-26)
2,319 reads
Twas The Week After Christmas....
Holiday Greetings to all you DBA's and SQL Server professionals! This blog goes out to all of you who are on-call...
2011-12-26
2,286 reads
Modifying SQL Server Synonyms – this time with Powershell
So, how do you recover from the Holidays? Hot Cocoa by the fire? Relaxing evening with your spouse watching an...
2011-12-26
1,623 reads
SQL Server – How to identify service pack installed
Identifying current service pack installed for SQL Server can be difficult if you don’t know which command to use! Most...
2011-12-25
2,799 reads
SQL Server 2012 RC0 and beyond
Since the stable and mainly feature-complete versions of SQL Server 2012 have been available, I have been heads-down on multiple...
2011-12-25
749 reads
Top 10 SQL Server Posts for 2011
2011 is nearly over. It’s time to list the Top 10 viewed SQLServer-DBA.com posts for the year , based on Views.
System...
2011-12-24
831 reads
SQL Server 2012 (“Denali”): New Security Features
SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups,...
2011-12-23
1,975 reads
Re-blog – December 16 – December 22
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-23
531 reads
SQL Saturday #104: Colorado Springs
January 8th, 2012 will be the first SQL Saturday for 2012. 104 SQL Saturdays is an amazing number for our...
2011-12-23
763 reads
Blogs
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
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,...
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