Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
<< Previous headlines
|
Later headlines >>
SQLServerCentral.com Headlines from 2012/10/02 to 2012/10/09
Generate SSRS reports from a SSIS Package
Learn how to invoke SSRS reports from an SSIS package after the data load is completed.
Read more...
By
Ravindra Chhabria
2014/11/21 (first published: 2012/10/09)
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
20,174 reads
Getting Started with the New Column Store Index of SQL Server 2012
Column Store Index, a new feature in SQL Server 2012, improves performance of data warehouse queries several folds. Arshad Ali shows you how to create column store index, and how to use index query hint to include or exclude a column store index.
Read more...
By
Additional Articles
2012/10/09
|
Source:
Database Journal
|
Category:
sql server 2012
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,321 reads
TSQL Challenge 83 - Compare rows in the same table and group the data
The challenge is to compare the data of the rows and group the input data. The data needs to be grouped based on the Product ID, Date, TotalLines, LinesOutOfService.
Read more...
By
Jacob Sebastian
2012/10/08
|
Source:
SQLServerCentral.com
|
Category:
t-sql challenges
Rating:
|
Discuss
|
Briefcase
|
1,628 reads
Importing Data From Excel Using SSIS - Part 1
Recently while working on a project to import data from an Excel worksheet using SSIS, I realized that sometimes the SSIS Package failed even though when there were no changes in the structure/schema of the Excel worksheet. I investigated it and I noticed that the SSIS Package succeeded for some set of files, but for others it failed. I found that the structure/schema of the worksheet from both these sets of Excel files were the same, the data was the only difference. How come just changing the data can make an SSIS Package fail? What actually causes this failure? What can we do to fix it?
Read more...
By
Additional Articles
2012/10/08
|
Source:
MSSQLTips.com
|
Category:
etl
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,713 reads
Temporary Tables in Oracle and SQL Server
Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables.
Read more...
By
Press Release
2012/10/08 (first published: 2012/09/27)
|
Source:
SQLServerCentral.com
|
Category:
webinar
Rating:
Rate this
|
Briefcase
|
5,721 reads
Stairway to XML: Level 4 - Querying XML Data
You can extract a subset of data from an XML instance by using the query() method, and you can use the value() method to retrieve individual element and attribute values from an XML instance.
Read more...
By
Rob Sheldon
2014/09/03 (first published: 2012/10/08)
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
17,192 reads
Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!
Changing the structure of a very large table doesn't need to require a maintenance window.
Read more...
By
Solomon Rutzky
2012/10/05 (first published: 2011/04/26)
|
Source:
SQLServerCentral.com
|
Category:
data modeling
Rating:
|
Discuss
|
Briefcase
|
19,548 reads
Webinar: Temporary Tables in Oracle and SQL Server
Once again Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables. Will they agree on some common ground? Or will it be an out and out argument? Either way, be prepared for a lively exchange that will not only entertain, but will teach you key concepts on Oracle and SQL Server.
Read more...
By
Additional Articles
2012/10/10 (first published: 2012/09/13)
|
Source:
Redgate
|
Category:
webinar
Rating:
(not yet rated)
Rate this
|
Briefcase
|
7,216 reads
Data Quality Services Performance Best Practices Guide
This guide details high-level performance numbers expected and a set of best practices on getting optimal performance when using Data Quality Services (DQS) in SQL Server 2012 with Cumulative Update 1.
Read more...
By
Additional Articles
2012/10/05
|
Source:
Microsoft MSDN
|
Category:
data quality services (dqs)
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,670 reads
Matrix Math in SQL
Relational Datbases have tables as data structures, not arrays. This makes it tricky and slow to do matrix operations, but it doesn't mean it is impossible to do. Joe gives the Celko Slant on how to go about doing Matrix Math in SQL.
Read more...
By
Additional Articles
2012/10/04
|
Source:
SimpleTalk
|
Category:
t-sql
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,683 reads
CPU and Scheduler Performance Monitoring using SQL Server and Excel
This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.
Read more...
By
Derek Colley
2012/10/04
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
7,462 reads
SQLServerCentral Webinar Series #21 - Forgotten Rings & Other Monitoring Stories
Most common monitoring metrics are important and useful, especially over time, but they can fall short. How do you gather information to determine, for example, if you have buffer cache pressure? Register now for the free webinar. Wednesday, October 17 2012 4:00pm - 5:00pm BST
Read more...
By
Press Release
2012/10/15 (first published: 2012/09/20)
|
Source:
Redgate
|
Category:
webinar
Rating:
(not yet rated)
Rate this
|
Briefcase
|
5,395 reads
Improve Your Database Unit Testing Skills and Win Free Stuff
As the SQL Developer community grows to embrace the benefits of test-driven development for databases, so the importance of learning to do it properly increases. One way of learning effective TDD is by the use of code kata – short practice sessions that encourage test-first development in baby steps. I have a limited number of licences for SQL Test to give away free – just for practicing a bit of TDD and telling me about it.
Read more...
By
Additional Articles
2012/10/10 (first published: 2012/09/19)
|
Source:
Other
|
Category:
test-driven development
Rating:
Rate this
|
Briefcase
|
5,833 reads
Control Flow Task Errors – Level 9 of the Stairway to Integration Services
Level 9 of the Stairway to Integration Services looks at control flow tasks and error handling.
Read more...
By
Andy Leonard
2012/10/03
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
12,576 reads
SQL in the City - Seattle 2012
Start the week in Seattle off with a free day of training on Nov 5, 2012 with SQL in the City. Grant Fritchey, Steve Jones and more will be talking SQL Server in the Pacific Northwest. Join us and debate and discuss SQL Server the Red Gate Way.
Read more...
By
Press Release
2012/10/16 (first published: 2012/09/13)
|
Source:
SQLServerCentral.com
|
Category:
sql in the city
Rating:
Rate this
|
Briefcase
|
5,634 reads
Protecting the SQL Server Backup folder
I want to backup my SQL Server databases to a folder, but I want to minimize who has access to the folder. In other words, I want to make sure that members of the Windows Local Administrators group don't get to the backups without intentionally trying to bypass the security. How do I do that?
Read more...
By
Additional Articles
2012/10/02
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,219 reads
What a View
I need to create views? How many? Today? This article talks about a few issues with using views too extensively in your design.
Read more...
By
John Esraelo
2012/10/02
|
Source:
SQLServerCentral.com
|
Category:
views
Rating:
|
Discuss
|
Briefcase
|
7,699 reads
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.