SMO stands for Shared Management Objects. It is a SQL administration API used to get meta data information from SQL Server. You may ask “Why? I can...
posts
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
MongoDB – Data Modeling Primer
We all know and have been hearing about NoSQL systems since the last year or so! 2014 is slated to be the year of NoSQL DB Platforms and Big Data...
Tips Database Developers Must Know Reading Query Plans
If you are a developer, you might have heard this from your DBA – “That query plan has some problems”. This blog would help you in understanding...
Pinging via IPv4
All PowerShell versions You can use ping.exe just like any other command inside PowerShell scripts. By adding “-4” to the command line,...
The 3Vs may require NoSQL, but data modeling is still required – by Rob Loranger
We live in an exciting time where technology is entering our lives in areas that many of us never expected. For example, at home, once unintelligent...
Knowing your Storage Basics- 2 Life Lessions for a DBA
IF_THEN_ELSE_RapidSQL
This week I’ll take a look at IF-THEN-ELSE-ELSEIF syntax. Next blog I’ll take a look at the similar CASE syntax and compare/contrast the...
CASE Syntax using Rapid SQL
Hi, Last blog we visited the IF-THEN-ELSE conditional syntax. This blog, I’d like to convert those examples using the newer CASE...
Auditing is More Than a Way to Get the Security Team Off Your Back
As a DBA, you probably look at auditing tools as a something forced upon you by the security officer. You are asked to provide continuous auditing...
Changing the Max Concurrent Service Connections for SQL Diagnostic Manager
SQL Diagnostic Manager automatically limits the number of connections that a collection service may make to an individual monitored server. This...
Top 2 Reasons Why Database Developers Take Certifications
Developers, Administrators and individuals have various levels of motivations when it comes to taking certifications. There are no set rules or ways...
5 Different Ways to Start SQL Server Services
If nothing works, then a restart works. This is the exact sentiments that an Administrator has when it comes to working with software. If you are...
Lesser Known SQL Server Backup Practices by Pinal Dave
One of the most critical responsibility of a Database Administrator (DBA) is to make sure that the databases are backed up on regular basis. What...
Tips Developers Must Know Reading Query Plans
Guest post by Pinal Dave If you are a developer, you might have heard this from your DBA – “That query plan has some problems”. This blog would help...
3 Leadership Tips That Define Success by Pinal Dave
Check out this guest post by industry expert Pinal Dave who provides 3 leadership tips to define success in any industry. Every individual has their...
Understanding Database Backup Strategies by Pinal Dave
Backup is one of the driest topics and it seems to be something non-negotiable for a DBA role. If we look into the fine prints of why someone should...
5 Common Mistakes Every Database Developer Must Avoid
Being a developer is an awesome experience – trust us. You are an architect and the builder of your dreams. A developer shapes the way the...
What Policy Guidelines are Required for your SQL Environment?
As adherence to regulations continues to be pressed upon organizations by industry and government regulators, the ability of the organizations to...
Three Facets of Metadata: Structure, Content, Meaning – by David Loshin, Knowledge Integrity, Inc.
Big Data the BuzzWord by Pinal Dave
The talk of the town these days is around Big Data if you are in a data-related domain. Most of the top CIOs are trying to get onto this bandwagon...
5 Things Developers Must Know for Working with their Databases
This article by Pinal Dave looks at some of the developer traits that one must keep in mind while working with databases Being in the databases...
Auto Replace in Rapid SQL by Dan Hotka
Hi! Dan Hotka here with more knowledge about Rapid SQL. I’ll address the auto replace feature of this tool and how you can use this feature to...
Rapid SQL Query Builder Tips and Techniques by Dan Hotka
Hi! Don’t you just love a good SQL query builder? I found this tool in Rapid SQL easy to learn and easy to produce the SQL I desired. You start it...
SQL Traffic Accelerator as a DB performance tool
We get questions from time to time from folks asking what SQL Traffic Accelerator does for DBAs since it sounds like a network monitoring tool....
Mission Impossible? Effective Database Backup Strategies
Mission Impossible? Effective Database Backup Strategies Organizations use multiple strategies when working with backups. An effective restore...
Enterprise Data Confusion – Did We Bring This Onto Ourselves? – authored by David Loshin, Knowledge Integrity, Inc.
This is the first in a series of six posts from David Loshin. Read his next post. A few years back, I had the opportunity to work with...
SQL Syntax in Rapid SQL by Dan Hotka
Abstract: Guest blog post from Dan Hotka, Oracle ACE Hi! Wouldn’t it be handy to have some Oracle documentation such as SQL syntax right at your...
3 Leadership Tips defining Success
Every individual has their own set of leaders they look up to in their daily life. I am sure each and every one reading this blog post has a number...
SQL diagnostic manager Secrets: When is a report more than a report?
SQL diagnostic manager provides many different views of the data it collects. This lets you explore all available data when diagnosing tricky...
Preparing for Data Centric Interviews by Pinal Dave
These days the fundamentals of taking an interview have not changed much. The more experienced you are, the greater the likelihood of getting into...