Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” to the South Florida PASS chapter on Wednesday, Nov 14th, at...
2012-11-12
1,023 reads
James Serra's Blog
SSIS: Execute SQL task vs Execute T-SQL Statement task
In SSIS there are two tasks than can be used to execute SQL statements: Execute T-SQL Statement and Execute SQL....
2012-11-08
16,341 reads
Problem copying large files to a USB flash drive?
I thought I would write a quick blog on a problem I see frequently: You try to copy a large...
2012-11-06
998 reads
Jumping from SSIS 2008 to SSIS 2012
Being a long-time SSIS 2008 developer, I have been working with SSIS 2012 for the past few months, and I...
2012-11-01
2,489 reads
SQL Server 2012: New Business Intelligence features
SQL Server 2012 has many new Business Intelligence (BI) features and enhancements. Here are my top 12, in order of...
2012-10-30
8,657 reads
Using PerformancePoint against tabular data
PerformancePoint (PPS) is typically used against multidimensional data sources (i.e. Analysis Services), but it does have the ability, albeit limited, to work against...
2012-10-25
2,884 reads
Master Data Services (MDS): Miscellaneous tips
I have come across a number of tips while using MDS. These are tips not big enough for their own...
2012-10-23
8,973 reads
Should a placement firm tell you what they are billing the client?
As a 1099 consultant, I usually use a placement firm to find a contract job. I always ask the placement...
2012-10-18
1,185 reads
MDS: Copying models and data to another server
Having recently completed a model in Master Data Services (MDS), I needed to move the model from a development environment...
2012-10-23 (first published: 2012-10-16)
5,825 reads
24 Hours of PASS videos online
All the videos for the sessions at 24 Hours of PASS (Fall 2012) are available for free. Check the session schedule for...
2012-10-12
741 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