SSDT – Installation confusion
SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, meaning it has a suite of Visual...
2012-04-13
11,528 reads
I am a Linchpin Team Mate
Linchpin People, LLC is an organization led by Brian Moran and Andy Leonard with Mike Walsh and Robert Pearl as...
2012-04-13
1,027 reads
Querying Microsoft SQL Server 2012 Beta exam (70-461 / 71-461) – My Thoughts
Well I’ve now done the final SQL Server 2012 exam I managed to get a slot booked for. The Querying...
2012-04-13
3,517 reads
SQLRally at Starbucks Networking Event
Craig Purnell and I are hosting an informal networking event at SQLRally this year on Friday May 11th from 7-8:30...
2012-05-04 (first published: 2012-04-12)
1,744 reads
SQL server: Deciphering Wait resource
When I was working with couple of frequent blocking issue in our live server, I have noticed different types of...
2012-04-12
32,627 reads
PowerShell and T-SQL: Implementing UNION, INTERSECT, and EXCEPT
I’ve been thoroughly enjoying my experience this year with the Scripting Games. This is the first year I've competed and...
2012-04-16 (first published: 2012-04-12)
6,776 reads
Re-thinking security for customer service
This morning my son woke up to find his eBook reader frozen. It wouldn't unlock. It was fully charged (the...
2012-04-12
1,280 reads
Microsoft Brings Back the Old Certification Acronyms MCSE and MCSA, starting with SQL Server
The new certification structure has been announced by Microsoft and the changes are rather broad and sweeping. MCITP is gone....
2012-04-12
1,973 reads
SQL Server 2012 RTM Cumulative Update 1
Microsoft has released SQL Server 2012 RTM Cumulative Update 1, which is Build 11.0.2316.0. I count 55 fixes in the...
2012-04-12
2,283 reads
Better Living Thru Powershell: Update Statistics in Parallel
As part of a project I’m currently involved with, we’re migrating a database to SQL Server 2008 and performing some...
2012-04-17 (first published: 2012-04-12)
2,855 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