PASS SQL Saturday Events: December 2014
DateEventDecember 6 SQLSaturday #359 – Istanbul 2014December 6 SQLSaturday #351 – Lima 2014December 6 SQLSaturday #347 – Washington DC 2014December 13 SQLSaturday #356...
2014-11-15
574 reads
How to fix: Visual Studio 2012 startup problem: The 'HDIProjectPackage' package did not load correctly.
After installing Community Edition of VS2013 with some additional packages i've noticed that my VS2012 starts failing to start with...
2014-11-15
3,822 reads
MDX #45–Find all the Calculated Sets and Their Calculation Scripts
Now we know how to find all the calculation scripts in a cube by querying the DMV $SYSTEM.MDSCHEMA_MEASURES.
MDX #43–Find a MDX...
2014-11-21 (first published: 2014-11-14)
5,740 reads
SQLCMD and SET QUOTED_IDENTIFIER
Let’s talk about something simple today. You might already be knowing this, but if you haven’t seen/noted this before then...
2014-11-20 (first published: 2014-11-14)
8,054 reads
How to replace a specific string from a large string with Write feature ? TIP #72
This is very interesting feature and I recently come to know this awesome feature.
Lets understand this by an example below...
2014-11-14
353 reads
Update all SSRS reports to apply consistent header / footer on demand
Teaching good old SSRS a new trick…
Background
Not too long ago I had a client with a very simple, yet practical requirement: they...
2014-11-14
1,296 reads
Memory consideration (Windows + SQL)
We all know that with the latest Windows 2012 R2 and SQL 2014, even with the standard edition, it can...
2014-11-14
422 reads
Reblog: November 7 to November 13
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-11-14
413 reads
12 Things To Check With SQL Server To Prepare For Winter
Reading Time: 8 minutesWinter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts...
2014-11-14
651 reads
12 Things To Check With SQL Server To Prepare For Winter
Winter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts are predicting massive...
2014-11-14
1,082 reads
Blogs
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
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