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

Content with tag Editorial Rss

   Items 1 to 20 of 3462    Older >>
 

Get Patched If Not Supported

Many organizations that run older versions of SQL Server are not patched.  Read more...
By Steve Jones 2018/12/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 6 reads

Trust But Verify

Malware slips into packages, and it could slip into SQL code in the future.  Read more...
By Steve Jones 2018/12/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 24 reads

Deploy the Database First

Steve Jones thinks it's important that we be able to deploy almost any changes to our databases without breaking applications.  Read more...
By Steve Jones 2018/12/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 155 reads

The Wild Developers of SQL Server like Wildcards

Phil Factor explains the enduring attachment of database developers to wildcards, despite their current deficiencies.  Read more...
By Phil Factor 2018/12/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Code Reviews

This week Steve Jones asks about a concept that he used early in his career: code reviews. It's a good practice, but it seems as though it's fallen out of favor with many developers.  Read more...
By Steve Jones 2018/12/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 214 reads

The Number that shouldn't be a number

Gail Shaw is often left bewildered by the weird and wonderful data types people choose for their tables, when storing something as simple as a telephone number or a date.  Read more...
By Gail Shaw 2018/12/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 414 reads

Where Microsoft went wrong with SQL CLR

We database developers would, of course, like easy access to all the .NET delights, such as the excellent Regex library, but we don't want a Do-It-Yourself kit to achieve this. So argues Phil Factor.  Read more...
By Phil Factor 2018/12/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 376 reads

I may need to re-think the use of table variables

Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.  Read more...
By Ben Kubicek 2018/12/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads

Microservices for Databases

The idea of using microservices is gaining traction, but Steve Jones notes that the issues of databases might prevent adoption for many applications.  Read more...
By Steve Jones 2018/12/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 188 reads

The Worst Data Breech

A new law in Australia might be a source for the worst data breeches we could have.  Read more...
By Steve Jones 2018/12/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 57 reads

Automation at Work

The future of work might be a problem if things go as Steve expects.  Read more...
By Steve Jones 2018/12/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

MoSQL

Google is promoting more RDBMS based systems.  Read more...
By Steve Jones 2018/12/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 74 reads

Lax Security is Harmful for Employment

Data breaches do more than harm an organization. There's a human cost.  Read more...
By Steve Jones 2018/12/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 55 reads

Revving the Error

Changing error messages can be problematic at times.  Read more...
By Steve Jones 2018/12/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 45 reads

GitHub Downtime

GitHub experienced downtime and a problem with two nodes of database servers.  Read more...
By Steve Jones 2018/12/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Data with Provenance

File systems and document databases are the wild lands of data privacy. Phil Factor explains the value of JSON Schema in adding provenance to your document data.  Read more...
By Phil Factor 2018/12/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 40 reads

Understanding a Database

The ways in which you might try and reverse engineer a database design are on Steve's mind today.  Read more...
By Steve Jones 2018/11/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

Tougher Privacy Laws

A proposal for tougher privacy laws in the US is out.  Read more...
By Steve Jones 2018/11/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Mitigate Issues Early

When you know there's a problem, it's better to solve it early rather than late.  Read more...
By Steve Jones 2018/11/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 27 reads

Building Better Training Opportunities

Finding training opportunities can be a challenge in many organizations.  Read more...
By Steve Jones 2018/11/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 43 reads
   Items 1 to 20 of 3462    Older >>
 
Tags
database weekly (462)    
career (257)    
friday poll (222)    
security (177)    
software development (74)    
byte me (48)    
humor (39)    
backup and restore (35)    
cloud computing (35)    
disaster recovery (dr) (34)    
bloopers (31)    
devops (27)    
administration (26)    
sqlservercentral (23)    
cloud services (22)    
auditing (20)    
encryption (20)    
dba (16)    
nosql (16)    
hardware (15)    
professional development (15)    
high availability (ha) (14)    
microsoft (14)    
sql server (14)    
t-sql (14)    
cartoon (13)    
powershell (13)    
virtualization (13)    
car update (12)    
energy (12)    
performance tuning (12)    
puzzle (12)    
business intelligence (11)    
deployment (11)    
certifications (10)    
database design (10)    
monitoring (10)    
testing (10)    
data science (9)    
licensing (9)    
pass summit (9)    
service packs (9)    
upgrading (9)    
artificial intelligence (ai) (8)    
events (8)    
patching (8)    
sql injection (8)    
training (8)    
conferences and events (7)    
dba skills (7)    
management studio (ssms) (7)    
networking (7)    
performance (7)    
sql connections (7)    
sql in the city (7)    
sql server 2016 (7)    
version control systems (vcs) (7)    
deployment process (6)    
gdpr (6)    
indexing (6)    
passwords (6)    
redgate software (6)    
azure (5)    
continuous deployment (cd) (5)    
leadership (5)    
learning (5)    
sql saturday (5)    
archiving data (4)    
azure sql database (4)    
big data (4)    
communication (4)    
containers (4)    
contest (4)    
data analysis (4)    
data quality (4)    
database development (4)    
documentation (4)    
exceptional dba (4)    
hadoop (4)    
interviews (4)    
linux (4)    
machine learning (ml) (4)    
maintenance plans (4)    
management (4)    
r language (4)    
sql server 2005 (4)    
sql server 2008 r2 (4)    
sql server 2012 (4)    
time management (4)    
visualizations (4)    
agile (3)    
ai (3)    
automation (3)    
backup (3)    
books (3)    
crossword (3)    
data (3)    
data modeling (3)    
data privacy (3)    
data storage (3)    
dba basics (3)    
etl (extract, transform, and load) (3)    
google (3)    
log shipping (3)    
naming standards (3)    
normalization (3)    
patches (3)    
python (3)    
rdbms (3)    
service broker (3)    
sqlbits (3)    
storage (3)    
today (3)    
transactions (3)    
version control (3)    
agent jobs (2)    
agile for databases (2)    
always on (2)    
baselines (2)    
best practices (2)    
charity (2)    
cloud (2)    
code review (2)    
consolidation (2)    
continuous delivery (2)    
cosmosdb (2)    
data compression (2)    
data integrity (2)    
data managment (2)    
data mining (2)    
data security (2)    
data warehousing (2)    
database administrator (2)    
database deployment (2)    
design and theory (2)    
development (2)    
digital rights (2)    
downtime (2)    
education (2)    
ethics (2)    
excel (2)    
goals (2)    
hackers (2)    
hosting (2)    
integration services (ssis) (2)    
internet of things (2)    
it operations (2)    
job interviews (2)    
json (2)    
legal issues (2)    
microservices (2)    
mysql (2)    
odbc (2)    
open source (2)    
oracle (2)    
pass (2)    
performance testing (2)    
powerpivot (2)    
privacy (2)    
programming (2)    
query optimization (2)    
raid (2)    
reporting services (ssrs) (2)    
responsibilities (2)    
risk (2)    
roles (2)    
rollback (2)    
salaries (2)    
sarbanes-oxley (2)    
schema (2)    
schemas (2)    
secure programming (2)    
security awareness (2)    
simpledb (2)    
smo (2)    
software (2)    
source control (2)    
sql (2)    
sql intersection (2)    
sql server 2008 (2)    
sql server 2014 (2)    
sql server 2019 (2)    
sql server on linux (2)    
sqlfamily (2)    
stored procedures (2)    
transparent data encryption (tde) (2)    
tuning (2)    
unit testing (2)    
wind power (2)    
windows server 2012 (2)    
a short (1)    
adventureworks (1)    
alerting (1)    
algorithm (1)    
analytics (1)    
application design (1)    
april fools (1)    
architecture (1)    
awards (1)    
azure devops (1)    
azure sql data warehouse (asdw) (1)    
backups (1)    
basics (1)    
beginner (1)    
best and worst practices (1)    
biometrics (1)    
bitcoin (1)    
bots (1)    
branding (1)    
budgets (1)    
business continuity (bc) (1)    
business logic (1)    
cambridge analytica (1)    
carer (1)    
cell phone (1)    
cissp (1)    
clustering (1)    
code smells (1)    
coding standards (1)    
commute (1)    
compliance (1)    
connections (1)    
continuous integration (ci) (1)    
copyright (1)    
csv (1)    
cumulative updates (cu) (1)    
cybersecurity (1)    
data analtyics (1)    
data architecture (1)    
data center (1)    
data classification (1)    
data corruption (1)    
data degredation (1)    
data loss (1)    
data ownership (1)    
data platform (1)    
data privacy and protection (1)    
data protection (1)    
data retention (1)    
data sets (1)    
data virtualization (1)    
database mirroring (1)    
database reactoring (1)    
database security (1)    
datatypes (1)    
dbatools.io (1)    
dbcc checkdb (1)    
ddl (1)    
defensive programming (1)    
denali (1)    
deployments (1)    
design (1)    
development process (1)    
disk space (1)    
dmv (1)    
do you talk salary in the interview? (1)    
docker (1)    
documenting code (1)    
down tools week (1)    
dynamic data masking (1)    
dynamic sql (1)    
eav (1)    
economy (1)    
election (1)    
embarcadero (1)    
emotion (1)    
english query (1)    
etl (extract transform and load) (1)    
exceptional dba awards (1)    
exchange (1)    
execution plans (1)    
extended events (xe) (1)    
extended properties (1)    
facebook (1)    
failover (1)    
fillfactor (1)    
firefighting (1)    
foreign keys (fk) (1)    
functions (1)    
furniture (1)    
github (1)    
global warming (1)    
gordon bell (1)    
graph databases (1)    
green building (1)    
hard work (1)    
health (1)    
hekaton (1)    
holiday (1)    
holidays (1)    
houston (1)    
hyper-v (1)    
identity property (1)    
in-memory oltp (1)    
insensitivity (1)    
installation (1)    
insulation (1)    
interpersonal skills (1)    
iot (1)    
it disasters (1)    
it managment (1)    
jeff atwood (1)    
laptop (1)    
life (1)    
logging (1)    
logic puzzle (1)    
machine learning (1)    
machine learning services (mls) (1)    
mcm (1)    
meetings (1)    
memory optimized tables (1)    
mentoring (1)    
messaging (1)    
metadata (1)    
middle tier (1)    
mobile devices (1)    
mongodb (1)    
motivation (1)    
mvp (1)    
networking with people (1)    
newsql (1)    
northwind (1)    
nuclear power (1)    
object databases (1)    
office (1)    
office space (1)    
online training (1)    
open data (1)    
orm (1)    
oscars (1)    
our (1)    
parallelism (1)    
password policy (1)    
performance monitoring (1)    
plagiarism (1)    
policy based management (pbm) (1)    
politics (1)    
power bi (1)    
pragmatic works (1)    
predictions (1)    
primary key (pk) (1)    
procedural programming (1)    
productivity (1)    
project management (1)    
query data store (qds) (1)    
reference (1)    
regex (1)    
relational databases (1)    
remoting (1)    
replication (1)    
restore (1)    
rules (1)    
sample databases (1)    
saster (1)    
scalability (1)    
scramble (1)    
search (1)    
server setup (1)    
service broker (sssb) (1)    
set based (1)    
sharepoint (1)    
social networking (1)    
software engineering (1)    
softwarw (1)    
speaking (1)    
specialization (1)    
sql authentication (1)    
sql clone (1)    
sql clr (1)    
sql code analysis (1)    
sql eap (1)    
sql monitor (1)    
sql performance (1)    
sql puzzles (1)    
sql server 6.5 (1)    
sql server 7 (1)    
sql server data tools (ssdt) (1)    
sql server express (1)    
sql server security (1)    
sqlclr (1)    
sqlite (1)    
sqlsaturday (1)    
ssd (1)    
ssl (1)    
statistics (data) (1)    
stephen wolfram (1)    
steve (1)    
storage management (1)    
striped backups (1)    
success (1)    
superinsulated (1)    
support life cycle (1)    
surface computer (1)    
table variables (1)    
tagging (1)    
tally table (1)    
team (1)    
team building (1)    
technical debt (1)    
telecommuting (1)    
tempdb (1)    
temporal tables (1)    
terminology (1)    
test data (1)    
test-driven development (1)    
the (1)    
the client (1)    
the scary dba (1)    
there's (1)    
tom demarco (1)    
toolchain (1)    
tools (1)    
trace flags (1)    
transaction log (1)    
triggers (1)    
trust (1)    
t-sql tuesday (1)    
tsqlt (1)    
turbo.net (1)    
twitter (1)    
unions (1)    
uptime (1)    
user groups (1)    
virtual memory (1)    
w h (1)    
watson (1)    
wildcards (1)    
wind turbine (1)    
windows (1)    
windows home server (1)    
wit (1)    
writing sql (1)    
xml (1)