NOTE: This content has been updated and expanded in a whitepaper: 7 Reasons Your SQL Server Service Won't Start, by Pinal Dave ---------- After...
blog
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...
Engaging the Business Users in Enterprise Semantics – by David Loshin, Knowledge Integrity, Inc.
This is the fifth in a series of six posts on metadata collaboration from David Loshin. Read the previous post and the next post in the...
Collaboration Principles and Universal Data Models – By Len Silverston, Universal Data Models, LLC
Once upon a time, there were four expert data modelers engaged on an enterprise data modeling effort. There was also an additional expert data...
PostgreSQL Administration Made Easy
PostgreSQL let's face it! is the World's most advanced Open Source Database. It has been replacing many proprietary database systems out...
2 Things to Know About When Using Snapshot Isolation
SQL Server 2005 version introduced the concept of Snapshot isolation setting. It is one of those hidden gems inside SQL Server which is under...
SMO – SQL Server Management Objects
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...
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...