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

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

Splitting Strings in SQL Server 2016

Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods  Read more...
By Wayne Sheffield 2016/04/12 | Source: SQLServerCentral.com | Category: string_split
Rating: |  Discuss |   Briefcase | 3,400 reads

A Welcoming Conference

It's almost time for SQLBits, Steve's favorite conference.  Read more...
By Steve Jones 2016/04/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 88 reads

How to fix SQL Server deadlocks with monitoring

Learn about deadlocks and how you might better troubleshoot the issues involved.  Read more...
By Additional Articles 2016/04/12 | Source: Redgate | Category: sql monitor
Rating:  Rate this |   Briefcase | 4,608 reads

The 2015/2016 Simple-Talk Awards: Winners Announced

The 2015/16 Simple-Talk Awards have concluded, the votes have been counted and recounted, and the winners have now been announced.  Read more...
By Additional Articles 2016/04/12 | Source: SimpleTalk | Category: simple-talk
Rating: (not yet rated)  Rate this |   Briefcase | 2,118 reads

NonClustered Index Structure

Learn how the clustered index keys affect the non clustered index structure.  Read more...
By Mayank Shukla 2016/04/11 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,049 reads

The Data Dewey Decimal System

Steve Jones looks at the idea of cataloging our data sets in order to make it easier for  Read more...
By Steve Jones 2016/04/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 93 reads

Getting Started with Temporal Table in SQL Server 2016 – Part 1

With the new temporal table feature, SQL Server 2016 internally manages two tables: a base table, which contains the latest data all the time, and a history table, which contains a history of all of the changes. Arshad Ali looks at the new feature, how it works, and how to either create a new table with this feature or enable it for an existing table.  Read more...
By Additional Articles 2016/04/11 | Source: Database Journal | Category: temporal tables
Rating: (not yet rated)  Rate this |   Briefcase | 3,548 reads

Hunting in Packs

Waterfall is the practice most destructive to developer productivity? Nonsense, according to Phil Factor. Lack of basic team coordination skills comes much higher in the list.  Read more...
By Phil Factor 2016/04/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads

Finding Special Characters within Character Strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2016/04/08 (first published: 2014/08/19) | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 13,327 reads

How Much Can You Learn?

This Friday Steve Jones wonders about the upper limits for what you may learn in a year.  Read more...
By Steve Jones 2016/04/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 125 reads

The Comeback of Migrations-Based Deployments

With database deployments, not all script-based processes are equal. Some use change scripts in a free-and-easy way, and some, which are normally called ‘migrations-based approaches’, have more discipline around them. In this article, Redgate Product Manager Elizabeth Ayer covers ‘migrations’, and shows some of the benefits that have come with new tooling which is specifically designed to assist the change script processes.  Read more...
By Additional Articles 2016/04/08 | Source: SimpleTalk | Category: migrations-based
Rating: (not yet rated)  Rate this |   Briefcase | 2,788 reads

Naming Is Hard

Naming objects and variables in software can create contention in a team. While there are good conventions and standards, ultimately a team just needs to agree on something.  Read more...
By Steve Jones 2016/04/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 106 reads

Using Code Snippets in SSMS

Snippets will allow you to code faster by inserting chunks of code with few key strokes.  Read more...
By Luis Cazares 2016/04/07 | Source: SQLServerCentral.com | Category: ssms
Rating: |  Discuss |   Briefcase | 2,974 reads

Exploring SQL Server 2016 Dynamic Data Masking – Part Two - Masking and Exporting Data in Existing Tables

Dynamic Data Masking allows you to obscure your confidential data column values at the database engine level for both new and existing SQL Server data. Being able to alter the definition of an existing column to add a masking rule makes it very simple to obscure your existing column values without even changing your application code.  Read more...
By Additional Articles 2016/04/07 | Source: Database Journal | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 4,234 reads

Byte Me: Spy Where?

By Bob Lang 2016/04/06 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

Stairway to Dynamic Data Masking Level 3: The Configured Data Masks

Continuing with his look at Dynamic Data Masking, Steve Jones looks at the masking patterns available besides the default mask.  Read more...
By Steve Jones 2016/04/06 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: (not yet rated) |  Discuss |   Briefcase | 1,160 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2016/04/06 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 45,646 reads

Performance Surprises and Assumptions: STRING_SPLIT

SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. In this article, Aaron Bertrand compares its performance to existing methods.  Read more...
By Additional Articles 2016/04/06 | Source: SQLPerformance.com | Category: string_split
Rating:  Rate this |   Briefcase | 3,553 reads

No Overtime

A new bill adds additional overtime exemptions for database professionals.  Read more...
By Steve Jones 2016/04/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 438 reads

A SQL Server Patching Shortcut

This post on SQL Server patching illustrates a quick and simple way of safely extracting SQL Server installation files in advance of patching a SQL Server instance.   Read more...
By Ajmer Dhariwal 2016/04/05 | Source: SQLServerCentral.com | Category: sql server patching
Rating: |  Discuss |   Briefcase | 1,977 reads
<< Newer    Items 61 to 80 of 14688    Older >>