by XTIVIA | Jan 20, 2015 | Blog, Data Management, Databases
Tip # 2 – Check your Security Top 10 Tips for SQL Server Performance and Resiliency This article is part 2 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors I...
by XTIVIA | Jan 20, 2015 | Blog, Data Management, Databases
Oracle subscription for node down event pending. You will sometimes see this message on an Oracle database from 10g forward as that is when the default subscription to the Oracle Notification Service(ONS) was introduced. In a single instance environment it is...
by XTIVIA | Jan 19, 2015 | Blog, Data Management, Databases
Often enough I have to mess around with shell scripts and even more often I have to spend a considerable amount of time debugging scripts. Though whenever I find myself having to debug a script I often use this little bit of code to help me step through my code to...
by XTIVIA | Jan 12, 2015 | Blog, Data Management, Databases
Tip Number 1 – Check your Backups Top 10 Tips for SQL Server Performance and Resiliency I have been a consultant for a number of years and lost track of how many different servers I have worked on a long time ago. However, today as sit down and think, it...
by XTIVIA | Jan 5, 2015 | Blog, Data Management, Databases
Often the first stop in troubleshooting is taking a peek at those logs. SQL Server Error logs can provide a lot of useful information and when it comes down to troubleshooting a SQL Server problem one cannot go wrong by cracking open the log files. The SQL Server...
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...
