PerformancePoint ‘Named Set’ Filter
PerformancePoint provides several options to create filters. One of the options available is ‘Named Set’. Within SSAS cubes we can...
2013-03-01 (first published: 2013-02-25)
2,130 reads
Blog Posts
Reblog: February 22 to February 28
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-01
936 reads
Something for the Weekend – SQL Server Links 01/03/13
It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server...
2013-03-01
1,081 reads
SQL BLOG: First Occurrence Of Character In a String
Scenario:
We need to find the first occurrence of character ie non numeric data in the string without using the built...
2013-03-01
2,809 reads
SQL Server Events in the UK – March 2013
Welcome to the first of what I plan to be a regular recurring theme. Right here I will list out...
2013-03-01
777 reads
When was the last successful backup?
What is the fastest and perhaps easiest way to find the last successful database backup?
Just right click on the Database...
2013-03-01
392 reads
Windows 8 – First Impressions on a Desktop
I bought a new (to me) desktop recently to replace my aging hardware. I’ve had a quad core machine, but...
2013-03-01
1,047 reads
YYYYMM Math
I had a project recently where I had to do math on a number that represented a date, YYYYMM.
For example,...
2013-03-01
693 reads
"An item with the same key has already been added."
In SQL Server Reporting Services, when adding a new dataset to a report, you may see an error that looks...
2013-02-28
8,623 reads
A Month of PowerShell – Day 21 (Backups)
Welcome to Day 21 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-28 (first published: 2013-02-21)
2,615 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers