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 439    Older >>
 

Building Culture

The origins of PASS have shaped its culture for years. Are you doing the same in your organization?  Read more...
By Grant Fritchey 2018/02/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 39 reads

Database Taming

Sometimes a database can seem to be as willful as a colt. Taming it requires an iron nerve, and unflinching eye contact. Occasionally though, you need to know when to jump the fence and regroup.  Read more...
By Phil Factor 2018/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 52 reads

We Do Need To Upgrade

Security issues in older systems are going to be a problem.  Read more...
By Steve Jones 2018/02/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Data-driven Prototypes

Phil Factor on a tale of how dodgy mock data derailed an otherwise-convincing prototype.  Read more...
By Phil Factor 2018/01/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 39 reads

Sizing New Servers

Steve Jones talks hardware, which he mostly doesn't worry about for SQL Servers.  Read more...
By Steve Jones 2018/01/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 37 reads

Understanding Your Value

Fill out the 2017 salary survey to help us all understand where our compensation might lie relative to others.  Read more...
By Steve Jones 2017/12/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 7 reads

Sharing Data

This week Steve discusses the security aspects of sharing data.  Read more...
By Steve Jones 2017/12/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 32 reads

The Appearance of the Flat File Wizard.

After many barren years, Phil Factor is pleased to see the first signs of Spring in SSMS.  Read more...
By Phil Factor 2017/12/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 57 reads

A well-earned break from the database

Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.  Read more...
By Phil Factor 2017/11/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 51 reads

We Really Need Better Security

Some disturbing security issues reported this week.  Read more...
By Steve Jones 2017/11/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 reads

Microservices in SQL Server

In SQL Server 2017 consuming or providing JSON data is so efficient that you can implement effective microservices right from the database, argues Phil Factor.   Read more...
By Phil Factor 2017/11/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 88 reads

The Importance of Clear Data Displays

An accident on a ship is being blamed on unclear data visualization.  Read more...
By Steve Jones 2017/11/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 56 reads

Tell the Judge You Have No Backup

The NYPD is claiming there isn't a backup for one of their databases.  Read more...
By Steve Jones 2017/10/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 88 reads

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: |  Discuss |   Briefcase | 69 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 | 65 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 | 54 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 | 34 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 | 75 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 | 88 reads
   Items 1 to 20 of 439    Older >>
 
Tags
career (10)    
security (9)    
dba (8)    
professional development (8)    
dba skills (7)    
cloud computing (6)    
performance tuning (6)    
disaster recovery (dr) (5)    
powershell (5)    
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)    
json (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)    
ssms (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)    
holidays (1)    
houston (1)    
it managment (1)    
it operations (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)    
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)