SQL Server “Denali”: New Certifications
According to the post SQL Server “Denali” Experts–We Need You! that asks for your feedback on the Microsoft certifications for the...
2011-07-20
1,714 reads
James Serra's Blog
SQL Server “Denali”: Details on the next version of SSIS
CTP3 of SQL Server Code Name “Denali” was made available recently, and it offers a lot of new features for...
2011-07-18
1,232 reads
SQL Server “Denali”: Installing SSAS Multidimensional vs Tabular Mode
As I play with the recently released CTP3 of SQL Server Denali, I wanted to point something out about installing SSAS, since...
2011-07-15
1,908 reads
SQL Server 2008 R2 Service Pack 1 Released
Microsoft has released the final build of SQL Server 2008 R2 SP1. It includes fixes from SQL Server 2008 R2 RTM Cumulative Updates 1 through...
2011-07-14
1,349 reads
SSIS package taking forever to load when you open it?
When you open a SQL Server Integration Services (SSIS) package in SSIS Designer or add components to a package, SSIS...
2011-07-13
2,576 reads
SQL Server “Denali”: CTP3 now available!
CTP3 of SQL Server Code Name “Denali” was made available for download this morning. You can download the 32-bit and...
2011-07-12
2,238 reads
Environment variable in SSIS not being recognized
If you are using environment variables in SSIS when using package configuration, chances are you will run into a situation...
2011-07-11
1,937 reads
Free SQL Server 2008 R2 Business Intelligence Training Course
If you are new to Business Intelligence (BI) and learn best by watching videos and “playing”, then this course is...
2011-07-08
5,205 reads
SQL Server Analysis Services Operations Guide published
Another whitepaper to add to your “to read” list: SQL Server 2008 R2 Analysis Services Operations Guide
This white paper describes...
2011-07-06
1,036 reads
SQL Server “Denali”: Project Crescent
Project “Crescent” is a new interactive data exploration and visual presentation experience coming in the next version of SQL Server, code-named “Denali”. It will...
2011-07-05
1,365 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