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

<< Newer    Items 21 to 40 of 14746    Older >>
 

new piece for jeff

fingers crossed  Read more...
By Steve Jones 2016/05/18 | Source: SQLServerCentral.com | Category: xxx
Rating: (not yet rated) |  Discuss |   Briefcase | 20 reads

Byte Me: SOS

By Bob Lang 2016/05/18 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 87 reads

Stairway to Database Source Control Level 5: Working with Others (Distributed Repository)

This level starts with an overview of how versioning works in Git, a DVCS, and suggests a sensible database project versioning strategy. It then offers some simple, but illustrative, practical examples showing how to share database changes and deal gracefully with any conflicting changes.  Read more...
By Dave Green 2016/05/18 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 863 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012 through SP2 CU11.  Read more...
By Steve Jones 2016/05/18 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 17,107 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2016/05/18 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 71,383 reads

Differences between Delete and Truncate in SQL Server

Atul Gaikwad details the differences between DELETE and TRUNCATE, including how they vary in terms of being rolled back.   Read more...
By Additional Articles 2016/05/18 | Source: MSSQLTips.com | Category: delete
Rating: (not yet rated)  Rate this |   Briefcase | 3,319 reads

Half Baked Features

Steve Jones notes that some features aren't fully developed, but that's not a reason to avoid releasing them.  Read more...
By Steve Jones 2016/05/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 96 reads

3 Things I Wish I Knew When I Started Using Entity Framework

Coming from a SQL developer background these few inner workings of Entity Framework caught me by surprise.  Read more...
By Bert Wagner 2016/05/17 | Source: SQLServerCentral.com | Category: entity framework
Rating: |  Discuss |   Briefcase | 3,231 reads

Row Level Security with SQL Server 2016: Part 2 - Blocking Updates at the Row Level

In this article, Greg Larson reviews why a block predicate is important when you implement row level security using SQL Server 2016.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,578 reads

Dynamic Data Masking

Deploy data masking as part of your SQL security strategy.  Read more...
By Ginger Keys 2016/05/16 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 1,465 reads

Implementing SQL Server In-Memory OLTP

How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables? How important for performance are natively-compiled Stored Procedures? Artemakis Artemiou comes up with a step-by-step guide to implementing an in-memory OLTP solution .  Read more...
By Additional Articles 2016/05/16 | Source: SimpleTalk | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 2,616 reads

Software Maturity with Release Management

Adding a release management tool to your software development is a sign of maturity.  Read more...
By Steve Jones 2016/05/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 reads

SQL Server RTM - June 1

The next version of SQL Server 2016 will be released on June 1, 2016, which means you can start planning those upgrades.  Read more...
By Steve Jones 2016/05/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

Join Operations – Hash Match

The way in which SQL Server chooses to join your tables in a query can dramatically affect performance. In this article, Jason Brimhall explains how a hash match works and shows some performance numbers.  Read more...
By Jason Brimhall 2016/05/13 (first published: 2014/03/04) | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 11,463 reads

The SQL Server 2016 Query Store: Analyzing Query Store Performance

There are some obvious advantages to having the Query Store, but what is the performance impact that it is likely to have on a busy OLTP database server? It is early days, of course and until we get more experience we have to rely on Microsoft's estimate of a performance impact of 3-5% on average. However, this will depend on a number of factors such as usage an the way it is configured. Enrico explores some of these factors in order to give a clearer picture of what you should expect.  Read more...
By Additional Articles 2016/05/13 | Source: SimpleTalk | Category: query store
Rating: (not yet rated)  Rate this |   Briefcase | 2,417 reads

The Proliferation of Roles

Using roles for security is a best practice that Steve Jones espouses.  Read more...
By Steve Jones 2016/05/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 reads

Adding PK Exceptions to SQLCop Tests

In this piece, Steve Jones shows how you can enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed.  Read more...
By Steve Jones 2016/05/12 | Source: SQLServerCentral.com | Category: tsqlt
Rating: (not yet rated) |  Discuss |   Briefcase | 894 reads

Performance Surprises and Assumptions : DATEADD()

Aaron Bertrand explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.  Read more...
By Additional Articles 2016/05/12 | Source: SQLPerformance.com | Category: dateadd
Rating: (not yet rated)  Rate this |   Briefcase | 3,812 reads

Solving Tempdb Issues

A simple change might solve some of those tempdb issues various customers experience.  Read more...
By Steve Jones 2016/05/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 123 reads

Use Tools

One of the great things about IT is that we have so many tools to help us do our jobs. We can even build tools as needed. So why don't more IT people take advantage of this?  Read more...
By Steve Jones 2016/05/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 433 reads
<< Newer    Items 21 to 40 of 14746    Older >>