XTIVIA BLOG
SQL Server Job Reporting – SQL Toolbox
SQL Server is indeed a powerfull database management system, however Microsoft has not yet included the run yourself feature as of yet. And it is because of this Database Administrators need a good set of tools to not only manage SQL Server but to also monitor what is going on...
Configuring Encrypted SQL Server Backups
******** IMPORTANT WARNING ******** DO NOT ENCRYPT ANYTHING WITHOUT FIRST TAKING BACKUPS OF ALL KEYS, BACKUP THE CERTIFICATE, AND NOTE THE PASSWORDS USED. When dealing with encryption of any kind in SQL Server it all begins with the Service Master Key (SMK). The SMK is...
Where did that folderReport go in SQL Server Reporting Services
If you are new to SSRS, or just new to the company and you have a developer promising you they deployed a report to the report server, but it had disappear from the display… Here is a hint of where you might find it. Here you have your report manager interface. The user is...
XTIVIA Dynamic Data List Visualization Portlet
Introduction A picture is worth a thousand words! This popular adage refers to the notion that a complex idea or dataset can be conveyed with just a single image. It has been observed that people relate to images quicker than just looking at tabular data. Effective...
Using Extended Events to pinpoint performance issues in SQL Server
A while back, I was tasked with using extended events to see what information could be captured to help a customer out with troubleshooting a performance issue. My first step was to see which SQL Server extended events were available on the server. With each version of SQL...
Jasperserver Scheduled Reports Not Running
You may run into an issue where several reports scheduled at the same time do not kick off. One cause for this is that the server does not have enough time to kick off all the reports before the expiry of the cut off time. A remedy for this issue is to increase the number of...
Select * from yourtable… How bad is it?
Have you heard and understand why processing a 'select * from any table' can be negative on the performance impact? While I was doing some demo prep for my upcoming PASS Summit Pre-Conference I saw this behavior at its worst. Before we jump into why this is such a...
How to connect SQL Server to an IBM UDB DB2 data source
SQL Server 2005/2008/2012: How to connect to a IBM UDB DB2 data source and query it? You will need the following to install the drivers and connect to the IBM UDB DB2 data source: Hostname of the DB2 server. Port number where the DB2 instance is listening. You can ask for the...
Executing SQL Queries Based on Time
Sometimes things should only happen at certain times. Not long ago I was asked to create a script that is triggered by an event, however, would only execute certain commands if the event occurred during a single specific time range. Creating an alert to handle the event...
Removing Oracle Registry Keys from a Windows Server
Recently for a client I had to manually remove a few failed database software installations and a couple of failed client installs from a Windows 2008R2 server. Attempts were made to try and force a 10.2.0.1 Oracle Database and client install on the server. They were able to...