Pages

▼
Showing posts with label SQL Server 2008. Show all posts
Showing posts with label SQL Server 2008. Show all posts
05 November 2018

💠🛠️SQL Server: Administration (End of Life for 2008 and 2008 R2 Versions)

›
SQL Server 2008 and 2008 R2 versions are heading with steep steps toward the end of support - July 9, 2019. Besides an upgrade to upper vers...
18 June 2017

💠🛠️SQL Server: Administration (Database Recovery on SQL Server 2017)

›
I installed today SQL Server 2017 CTP 2.1 on my Lab PC without any apparent problems. It was time to recreate some of the databases I used ...
09 April 2011

💎SQL Reloaded: Table Value Constructors at Work

›
Paradoxically, the first new SQL Server 2008 feature I learned, soon after the first CTP was made available, was the use of table value cons...
30 January 2011

💠🛠️ SQL Server: Learning Resources

›
During the past weeks I found several interesting learning resources on SQL Server 2008 topics, so here they are: For those interest to ...
05 October 2010

🔏MS Office: The Limitations of MS Access Database

›
In the previous post I was highlighting some general considerations on the use of MS Access and Excel as frameworks for building applicatio...
1 comment:
13 March 2010

🎡SSIS: Percentage Sampling Data Flow Transformation

›
    One of the problems relatively difficult to address in the past was the random sampling within a SQL Server data set. Of course there is...

🎡SSIS: Aggregate Data Flow Transformation

›
    At a first look the SSIS Aggregate Data Flow Transformation doesn’t seem to be so useful given the fact that the same functionality coul...
12 March 2010

🎡SSIS: The Conditional Split Data Flow Transformation

›
In Third Magic Class I shown how to create a Data Flow Task using the SQL Server 2008 Business Intelligence Development Studio (BIDS), the ...
1 comment:
07 February 2010

🎡⌛SSIS: SQL Server to Oracle Data Export (Second Magic Class)

›
In a previous post I described the steps needed to be followed in order to export the data from SQL Server to Excel, this time I will descr...
2 comments: