SQL Server 2008 R2 SP1 CU6 Released
This morning, Microsoft released SQL Server 2008 R2 SP1 CU6, which is Build 10.50.2811.0. This Cumulative Update lists 20 fixes...
2012-04-17
2,752 reads
Let’s Meetup [Updated]!
I have a confession to make. I like to meet people who also work with SQL Server. There are so...
2012-04-17
705 reads
TDS Endpoints: SQL Server’s “Listener”
In the land of Oracle, if you want to prevent user access to your database, you stop the listener. Without...
2012-04-17
1,762 reads
Execute T-SQL Statement Task
I spotted a new task in SSIS 2012 – Execute T-SQL Statement Task. It executes T-SQL statements, only Transact-SQL statements against...
2012-04-17
1,204 reads
Book Review: American Icon: Alan Mulally and the Fight to Save Ford Motor Company
American Icon: Alan Mulally and the Fight to Save Ford Motor Company ($18 at Amazon) was a good read, with...
2012-04-17
800 reads
Choosing the Right Microsoft Reporting Technology Part 5: Power View
In part five of this on going series about choosing the right reporting tool we will discuss the newest of...
2012-04-17
1,636 reads
ColoradoSQL–April 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-04-17
845 reads
Where Have all the DBAs and DB DEVs Gone?
Last week the SQL community and in particular the blogosphere, was buzzing with interest noise following the Microsoft Learning site...
2012-04-17
894 reads
How to use Report Builder 3.0
I did a webinar during the 12 days of 2012 on how to use Report Builder 3.0. In this webinar...
2012-04-16
1,474 reads
Creating a User without a Login – Contained Databases
In SQL Server 2012, we have a new feature: partially contained databases. In a previous post, I showed how to...
2012-04-16
12,437 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