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

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

Database Version Control

By placing under source control everything we need to describe any version of a database, we make it much easier to achieve consistent database builds and releases, to find out who made which changes and why, and to access all database support materials. Matthew Skelton explains how to make sure your version control system fully supports all phases of the database lifecycle, from governance, development, delivery and through to operations.  Read more...
By Additional Articles 2016/04/21 | Source: SimpleTalk | Category: version control
Rating:  Rate this |   Briefcase | 2,654 reads

Guess the RTM Build

Have some fun and guess which build will be released for SQL Server 2016.  Read more...
By Steve Jones 2016/04/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 88 reads

Byte Me: Inadequate Cooling

By 2016/04/20 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 68 reads

Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function

There are times where you need to write a single T-SQL statement that is able to return different T-SQL expressions based on the evaluation of another expression. When you need this kind of functionality you can use the CASE expression or IIF function to meet this requirement. In this Stairway level Gregory Larsen reviews the CASE and IIF syntax and showing you examples of how the CASE expression and IIF function.  Read more...
By Gregory Larsen 2016/04/20 (first published: 2014/04/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,096 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2016/04/20 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 53,119 reads

Getting Started Tuning Performance in Azure SQL Database

Tim Radney talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.  Read more...
By Additional Articles 2016/04/20 | Source: SQLPerformance.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,791 reads

Crack that Encrypted Data

Ransomware is becoming an issue. Steve Jones notes DBAs need to be ready to deal with these issues.  Read more...
By Steve Jones 2016/04/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 111 reads

What Does the Near-Future of PowerShell & SQL Server Look Like? An Interview with Ken Van Hyning

Ken Van Hyning is the Engineering Manager for the SQL Server tools, including SQLPS.  Read more...
By Aaron Nelson 2016/04/19 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,032 reads

Unattended Installation

Installing SQL Server even without seeing the installation wizard.  Read more...
By Raghavender Chavva 2016/04/19 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 1,256 reads

Row Level Security with SQL Server 2016

Have you ever wanted an easier way to provide security at the record level? If so, you can now easily do this with the Row Level Security feature that is being introduced with SQL Server 2016. Greg Larsen shows you how easy it is to use this new feature as a way to provide user access to a specific set of records.  Read more...
Rating:  Rate this |   Briefcase | 3,546 reads

Exporting Azure Data Factory (ADF) into TFS Source Control

Have you created a Data Factory in Azure and are wondering how to get it into TFS and source control? This article will show you how.  Read more...
By Jeff Jordan 2016/04/18 | Source: SQLServerCentral.com | Category: azure data factory
Rating: |  Discuss |   Briefcase | 546 reads

SQL Server System Functions: The Basics

Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as @@rowcount or @@identity) to the ridiculous (IsNumeric()) Robert Sheldon provides an overview of the most commonly used of them.  Read more...
By Additional Articles 2016/04/18 | Source: SimpleTalk | Category: system functions
Rating: (not yet rated)  Rate this |   Briefcase | 5,205 reads

Digital Artefacts

A look at the overlaps between archaeology and database administration.  Read more...
By Dave Convery 2016/04/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

The Hidden Trigger

Steve Jones looks at the impact of triggers on our databases.  Read more...
By Steve Jones 2016/04/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 99 reads

sp_msforeachdb: Improving on an Undocumented Stored Procedure

Have you ever wanted to run a query across every database on a server with the convenience of a stored procedure? If so, Microsoft provided a stored procedure to do so. It’s unreliable, outdated, and somewhat obfuscated, though. Let’s improve on it!  Read more...
By Edward Pollack 2016/04/15 (first published: 2014/12/01) | Source: SQLServerCentral.com | Category: sp_msforeachdb
Rating: |  Discuss |   Briefcase | 12,621 reads

What's Your Downtime?

This week Steve Jones talks about downtime. Do you know what yours is?  Read more...
By Steve Jones 2016/04/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 97 reads

T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem

Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless you then document your code lavishly. Phil Factor's SQL Speed Phreak challenge produced some memorable code, but can SQL features introduced since then help to produce code that performs as well and is also easy to understand? Kathi Kellenberger investigates.  Read more...
By Additional Articles 2016/04/15 | Source: SimpleTalk | Category: fifo
Rating:  Rate this |   Briefcase | 5,077 reads

Successful Projects

What makes a successful software project? Steve Jones has some thoughts.  Read more...
By Steve Jones 2016/04/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

Data Mining Part 37: The Data Mining query transformation task

This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task  Read more...
By Daniel Calbimonte 2016/04/14 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 938 reads

What is Code Coverage For?

Code coverage is a practice that goes hand in hand with automated testing, reporting the percentage of your code that has been exercised during a test run. Ed Elliott and Redgate have partnered to make a code coverage tool available for SQL Server, both free and open source. SQL Cover measures the coverage of your SQL Server stored procedures and functions. It has built-in support for the popular tSQLt unit testing framework, but can also be used alongside any automated testing framework of your choosing. Find out more in this blog post.  Read more...
By Additional Articles 2016/04/14 | Category: code coverage
Rating: (not yet rated)  Rate this |   Briefcase | 3,968 reads
<< Newer    Items 21 to 40 of 14673    Older >>