Social Media and Interviews
The requirement to disclose social media credentials to some employers has Steve Jones worried.
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.
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.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Pasar Minggu Center CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu, Kota Jakarta Selatan,...
BCA KCP Gatot Subroto CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C,...
BCA KCU BLOK A CIPETE CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers