by XTIVIA | Dec 24, 2014 | Blog, Data Management, Databases
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...
by XTIVIA | Dec 18, 2014 | Blog, Data Management, Databases
******** 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)....
by Kathleen Long | Dec 18, 2014 | Blog, Business Intelligence, Data Management, Databases
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...
by Kathleen Long | Dec 15, 2014 | Blog, Data Management, Databases
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...
by XTIVIA | Dec 9, 2014 | Blog, Data Management, Databases
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...
by XTIVIA | Dec 9, 2014 | Blog, Databases
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...
by XTIVIA | Dec 9, 2014 | Blog, Data Management, Databases
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...
by Kathleen Long | Dec 8, 2014 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
While doing research for an upcoming add on to our standard Health Checks, I have been reviewing the different option to set in the configuration file for SQL Server Reporting Services. There are memory settings which should be addressed, especially if you are running...
by XTIVIA | Nov 25, 2014 | Blog, Data Management, Databases
Beginning in SQL Server 2005 Microsoft introduced a hidden database called the Resource Database. While it is often referred to as the resource database the actual name is mssqlsystemresource. The database contains all the system objects that are included with SQL...
by XTIVIA | Oct 16, 2014 | Blog, Databases
When a database is moved to a new server, existing database users will not have access to the database on the new server. Attempting to add the users to the database on the new server results in an error message saying the user already exists in the database. To fix...
