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

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

The End of Summer

Today Steve Jones talks a bit about the US Labor Day holiday.  Read more...
By Steve Jones 2017/09/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 40 reads

Time Traveling with Temporal Tables on SQL Server 2016

One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.  Read more...
By Johan Åhlén 2017/09/04 (first published: 2016/10/18) | Source: SQLServerCentral.com | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 3,408 reads

SQL Server in Space - HASSP

A successful launch, and recovery, of SQL Server running below a balloon.  Read more...
By Steve Jones 2017/09/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 38 reads

Protecting production data in non-production environments

In this article, Grant Fritchey looks at the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production environment.  Read more...
By Additional Articles 2017/09/04 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,915 reads

Statistics in SQL: The Mann–Whitney U test

Phil Factor shows how to use the Mann-Whitney U test in SQL to to find out whether two samples come from the same distribution.  Read more...
By Additional Articles 2017/09/04 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 3,348 reads

PowerShell Tool Time: Our First Toolbox

Learn how to begin assembling your functions and code into modules you can easily call from any session.  Read more...
By Mike Fal 2017/09/01 (first published: 2015/10/28) | Source: SQLServerCentral.com | Category: powershell tool time
Rating: |  Discuss |   Briefcase | 7,154 reads

Improving Log Shipping

Today Steve Jones looks at possible ways to improve log shipping and asks for your input as well.  Read more...
By Steve Jones 2017/09/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

What is the biggest mistake you made in production?

When you have sysadmin access, you are bound to make a big mistake in production at some point in your career - in this post Tara Kizer looks back at what hers were.  Read more...
By Additional Articles 2017/09/01 | Source: Brent Ozar Unlimited Blog | Category: mistakes
Rating: (not yet rated)  Rate this |   Briefcase | 4,484 reads

Learning designed for the data professional

- PASS Summit offers five educationally-packed days lead by highly-rated, experienced speakers and sessions focused on the way you work with data. Speaker highlights include Bob Ward, and Sunil Agarwal from the Microsoft Tiger Team. Join us Oct 31 to Nov 3. Go to www.PASSsummit.com.  Read more...
By 2017/09/01 | Source: PASS | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,638 reads

SSIS as an Execution Engine for Multiple Sql scripts

Learn how you can execute multiple scripts in a restrictive database environment that doesn't allow any third-party tools.  Read more...
Rating: |  Discuss |   Briefcase | 974 reads

Resolving could not open a connection to SQL Server errors

Have you ever gotten connectivity errors from SQL Server? Jugal Shah explains the common causes for these errors, and advises on the steps you can take to resolve them.  Read more...
By Additional Articles 2017/08/31 | Source: MSSQLTips.com | Category: errors
Rating: (not yet rated)  Rate this |   Briefcase | 3,334 reads

Appreciating New Perspectives

Today Steve Jones talks about understanding and having empathy for other points of view.  Read more...
By Steve Jones 2017/08/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 69 reads

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,404 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 | 81 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 | 487 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,169 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,069 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 | 890 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,459 reads
<< Newer    Items 61 to 80 of 16105    Older >>