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

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

The Ongoing Costs of Building Software

There are lots of costs to building your own software, which Steve Jones notes might not be what you want to spend over time.  Read more...
By Steve Jones 2016/01/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 128 reads

Comparison of SQL Server Serializable and Snapshot isolation levels

Both Serializable and Snapshot isolation levels exclude concurrency issues such as Dirty Reads, Non-repeatable Reads and Phantoms. However the way in which they deal with such issues is quite different. In this article, Sergey Gigoyan explains the main differences between the two.  Read more...
By Additional Articles 2016/01/13 | Source: MSSQLTips.com | Category: isolation levels
Rating:  Rate this |   Briefcase | 3,021 reads

SQL Family Feud Survey - Technical questions

The first 100 people get to decide the data set. Give us the first thing you think of.  Read more...
By Press Release 2016/01/13 | Source: SQLServerCentral.com | Category: sql family feud
Rating: (not yet rated)  Rate this |   Briefcase | 12,233 reads

Error: Microsoft .NET framework 3.5 service pack 1 is Required

How can you fix a .NET Framework 3.5 error while installing SQL Server 2014?  Read more...
By Ganapathi varma 2016/01/12 | Source: SQLServerCentral.com | Category: sql installation
Rating: |  Discuss |   Briefcase | 3,992 reads

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,935 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

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

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,207 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,337 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,199 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,041 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,863 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,876 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,366 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
<< Newer    Items 61 to 80 of 14447    Older >>