Small Management
This editorial was originally published on June 21, 2007. It is being republished as Steve is traveling. Today we take a poll on administration and management from devices smaller than a laptop.
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.
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.
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.
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.
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?
Social Data Analysis
Today we have an editorial originally published on June 24, 2007. It is being republished as Steve is traveling. IBM has done some work to help people analyze sets of data with new visualizations.
Stairway to SQL Server Replication - Level 10: Troubleshooting
The final level of this Stairway takes you through how to identify and fix common errors.
Microsoft SQL Server 2012 - (SQLPS)
Prior to SQL Server 2012, Microsoft provided a mini shell called sqlps.exe; in SQL Server 2012, SQLPS exists in the form of module. Learn how to make use of the SQLPS module and how to access SQL Server components and features via Windows PowerShell.
PASS Data Architecture VC presents Todd McDermit on Data Warehouse Dimension Processing with SSIS from Simple to Complex
On Thursday April 19th 12PM noon Central, Todd McDermid will discuss "SSIS components for Data Warehouse Dimensional data processing".
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers