SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Database Weekly, Editorial Rss

   Items 1 to 20 of 425    Older >>
 

Timing is Everything

Phil Factor on the wise habit of timing your database routines, to avoid relying on received wisdom about performance.  Read more...
By Phil Factor 2017/10/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 32 reads

The Achilles Heel

In a long career in IT, Phil Factor cannot recall a 'major incident', where the failure or breach was due to a single 'Achilles Heel', or even a single team of people. They are always due to a whole plethora of slack and ignorant practices.  Read more...
By Phil Factor 2017/10/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 56 reads

The Worms-eye View

Even the most elaborate team-based development methodology won't compensate for the blinkered attitudes and tribal cultures that come from over-specialization in IT.  Read more...
By Phil Factor 2017/10/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 49 reads

A SQL Server Bug and Data Security

A bug in SQL Server needs patching right away if you use TDE. Some data security issues concern Steve as well.   Read more...
By Steve Jones 2017/09/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 32 reads

Avoiding the Hell of having to Remember DDL syntax

What's your favorite productivity tool when writing SQL? Phil Factor has has flirted with most of them, from templates and snippets to a programmer's clipboard and back again.  Read more...
By Phil Factor 2017/09/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 66 reads

The struggle to renormalize data

You are given an export of a NoSQL database, in JSON, and asked to import it into a relational database. Sounds easy? It isn't and Phil Factor explain why.  Read more...
By Phil Factor 2017/09/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 81 reads

SQL Server in Space - HASSP

A successful launch, and recovery, of SQL Server running below a balloon.  Read more...
By Steve Jones 2017/09/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 39 reads

The Adequate DBA

Louis Davidson on what it really means to be an adequate DBA.  Read more...
By Louis Davidson (@drsql) 2017/08/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 79 reads

The Tethered Goat

Phil Factor's a 'tethered goat' database taught in the value of database intrusion detection and of "defense in depth".  Read more...
By Phil Factor 2017/08/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 51 reads

Managing Passwords

This week Troy Hunt provides updated password guidelines, but Steve Jones notes many of us are in the middle, both managing and dealing with passwords.   Read more...
By Steve Jones 2017/07/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 61 reads

The Panjandrum Conundrum

With progress thwarted by a committee of panjandrums, will T-SQL forever remain in the doldrums? So wonders Phil Factor.  Read more...
By Phil Factor 2017/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

Backup Preparations

This week Steve asks you to make sure you practice your restore skills periodically.  Read more...
By Steve Jones 2017/07/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 32 reads

The Forgotten Editorial

Phil Factor reflects on the occasional benefits of document loss, whether accidental or less so.  Read more...
By Phil Factor 2017/06/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 48 reads

The Need for DRE

We need to become engineers instead of administrators.  Read more...
By Steve Jones 2017/06/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 57 reads

The Value of Surveys

Phil Factor on the perils of trying to squeeze good insights out of bad surveys.  Read more...
By Phil Factor 2017/06/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 40 reads

The Rate of Change of Data

Phil Factor argues that the database should be the primary source not only of the current data values, but also of the volatility of the data, its rate of change. Surely, then, it makes sense for the database to control the caching strategy.  Read more...
By Phil Factor 2017/05/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 49 reads

Security and Patching Struggles

This week Steve looks at the WannaCry attacks and server security.  Read more...
By Steve Jones 2017/05/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

Cracking the SQL Code

Checking for coding style and reviewing code is so much easier when using techniques and tools to help, as long as the tools are your slave, and not your master.  Read more...
By Phil Factor 2017/05/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 85 reads
   Items 1 to 20 of 425    Older >>
 
Tags
career (10)    
dba (8)    
professional development (8)    
security (8)    
dba skills (7)    
cloud computing (6)    
performance tuning (6)    
powershell (5)    
disaster recovery (dr) (4)    
azure (3)    
backup and restore (3)    
books (3)    
dba basics (3)    
documentation (3)    
service broker (3)    
service packs (3)    
t-sql (3)    
virtualization (3)    
administration (2)    
agile for databases (2)    
certifications (2)    
cloud services (2)    
conferences and events (2)    
data compression (2)    
data managment (2)    
data science (2)    
ethics (2)    
indexing (2)    
licensing (2)    
maintenance plans (2)    
monitoring (2)    
normalization (2)    
nosql (2)    
odbc (2)    
oracle (2)    
passwords (2)    
patches (2)    
sql (2)    
sql server (2)    
agile (1)    
ai (1)    
analytics (1)    
backup and recovery (1)    
baselines (1)    
best practices (1)    
copyright (1)    
cybersecurity (1)    
data (1)    
data analtyics (1)    
data architecture (1)    
data degredation (1)    
data modeling (1)    
data protection (1)    
data quality (1)    
data warehousing (1)    
database administrator (1)    
database deployment (1)    
database development (1)    
database reactoring (1)    
database security (1)    
datatypes (1)    
defensive programming (1)    
denali (1)    
deployment (1)    
development (1)    
development process (1)    
devops (1)    
disk space (1)    
dmv (1)    
eav (1)    
encryption (1)    
etl performance (1)    
events (1)    
exchange (1)    
extended properties (1)    
houston (1)    
it managment (1)    
it operations (1)    
json (1)    
leadership (1)    
learning (1)    
linux (1)    
management (1)    
mcm (1)    
mvp (1)    
mysql (1)    
online training (1)    
open source (1)    
parallelism (1)    
pass summit (1)    
password policy (1)    
patching (1)    
performance (1)    
query optimization (1)    
raid (1)    
relational databases (1)    
remoting (1)    
reporting services (ssrs) (1)    
rules (1)    
schemas (1)    
security awareness (1)    
smo (1)    
software development (1)    
source control (1)    
sql clr (1)    
sql eap (1)    
sql performance (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
sql server 2016 (1)    
sql server 7 (1)    
sqlite (1)    
ssms (1)    
storage management (1)    
testing (1)    
transactions (1)    
twitter (1)    
uptime (1)    
version control (1)    
virtual memory (1)    
watson (1)    
windows server 2012 (1)    
wit (1)