Oracle Tips for MSBI Devs #4: Executing an Oracle Stored Proc with IN Parameters in SSIS Execute SQL Task
The first tip I published discussed how to execute an Oracle procedure with no parameters. In this tip, I will...
2012-04-03
747 reads
Powershell – Validating an IP Address
A task that I have had to do several times over the years is determine if an IP Address string...
2012-04-03
4,197 reads
Why an employer should never ask about accessing your Facebook page
There's a brilliant piece of work posted as a fictitious resignation letter that gives some scenarios as to why an employer could...
2012-04-03
1,361 reads
Which product was purchased the most? T-SQL
Suppose you had a list of product sales and were curious about which one was sold the most? It’s a...
2012-04-02
9,427 reads
Execution Plans – Table, Clustered Index and Non-Clustered Index Scan
An important operator to understand in execution plans is a scan. A Scan can be good and bad, so understanding...
2012-04-02
4,334 reads
Unsupported Features in Excel Services SharePoint 2010
Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced. There still remains a...
2012-04-02
1,503 reads
Why you *can't* provide your Facebook credentials
I know this isn't related to SQL Server, but it is related to security and privacy.
If an employer or...
2012-04-02
2,411 reads
Mirroring Support for SharePoint 2010 Databases
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are...
2012-04-02
1,238 reads
SQL Saturday #131 – Phoenix Schedule Posted
I got an email today from the SQL Saturday #131 crew with the schedule posted, showing me listed for two...
2012-04-02
943 reads
SSAS: Processing Cube Dimensions and Measures in SSMS
My co-worker showed me an easy way to process all SQL Server Analysis Services (SSAS)cube dimensions (or measures) from the...
2012-04-02
4,362 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