Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 61 to 80 of 14443    Older >>
 

Declarative SQL: Using References

There are several ingenious ways of using SQL References to enforce integrity declaratively. Declarative Referential Integrity (DRI) is more effective than using procedural code in triggers, procedures or application layers because it uses the SQL paradigm, thereby making optimisation easier and providing clearer expression of the rules underlying the data. Joe Celko explains.  Read more...
Rating:  Rate this |   Briefcase | 5,931 reads

The Advent of Code

Today Steve Jones challenges you to solve some programming problems.  Read more...
By Steve Jones 2016/01/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 135 reads

When a Service Pack or Cumulative Update Install Fails by “Evaporating"

Learn a few possible solutions to a frustrating issue when you attempt to patch a SQL Server installation.  Read more...
By Mike Hinds 2016/01/11 | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 2,609 reads

Top 10 MySQL Reporting Tools

Both management and various departments rely on data reports to help guide their business decisions. Rob Gravelle presents ten open source and commercial report generation tools for MySQL and other relational databases.  Read more...
By Additional Articles 2016/01/11 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 4,206 reads

100 Hours

Steve Jones notes you can learn quite a bit in 100 hours.  Read more...
By Steve Jones 2016/01/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 236 reads

Adios, IE

Microsoft ends support for IE on January 12.  Read more...
By Steve Jones 2016/01/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 164 reads

Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

Learn how to examine and read a SQL Server execution plan in this article. This is the third part of a short series from Darren White that examines execution plans and imparts the basics on an important skill for DBA's and SQL developers alike.  Read more...
By Darren White 2016/01/08 (first published: 2014/02/25) | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 17,311 reads

New DAX functions in SQL Server 2016

SQL Server 2016 comes with several new features including new DAX functions to enrich the functionality, Daniel Calbimonte takes a look.  Read more...
By Additional Articles 2016/01/08 | Source: MSSQLTips.com | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 3,197 reads

A Bit of History

Steve Jones is a bit off topic today, talking rockets and space travel.  Read more...
By Steve Jones 2016/01/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 109 reads

Understanding Peer-to-Peer Transactional Replication, Part 3

We've gone through the basics of Peer-to-Peer Transactional Replication (PPTR). Now, we will blow it up! We will then fix it and show you how you how to triage and repair PPTR. When you remain calm and take some easy steps, you can stabilize PPTR with ease.  Read more...
By John F. Tamburo 2016/01/07 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,039 reads

Rulebreaking Developers

How much of a problem is it when developers can blamed for issues?  Read more...
By Steve Jones 2016/01/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 221 reads

JSON support in SQL Server 2016

At last, SQL Server has caught up with other RDBMSs by providing a useful measure of JSON-support. It is a useful start, even though it is nothing like as comprehensive as the existing XML support. For many applications, what is provided will be sufficient. Robert Sheldon describes what is there and what isn't.  Read more...
By Additional Articles 2016/01/07 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 7,858 reads

Byte Me: Set in Stone

The good old days?  Read more...
By Bob Lang 2016/01/06
Rating: |  Discuss |   Briefcase | 126 reads

PowerShell Tool Time: Building Help

Learn how you can customize the help for your library of scripts in this edition of PowerShell Tool Time.  Read more...
By Mike Fal 2016/01/06 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,875 reads

Exploration of SQL Server 2016 Always Encrypted – Part 2

It is important to only allow authorized individuals access to confidential data. Therefore when setting up an Always Encrypted table it is important to consider splitting configuration tasks between multiple individuals/groups to improve security. Follow Greg Larsen as he shows how to setup up SQL Server Always Encrypted tables where database administrators can’t see the clear text confidential data.  Read more...
By Additional Articles 2016/01/06 | Source: Database Journal | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 4,362 reads

Hacking to Hide

People have hacked the voyage data recorders in ships. Steve Jones thinks this is a fundamental problem in computing systems.  Read more...
By Steve Jones 2016/01/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 160 reads

Datetime vs. Datetime2

Read a short comparison of datetime and datetime2 types. Learn about their structure, as well as the advantages and disadvantages of each.  Read more...
By Robert Hartmann 2016/01/05 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 12,304 reads

Optimizing Update Queries

Paul White spends some time optimizing update queries in order to explore some SQL Server internals.  Read more...
By Additional Articles 2016/01/05 | Source: SQL Server Performance | Category: update queries
Rating: (not yet rated)  Rate this |   Briefcase | 7,128 reads

Surface Book

Steve Jones is looking for a new laptop. Perhaps. Read on to see what he wants in a machine.  Read more...
By Steve Jones 2016/01/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 156 reads

Why Scalar Functions Can Be Costly

Scalar user defined functions can be costly in more ways than you know. Watch Mickey Stuewe show the hidden costs of using them incorrectly.  Read more...
By Mickey Stuewe 2016/01/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,100 reads
<< Newer    Items 61 to 80 of 14443    Older >>