Generating Test Data: Part 2 - Generating Sequential and Random Dates
Part two of this fantastic series from Jeff Moden looks at generating date data, something which can be handy for any number of testing purposes.
2012-04-25
8,282 reads
Articles
Analytic Enhancements in SQL Server 2012 - Part II
The introduction of the new analytic functions in the RTM version of SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE, with the improved over clause, greatly facilitate the analysis on ordered data sets, such as time-series data. Read on to learn more.
2012-04-25
3,686 reads
Import multiple images to SQL Server using SSIS
Sometimes we need to import thousands of images to SQL Server. This example shows how to import a list of images to SQL Server using SQL Server Integration Services.
2012-04-24
3,674 reads
2012-04-23
5,944 reads
Creating Map Drill Down Reports in SSRS - SQL Server 2008 R2
SQL Server 2008 R2 introduced several new features in the SSRS arena. In the data visualization category, we now have three additional ways to display and visualize/analyze data in the reports: sparkline and data bars, indicators reports, and map reports. Arshad Ali shows you how to create a map report with drill down functionality.
2012-04-23
3,992 reads
The Real World: Fragmented Disk and High PAGEIOLATCH Waits
This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.
2012-04-20
6,575 reads
5 Tips for a Smooth SSIS Upgrade to SQL Server 2012
Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting configurations to parameters, converting packages to the project deployment model, updating Execute Package tasks to use project references and parameterizing the PackageName property.
2012-04-20
2,971 reads
Export data from MySQL to SQL Server
Many people want to create a customized migration process using SQL Server Integration Services (SSIS), but it is hard to start working with heterogeneous databases like MySQL, Postgres, DB2, etc. Check out this tip to learn about how to import data from heterogeneous databases like MySQL to SQL Server.
2012-04-20
3,717 reads
A DDL Auditing Solution
An article discussing DDL Auditing. Learn how to track schema changes that occur in your database, enabling you to see who changed what and when. Free GUI tool included.
2012-04-19
4,673 reads
Grant Execute to all SQL Server Stored Procedures
With SQL Server 2000 no default server, database or application role was available to be able to execute all stored procedures. With SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 has this changed with all of the new security features? If not, what options do I have to grant execute rights to the needed database roles?
2012-04-19
2,470 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers