SSRS report rendered in EXCELOPENXML then something went missing
Recently I had been requested by a client to look into one of their SSRS reports issues. They had one...
2014-10-16
3,120 reads
Rayis Imayev
- Website: http://datanrg.blogspot.com/
SSIS Pivot makes you stronger
At the recent Toronto SQL Server User group meeting Michal J Swart (@MJSwart) gave a good presentation based on 10...
2014-10-15
894 reads
SSRS report: Multi-value parameter going after Data-driven subscription
It is always good to enrich SSRS reports with multi-value parameters; users have more flexibility to combine different reporting scenario...
2014-09-03 (first published: 2014-08-27)
27,632 reads
Power View report migration from SharePoint 2010 to 2013
With the latest changes to the Microsoft Power BI and ability to create Power View reports within an Excel file...
2014-07-31 (first published: 2014-07-24)
8,214 reads
SSRS report subscription: Fire Event from SSIS package
My previous two posts about SSRS reports being deployed to a SharePoint site along with their subscription didn't stop me...
2014-07-29 (first published: 2014-07-22)
14,452 reads
SSRS reports in SharePoint mode, Saga #2: PowerShell generates email subscriptions
Life is full of opportunities, it only takes to notice and use them. About 3 months ago I wrote a...
2014-07-07
2,776 reads
And I wonder, where that column is?
I wouldn't have decided to write this post if I didn't see my boss at one of my previous jobs...
2014-04-30
1,702 reads
PowerShell, help me to publish my SSRS reports to SharePoint!
Every time when I heard the word 'PowerShell' it was just like a call to Terra Incognito, you know nothing...
2014-03-18 (first published: 2014-03-09)
8,442 reads
SQL Server and MS Access 2013 are still friends in Azure!
With more and more features being added to the SQL Server I started thinking that its friendship with MS Access...
2014-02-13
2,172 reads
My Visual Studio crashed and I didn't know why!
Recently I had to develop a simple ETL task with the help of SSIS to transfer an Excel data file...
2014-01-31
1,299 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers