Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

   Items 1 to 20 of 14047    Older >>
 

Hidden Tricks To SQL Server Table Cleanup

How to delete millions of rows with virtually no contention.  Read more...
By Edward Polley 2015/09/04 (first published: 2013/03/06) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 18,701 reads

Adjusting Model

This Friday Steve Jones looks at the topic of defaults and whether you use the model database to adjust yours.  Read more...
By Steve Jones 2015/09/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

An Introduction to the OpenPOWER Foundation

In a bid to challenge Intel's dominance of high performance computing environments, IBM have introduced OpenPOWER, a flexible open-source framework based on their POWER processor architecture. Robert Sheldon looks at the potential of this new platform.  Read more...
By Additional Articles 2015/09/04 | Source: SimpleTalk | Category: openpower
Rating: (not yet rated)  Rate this |   Briefcase | 1,730 reads

Understand the Limitations of SQL Server Dynamic Data Masking

Dynamic data masking provides a simple way to implement obfuscation of private data. However it's important to understand the limitations, and to keep in mind that it is not true encryption and that the data cannot be protected in all scenarios. Aaron Bertrand explains.  Read more...
By Additional Articles 2015/09/03 | Source: MSSQLTips.com | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 1,445 reads

Configuring Service Broker Architecture

Learn how to configure technically reliable, consistent, robust, efficient, asynchronous message queuing and processing mechanism to start developing highly available, scalable applications based upon the service–oriented architecture.  Read more...
By Valerij Urban 2015/09/03 | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 2,118 reads

The Case for Upgrading

When is it worth upgrading your SQL Server? It's a question Steve Jones explores today.   Read more...
By Steve Jones 2015/09/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 79 reads

Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions

In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ranking functions were introduced in SQL Server 2005. In this stairway level I will be reviewing each of these different ranking functions, and will show you how to use them by providing a few examples.  Read more...
By Gregory Larsen 2015/09/02 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,722 reads

Byte Me: Bad Code

Gone off the Rails.  Read more...
By Bob Lang 2015/09/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 479 reads

Creating Dashboards for Mobile Devices with Datazen – Part 3

With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 Enterprise Edition or later with Software Assurance, you can download and use Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional cost. In this article, Arshad Ali demonstrates creating data source, data views and then creating dashboards using them with Datazen Publisher.  Read more...
By Additional Articles 2015/09/02 | Source: Database Journal | Category: datazen
Rating: (not yet rated)  Rate this |   Briefcase | 2,322 reads

Software Estimates

It seems the software industry doesn't do a good job of planning and estimating software development efforts.  Read more...
By Steve Jones 2015/09/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 109 reads

SSIS Package documentor

Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.   Read more...
Rating: |  Discuss |   Briefcase | 6,952 reads

Free Workshop: Microsoft Data Platform Modernisation - London, Sep 24

Are you an ISV and/or commercial software developer using SQL Server? Are you considering how to upgrade your application to take advantage of new SQL Server 2014 and would like to know more about how Microsoft can help your migration and sales/marketing efforts? Register using this invitation key 9ABED3   Read more...
By Additional Articles 2015/09/01 | Category: workshop
Rating:  Rate this |   Briefcase | 2,505 reads

Selective Updates with ASP.NET SignalR

Many developers get the misleading perception that ASP.NET SignalR merely helps to build a chat application or provides live updates of news, stock and score tickers. In reality, ASP.NET SignalR has a broader scope. In this article, Dino Esposito covers a few techniques to make selective SignalR updates to pages behind an ASP.NET authentication layer.  Read more...
By Additional Articles 2015/09/01 | Source: SimpleTalk | Category: asp .net
Rating: (not yet rated)  Rate this |   Briefcase | 1,389 reads

JSON Select - Easily query values from JSON

Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+  Read more...
By Joshua Healy 2015/08/31 | Source: SQLServerCentral.com | Category: json
Rating: |  Discuss |   Briefcase | 8,428 reads

No More Foreign Keys?

Does it make sense to avoid FKs for use other architectures in software development? Steve Jones isn't sure a a general rule this is the case.  Read more...
By Steve Jones 2015/08/31 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 234 reads

Free Webinar: Should your databases be Continuously Delivered?

If you want to learn more about Continuous Delivery, and where your databases fit into the picture, join Dave Farley on September 2nd for a webinar covering why databases are an essential component of CD, and how to start modernizing your software development practices.  Read more...
By Additional Articles 2015/08/31 (first published: 2015/08/13) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 7,489 reads

Learning Managed Backup

References and Links to using the Managed Backup feature in SQL Server 2016  Read more...
By Site Owners 2015/08/31 | Source: SQLServerCentral.com | Category: managed backup
Rating: (not yet rated) |  Discuss |   Briefcase | 668 reads

SQL Performance Elevenses

Phil Factor's first eleven principles for diagnosing slow SQL.  Read more...
By Phil Factor 2015/08/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 131 reads

Choosing hash distributed table vs. round-robin distributed table in Azure SQL DW Service

Designing databases to use distributed tables effectively will help you to achieve the storage and query processing benefits of the Azure SQL DW Service (SQL DW). In this article, Murshed Zaman explains the various Azure SQL Data Warehouse distributed table types, and offers guidance for choosing the type of distributed table to use and when to use it.  Read more...
By Additional Articles 2015/08/31 | Source: SQLCAT | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,033 reads

The Problem Solver

A guest editorial from Andy Warren looks at the traits of problem solvers.  Read more...
By Andy Warren 2015/08/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 156 reads
   Items 1 to 20 of 14047    Older >>