Announcing the General Availability of IDERA SQL Compliance Manager 7.0
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Oracle 12 New Limits
Hi! I’ve been working on PL/SQL topics and wanted to share with you a new Oracle12 feature. Oracle12 now allows for much longer varchar2, nvarchar2, and raw fields…in both the database (tables) and in PL/SQL. The new 32K size not only lines up the...
3 Things You Didn’t Know About Black Box Trace
Black Box Trace In earlier versions of SQL Server, there have been situations where root cause analysis was never possible because data saved by SQL was just confined to SQL Server Error Logs. From SQL Server 2005, there is a default trace that runs in the background...
Data Modeling Source Control Demystified
This video replay from the Data U online conference gives you an overview of the challenges faced by organizations wanting to implement a secure Data Modeling Strategy by protecting their data modeling assets in a secure form. We shall explore on how this can be...
Top 3 Security Concepts Any DBA Must Know
DBAs understand how critical and important security is but due to other administration priorities, it can often take a back seat. When working inside an enterprise, the CIO’s are constantly worried about data theft and how to secure their environments. Most of the...
3 Tips for Technical Presentation That Every Developer Must Know
Over the past decade, I have developed and given many technical presentations that range from being cultural, based on depth of audience or on diversity in level of understanding. I have found that the art to a good presentation, is being able to adapt the content to...
Top 2 Errors When Working with Datetime Conversions
Working on universal applications has its own challenges. Often I have seen developers resort to unwanted conversions inside the database based on application needs. I am a firm supporter that databases are not the place to play with date and time conversions....
SQL Safe and AlwaysOn Availability Groups
With the release of version 7.4 in August, SQL Safe added AlwaysOn Availability Group support by taking into account the preferred replica when backing up availability replicas. The preferred replica setting is only checked when backups are done through a SQL Safe...
Adhoc Database Monitoring Made Easy
There are times when you need to get adhoc monitoring information from your databases. Well, now you can! with Embarcadero's DBArtisan Analyst Pack. The Analyst Pack, it comprises of three main components 1) Space Analyst 2) Capacity Analyst and 3) Performance...
Managing Change in Enterprise Data Modeling
It is often said that Change Management is nothing new in the IT Industry. The Data Modeling space is no different. The critical facet in enabling smooth change management is utilization of Repositories that would talk to Data Modeling client. Then, being able to...
Altering wait categories in SQL Diagnostic Manager
SQL Diagnostic Manager ships with built-in categorization of wait types which are encountered in monitoring. These categories are used on both the Query Waits and Server Waits screens and can also affect whether data is captured at all. Recently I was asked whether it...
Using Collaboration for Spreading Enterprise Knowledge – by David Loshin, Knowledge Integrity, Inc.
This is the last in a series of six posts on metadata collaboration from David Loshin. Read the previous post in the series. In my earlier blog entries, we have looked at the need for common semantics for enterprise information concepts and the need to...
Achieving Data Modeling Nirvana
Data Modeling has forever been a realm of a segment of folks that are immersed into the nitty gritty of Database Architecture from a model to Database approach. These are the individuals are that encompass, what Architects are to Buildings! So you have decided on...
Did you choose to be a DBA?
We have had this survey question and a few others on the community for a few months and thought we would share some of the results. This was a brief survey of questions to gather some insights into the SQL community of users. The 4 questions were the following: How...
Cloud phenomnenon- 3 things that make it different from on premise
Cloud – the new buzz word in the IT industry is just like the .com days in my humble opinion. Organizations have been doing the whole concept of cloud for a while now. They are using a nice term to cover-up their dependency on cloud. Be it the use of email...
Top 4 Startup Parameters DBAs Must Know
Introduction Working on a server is always something DBAs cherish. With every environment that they monitor, they want to know how applications can be optimally run on a specific server. In this constant pursuit of performance tuning, they always find unique ways of...
Black Friday Sale – Flat 30% OFF on all products
Update: Thank you all for making this campaign a huge success. We are extending this offer till Dec 1st, 23:59 PST. Many corporate users requested us to extend the offer as they require time to get official approval. Pick your copy right now! Use coupon code cm2014 to...
Big Data = Bigger Need for Data Models – by Rob Loranger
Big Data has had a great impact on science, healthcare, government and many other industries. For instance, it is now possible for scientists to map and analyze the human genome, for healthcare organizations to provide continuous monitoring of patient health, and for...
Internals of Statistics That You Were Not Aware Of
As a developer statistics is one of the important things we need to know while doing SQL Server query performance tuning exercise. Let us try to make a correlation with real world example to make sure these concepts stay in our memory. Imagine if you need to travel...
3 More Reasons SQL Server Service is Not Responding
NOTE: This content has been updated and expanded in a whitepaper: 7 Reasons Your SQL Server Service Won't Start, by Pinal Dave ---------- After our previous blog on SQL Server Service is not responding, there were few who wanted to know if there were more reasons....
SQL Server Data Modeling Made Easy
Microsoft SQL Server is slowly beginning to become the preferred platform for most organization big and small. So it would make sense in building Data Models that would be scalable for the Microsoft Data Platform? Well, you have a choice! And enter Embarcadero...