Workspace database server was not found
You might constantly see a warning message that appears like the one below when creating Analysis Services Tabular projects. It...
2012-05-08
1,090 reads
Samuel Vanga
How to execute a package from another package?
I hear you. You’ll use the Execute Package Task. This mechanism of executing one package from another is popularly knows...
2012-05-01
2,094 reads
Change Package Properties Using Parameters–SSIS 2012
In DTS, changing package properties was close to impossible (the less we talk about DTS, the better). Package configurations introduced...
2012-04-24
14,251 reads
Do You Know These Free Events?
I frequently attend a few online training events that greatly help me learn new things. Thought I would share, if may...
2012-04-23
708 reads
Why Isn’t There A Deployment Server Edition For SSIS Projects?
Andy Leonard blogged about a gotcha when creating SSIS projects using SSDT yesterday. He showed that you can use any...
2012-04-19
1,502 reads
Execute T-SQL Statement Task
I spotted a new task in SSIS 2012 – Execute T-SQL Statement Task. It executes T-SQL statements, only Transact-SQL statements against...
2012-04-17
1,165 reads
Simple Tips To Speed Up Your SSIS Data Flow
There are a few design choices that can make your SSIS packages run super fast when loading data from table...
2012-04-10
5,036 reads
SQL Roundup – 03/16-2012
Howdy! I was flying last week, and for the first time i sat facing a flight attendant. You don’t actually...
2012-03-16
839 reads
Distinct Count in Analysis Services
Business users are often interested in finding distinct counts in addition to other aggregations. They may want to know the...
2012-03-14
1,216 reads
SQL Roundup – 03/09/2012
Welcome to another week of SQL Roundup. Just in case you missed, SQL Server 2012 was released this week and...
2012-03-09
729 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers