Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Database Weekly Rss

<< Newer    Items 21 to 40 of 379    Older >>
 

Mongo Jumbo Backups

Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.   Read more...
By Tony Davis 2014/02/03 | Source: SQLServerCentral.com | Category: database weekly
Rating: (not yet rated) |  Discuss |   Briefcase | 66 reads

SQL Best practices, policies and code-smells.

Phil factor warns against taking SQL Coding 'best-practices' too much at face value. They can, at best, assist in reviewing code, and at the worst they can prevent the developer from finding the best solution.  Read more...
By Phil Factor 2014/01/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 330 reads

Redundant Redundancy

When DBAs too often find themselves trading sleep for Megabytes, it's time for a different approach to detection and alerting of disk space problems. So argues Rodney Landrum.  Read more...
By Rodney Landrum 2014/01/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

The Art of Performance

Tuning a SQL Server instance and improving the way it performs is a complex task that many people struggle to complete. In this piece, Steve Jones talks about the idea that it is a science as much as an art.  Read more...
By Steve Jones 2014/01/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 293 reads

Regrets of the Last Decade

After Steve Ballmer shares some of his thoughts on his time as CEO, Steve Jones decided to give a few of his own thoughts.   Read more...
By Steve Jones 2013/12/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 170 reads

Relationally Divided over EAV

A document search on a billion row "EAV" table is predicted to take 134 days. With a few design tweaks and an efficient relational division algorithm, Peter Larsson got it down to milliseconds.  Read more...
By Tony Davis 2013/12/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 237 reads

Going over their heads: IT Decisions

Phil factor points out that Marketing people who appeal directly to enterprise CIOs are generally wasting their time, and are better off convincing IT people in general.  Read more...
By Phil Factor 2013/12/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 115 reads

What Counts for a DBA: Deduction

Like Sherlock Holmes, a DBA needs the sound deductive reasoning to pinpoint the root cause of a crime, in amongst a thousand interesting but irrelevant details.  Read more...
By Louis Davidson (@drsql) 2013/11/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 110 reads

Cloud Storage. Make it the present instead of the future.

In which Phil Factor wonders why all the different cloud storage offerings are so different, sparse in their features, crude and incompatible  Read more...
By Phil Factor 2013/11/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads

Going over their heads: IT Decisions

Phil factor points out that Marketing people who appeal directly to enterprise CIOs are generally wasting their time, and are better off convincing IT people in general.  Read more...
By Phil Factor 2013/12/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 115 reads

Escape from ETL Hell

What often starts out as a simple, quick process, gradually expands over time, as developers use SQL Agent to schedule new data feeds, add more complex transformations...   Read more...
By Tony Davis 2013/10/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 137 reads

IT Security

A recent survey says IT security is a major concern for many businesses. Steve Jones wonders why they don't make more of an effort to implement better security in their applications and processes.  Read more...
By Steve Jones 2013/10/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 128 reads

Competence trumps a good cultural fit

Phil Factor reflects on how the people who made the industry great, in the past, were often eccentric, rebellious, odd, truculent, but all blessed with the gift of creating wonderful software. Today, such people would struggle to get pass the first interview.  Read more...
By Phil Factor 2013/09/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 181 reads

The MCM Program is dead. Long live the MCMs!

Grant Fritchey on why he takes a dim view of most certifications, and why the MCM was different.  Read more...
By Grant Fritchey 2013/09/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 180 reads

The Loss of Trust

The news about NSA spying keeps coming out, and apparently includes corporate communications as well.  Read more...
By Steve Jones 2013/09/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 224 reads

What Counts for a DBA: Patience

Technical debt is frustrating but dealing with it requires patience. Louis Davidson explains why.  Read more...
By Louis Davidson (@drsql) 2013/09/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 113 reads

Guidance

This week Steve Jones echoes advice from Grant Fritchey: be cautious when giving advice.  Read more...
By Steve Jones 2013/08/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 98 reads

DEF CON SQL

An impromptu hacking session, in response to an inexplicably-changed password, reminds Rodney Landrum of some valuable lessons for every DBA.  Read more...
By Rodney Landrum 2013/08/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 93 reads

Some Relevant PowerShell Books

Phil Factor leafs through a few of his PowerShell books in his library, and considers which are his favorites  Read more...
By Phil Factor 2013/07/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 99 reads

What Counts for a DBA: Baselines

It is very difficult to pinpoint what ails a server, just by looking at a single snapshot of the data, or to spot retrospectively what caused the problem by examining aggregated data for the server, collected over many months. The answer? Baselines.  Read more...
By Louis Davidson (@drsql) 2013/07/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 299 reads
<< Newer    Items 21 to 40 of 379    Older >>
 
Tags
editorial (284)    
editorial - mp3 (33)    
editorial - wmv (31)    
editorial - ipod (28)    
career (16)    
ethics (7)    
cloud computing (6)    
dba (6)    
performance tuning (6)    
professional development (6)    
security (6)    
service packs (6)    
cloud services (5)    
licensing (5)    
software development (5)    
sql server (5)    
powershell (4)    
sql server 2008 (4)    
testing (4)    
azure (3)    
dba skills (3)    
disaster recovery (dr) (3)    
leadership (3)    
virtualization (3)    
administration (2)    
backup / restore (2)    
books (2)    
certifications (2)    
conferences and events (2)    
data compression (2)    
data managment (2)    
data science (2)    
dba basics (2)    
documentation (2)    
indexing (2)    
maintenance plans (2)    
oracle (2)    
patches (2)    
t-sql (2)    
agile (1)    
agile for databases (1)    
baselines (1)    
best practices (1)    
copyright (1)    
data degredation (1)    
data modeling (1)    
data quality (1)    
data warehousing (1)    
database administrator (1)    
database deployment (1)    
dba profile (1)    
defensive programming (1)    
denali (1)    
deployment (1)    
development (1)    
development process (1)    
disk space (1)    
dmv (1)    
eav (1)    
encryption (1)    
etl performance (1)    
events (1)    
exchange (1)    
extended properties (1)    
houston (1)    
mcm (1)    
monitoring (1)    
mvp (1)    
mysql (1)    
nosql (1)    
odbc (1)    
open source (1)    
parallelism (1)    
pass summit (1)    
password policy (1)    
passwords (1)    
patching (1)    
performance (1)    
query optimization (1)    
raid (1)    
relational databases (1)    
remoting (1)    
schemas (1)    
service broker (1)    
smo (1)    
source control (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
sql server 7 (1)    
ssrs (1)    
storage management (1)    
transactions (1)    
twitter (1)    
uptime (1)    
virtual memory (1)    
windows server 2012 (1)    
wit (1)