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

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

I thought my database was collation agnostic

My struggles with a customer's database that used a different collation sequence. The easy way is never the right way, or is it?  Read more...
By Thomas Romeo 2016/01/14 | Source: SQLServerCentral.com | Category: sql collation
Rating: |  Discuss |   Briefcase | 3,382 reads

SQL Server 2016 : Availability Group Enhancements

Aaron Bertrand reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.  Read more...
By Additional Articles 2016/01/14 | Source: SQLPerformance.com | Category: availability groups
Rating: (not yet rated)  Rate this |   Briefcase | 5,801 reads

Tracking Professional Athletes

Today Steve Jones looks at the use of tracking sensors to gather spatial data on professional athletes for later analysis.  Read more...
By Steve Jones 2016/01/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads

Stairway to SQL Server Extended Events Level 2: Creating Basic Event Sessions in the UI

In this Level, we'll walk through the basics of using the New Session dialog in the UI to create a new event session, define its events, actions and predicates, and establish a target for the session in which to collect the event data.  Read more...
By Erin Stellato 2016/01/13 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,448 reads

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,028 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,254 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,940 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 | 136 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,611 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 | 237 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,214 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 | 165 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,370 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,204 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,045 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 | 223 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,867 reads
<< Newer    Items 61 to 80 of 14451    Older >>