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

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

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,620 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,539 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 | 435 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,961 reads

The 2015/2016 Simple-Talk Awards

Once more Simple-Talk invites its readers to vote on the top nominations for the Simple-Talk Awards. Find out who or what has been nominated for each of this year's nine categories, and cast your vote to decide the winners - voting closes tomorrow!  Read more...
By Additional Articles 2016/04/05 | Source: SimpleTalk | Category: simple-talk
Rating: (not yet rated)  Rate this |   Briefcase | 2,155 reads

New – work better with Git using SQL Source Control 5 beta

Join the SQL Source Control 5 beta and get early access to the newest features: source control your database in Git and other version control systems, merge when working with multiple branches, and deploy data-only migration scripts.  Read more...
By 2016/04/05 | Source: Redgate | Category: sql source control
Rating: (not yet rated)  Rate this |   Briefcase | 3,477 reads

SQL Server on Linux

Last month Microsoft not only announced that they’re bringing SQL Server to Linux, but also showed it off in a demo during the Data Driven keynote. Redgate are doing some research to understand what this news means to SQL Server users. So whether you’ve already downloaded the SQL Server on Linux preview, or you hadn’t heard about it until just now, you can help out by completing this short survey.  Read more...
By 2016/04/05 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 4,479 reads

Would You Move For a Job?

Today we have a guest editorial from Andy Warren as Steve is on vacation. Would any job be enough for you to uproot your life?  Read more...
By Andy Warren 2016/04/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 132 reads

Code smells versus transgressions

The oddest SQL practices can be done deliberately for good reason, but are there any that are always wrong, that are so bad that that their use should be prohibited as a matter of policy?  Read more...
By Phil Factor 2016/04/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 101 reads

Move an Existing Log Shipping Database to a New Monitor Server

How to move a log shipping database to a new monitor server without removing and rebuilding the log shipping setup.  Read more...
By Dane Boulton 2016/04/04 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 713 reads

Bad Cardinality Estimates from SSMS Plans – Redux

Aaron Bertrand shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,544 reads

The Database Transaction Unit (DTU) Decoded

In an Azure SQL Database, you pay for a certain number of DTUs, but what are these? Steve Jones explains.  Read more...
By Steve Jones 2016/04/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 1,559 reads

New MySQL Engine Supports T-SQL

MySQL has a new query processor that will run your T-SQL code.  Read more...
By Press Release 2016/04/01 | Source: SQLServerCentral.com | Category: mysql
Rating: |  Discuss |   Briefcase | 1,233 reads

SnowCrash for SQL Server

A new idea for managing your future SQL Servers.  Read more...
By Steve Jones 2016/04/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 110 reads

If SQL Server Runs on Linux, What's Left for April Fools Day

It’s still a bit hard to believe that SQL Server will soon run on Linux. If you think back to the early days of SQL 7, 2000, even 2005, who would have bet any money on it ever happening?  Read more...
By Andy Warren 2016/04/01 | Source: SQLServerCentral.com | Category: humor
Rating: (not yet rated)  Rate this |   Briefcase | 1,528 reads

Relational Algebra and its implications for NoSQL databases

With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is there a danger of the data-document model's hierarchical nature causing a fundamental conflict with relational theory? We asked our relational expert, Hugh Bin-Haad to expound a difficult area for database theorists.  Read more...
By Additional Articles 2016/04/01 | Source: SimpleTalk | Category: relational algebra
Rating:  Rate this |   Briefcase | 3,225 reads

Powershell To Get Active Directory Users And Groups into SQL!

Use Powershell to query AD for Users, Groups and GroupMembers  Read more...
By Lowell Izaguirre 2016/03/31 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,992 reads

Creating a Date Dimension in a Tabular Model

As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery mode. The in-memory analytics engine allows the users of Excel or Power View to base reports on tabular model objects. Having shown how to handle date-based information using the Multi-dimensional model, Dennes now turns his attention on the in-memory tabular model.  Read more...
By Additional Articles 2016/03/31 | Source: SimpleTalk | Category: tabular model
Rating:  Rate this |   Briefcase | 3,408 reads

Examining SQL Server 2016

Today Steve Jones wonders if any of you are looking at the next version of our platform, SQL Server 2016.  Read more...
By Steve Jones 2016/03/31 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 212 reads

Whitepaper: Database deployments: Choosing a state-based or migrations-based approach

This whitepaper explores the differences between the approaches, state based or migrations based, and how Redgate tools can help.  Read more...
By Press Release 2016/03/31 (first published: 2016/03/24) | Source: Redgate | Category: redgate software
Rating: (not yet rated)  Rate this |   Briefcase | 5,858 reads
<< Newer    Items 61 to 80 of 14673    Older >>