SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Register for the Redgate Hub Launch Livestream on September 6

To celebrate the launch of the new Redgate Hub, Data Platform MVP Steve Jones is hosting an educational livestream event alongside the team at Redgate HQ. They’ll introduce you to everything the Redgate Hub has to offer by highlighting some recent technical articles and how-to guides with in-depth live presentations. Register now.  Read more...
By 2017/09/05 (first published: 2017/08/24) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 5,389 reads

Database Development Made Easy?

Today Steve Jones has a few thoughts on the complexity and cumbersome nature of database development.  Read more...
By Steve Jones 2017/08/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 80 reads

Stairway to U-SQL Level 16: The Azure Data Lake Catalog

Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.  Read more...
By Mike McQuillan 2017/08/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 476 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 Redgate's SQL Backup tool.  Read more...
By Press Release 2017/08/30 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 62,154 reads

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is a good choice when your organisation uses AWS. RDS deals with maintenance and monitoring, and supports the use of PowerShell to automate routine tasks. What if a script needs to be triggered by an unscheduled event? Even in this case, RDS can be configured to run scripts to react when something like a failover happens. Laerte Junior shows how easy it is to set up Lambda functions and some PowerShell scripts to automatically synchronise agent jobs after a failover.  Read more...
By Additional Articles 2017/08/30 | Source: SimpleTalk | Category: aws
Rating: (not yet rated)  Rate this |   Briefcase | 2,054 reads

Incremental Package Deployment – A SSIS 2016 Feature

This article provides step by step instructions to deploy individual SSIS packages in a project deployment model.  Read more...
Rating: |  Discuss |   Briefcase | 880 reads

Who's Responsible?

If mistakes are made, employees can be held financially responsible by some companies. Do we need to worry about this in our industry?  Read more...
By Steve Jones 2017/08/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 88 reads

Fighting Evil in Your Code: Comments on Comments

One of the most glib generalisations you can make about development work is to say that code should be liberally commented, or conversely that it should never be commented. As always, the truth is more complicated. There are many different types of comment and some types are best treated firmly with the delete key, where others are to be cherished and maintained assiduously. Even though it is hard to find two developers who agree on the topic of commenting, Michael Sorens warily sketches out the issues and the battleground.  Read more...
By Additional Articles 2017/08/29 | Source: SimpleTalk | Category: comments
Rating: (not yet rated)  Rate this |   Briefcase | 3,451 reads

Poll: If you could gain an extra hour in your working day, what would you spend it on?

Wish you could get through your daily tasks and responsibilities a little quicker? Redgate are asking SQL Server professionals what would be most desirable about gaining an extra hour in the working day. Add your vote now.  Read more...
By 2017/08/29 | Source: Redgate | Category: poll
Rating: (not yet rated)  Rate this |   Briefcase | 2,602 reads

Graphing Performance

Are graph databases worth using? Steve Jones looks at a report that questions their value at this time.  Read more...
By Steve Jones 2017/08/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 63 reads

The Adequate DBA

Louis Davidson on what it really means to be an adequate DBA.  Read more...
By Louis Davidson (@drsql) 2017/08/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 78 reads

TDS Remoting: A Better Way to Create Linked Servers for ODBC Sources

TDS remoting services provide a native SQL experience with local and remote ODBC data sources (contrast with limitations of using OLE DB).  Read more...
By Jerod Johnson 2017/08/28 | Source: SQLServerCentral.com | Category: odbc
Rating: |  Discuss |   Briefcase | 1,269 reads

Implementing Azure SQL Data Sync in the Azure Portal

Azure SQL Data Sync, which has been lingering in the Preview mode since its introduction seven years ago, no longer requires the use of the Azure classic portal; you can finally access it by using the current Azure portal. Marcin Policht steps you through the process of implementing Azure SQL Data Sync using this interface.  Read more...
By Additional Articles 2017/08/28 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,215 reads

SQL Census update: new server view

SQL Census is a prototype from Redgate Foundry that helps you trace SQL Server user access permissions. Find out what's new and what's next for the tool in this blog post from Santiago Arias.  Read more...
By 2017/08/28 | Source: Redgate | Category: user permissions
Rating: (not yet rated)  Rate this |   Briefcase | 2,847 reads

Why PolyBase Matters

An alternative approach to disaster recovery and backup strategies using PolyBase.   Read more...
By Alain Dormehl 2017/08/25 (first published: 2015/08/10) | Source: SQLServerCentral.com | Category: aps
Rating: |  Discuss |   Briefcase | 6,907 reads

SQLCMD Mode; Run all SQL files in a directory

SQLCMD Mode gives you the ability to access command line executables via SSMS. Using creative approach, you can automate the execution of all files within a specified directory.  Read more...
By Jason Selburg 2017/08/25 (first published: 2015/09/14) | Source: SQLServerCentral.com | Category: sqlcmd mode
Rating: |  Discuss |   Briefcase | 6,614 reads

The Career Bucket List

Steve Jones asks you to look forward in your career, perhaps setting goals that move you forward.  Read more...
By Steve Jones 2017/08/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads

The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data

SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to be easy for untrained people to use. Even so, there are ways of expressing SQL Queries and data manipulation in ways that make it easier for the database engine to turn into efficient action. and easier for your colleagues to understand. Robert Sheldon homes in on data querying and manipulation and makes suggestions for team standards in SQL Coding.  Read more...
By Additional Articles 2017/08/25 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,675 reads

SQL Server and Data Governance

Does your organization have a data governance program, or are you thinking of implementing one? Redgate want to hear from you, as they're collecting data that will later be published in a report on the topic. Complete their survey to receive a copy of the report, and to be entered into a prize draw for a $100 Amazon gift card.  Read more...
By 2017/08/25 | Source: Redgate | Category: data governance
Rating: (not yet rated)  Rate this |   Briefcase | 2,458 reads

The Downsides of AI

Steve Jones looks at some of the problems we might have with AI in the future.  Read more...
By Steve Jones 2017/08/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 64 reads
<< Newer    Items 61 to 80 of 16093    Older >>