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

Guest Columnist: Joao Osorio

SQLServerCentral.com profile

   Items 1 to 4 of 4   

Dealing with High Concurrency with Table Hints

Systems with a large number of requests on a critical database table are prone to blocking and slowness. We take a look at getting things done using T-SQL table hints.  Read more...
By Joao Osorio 2017/06/20 | Source: SQLServerCentral.com | Category: blocking
Rating: |  Discuss |   Briefcase | 1,613 reads

Data Lifecycle Management using SQL Server

With the data proliferation issues, a well-defined lifecycle for data retention is a growing demand.  Read more...
By Joao Osorio 2016/11/10 | Source: SQLServerCentral.com | Category: ilm
Rating: |  Discuss |   Briefcase | 1,204 reads

SQL Server 2016: built-in JSON Use case scenarios

There's built-in JSON support starting with SQL Server 2016. Does that mean we should all ditch XML and start using JSON? It depends mostly on the target of your data output processing.   Read more...
By Joao Osorio 2016/08/16 | Source: SQLServerCentral.com | Category: json
Rating: |  Discuss |   Briefcase | 1,729 reads

Continuous Integration with Microsoft SQL Server

What about database development? In most projects, developers aren’t focused on database development and for proper CI, the database version should keep neck to neck with the application builds.  Read more...
Rating: |  Discuss |   Briefcase | 3,350 reads
   Items 1 to 4 of 4