SSAS Reporting Action with Date Parameters
Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want...
2014-01-22 (first published: 2014-01-20)
2,259 reads
NJSQL User Group Presents In-Memory OLTP for SQL Server
If your local to the NY/NJ area, please see tomorrow night's agenda for SQL Server 2014 In-Memory OLTP feature! Microsoft...
2014-01-20
1,023 reads
Reliably Drop A Database With CLR Stored Procedure
After I read Greg Low’s post and my initial try, I kept on thinking that I need to come up...
2014-01-20
437 reads
Reliably Drop A Database With CLR Stored Procedure
After I read Greg Low’s post and my initial try, I kept on thinking that I need to come up...
2014-01-22 (first published: 2014-01-20)
2,361 reads
SQL Saturday Nashville Wrapup
What a terrific week! I’m have a great start to 2014! Yesterday and today I had the opportunity to present...
2014-01-19
548 reads
Gathering Business Intelligence Requirements
Questions to Ask when Gathering Business Intelligence Requirements
When starting any project requirements are the key to being successful. Business intelligence...
2014-01-18
1,016 reads
Reblog: January 10 to January 16
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-01-17
786 reads
One More Minute
Ever say “one more minute” while working on something and then realize 30 minutes have gone by? My daughter has...
2014-01-17
648 reads
Friday Followup For January 17, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-01-17
404 reads
DBA: Guardian of the Data
I was asked recently by Idera to take a look at the things that could cost a DBA their job....
2014-01-17
1,179 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