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

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

Managing SQL Server Backup and Restore History Information

Greg Larson explains that SQL Server provides a couple of different ways to delete backup and restore history. If you want to remove backup and restore information for all databases based on a date you can use the sp_delete_backuphistory system stored procedure. Or you can use the system stored procedure named sp_delete_database_backuphistory if you want to remove all backup and restore history for a specific database.  Read more...
By Additional Articles 2016/10/04 | Source: Database Journal | Category: backup and restore
Rating: (not yet rated)  Rate this |   Briefcase | 4,121 reads

Constant Data Types

Data types are an important part of how tables and variables work. Did you know that constants have databases too?  Read more...
By Kenneth Fisher 2016/10/03 | Source: | Category: data types
Rating: |  Discuss |   Briefcase | 1,545 reads

Predicates With Subqueries

The ALL, SOME and ANY predicates aren't much used in SQL Server, but they are there. You can use the Exists() predicate instead but the logic is more contorted and difficult to read at a glance. Set-oriented predicates can greatly simplify the answering of many real-life business questions, so it is worth getting familiar with them. Joe Celko explains.  Read more...
By Additional Articles 2016/10/03 | Source: SimpleTalk | Category: predicates
Rating:  Rate this |   Briefcase | 6,338 reads

Coming Attacks

What happens if we can't access the Internet? We should be prepared, at home and work. Steve Jones has a few comments.  Read more...
By Steve Jones 2016/10/03 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 77 reads

Intelligence from Data

This week Steve Jones looks at the idea of using AI and machine learning with your data to develop amazing new insight.  Read more...
By Steve Jones 2016/10/03 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 40 reads

Free-Con Pre-Con at the Pass Summit 2016

A free day of training on Monday, October 24 in Seattle this year. Join MCMs, MVPs, and Friends of Redgate for a free day of training.  Read more...
By Press Release 2016/10/17 (first published: 2016/09/21) | Source: | Category: conferences and events
Rating: (not yet rated)  Rate this |   Briefcase | 5,176 reads

Understanding the OVER clause

Having a solid knowledge of the window functions if vital to high performance T-SQL Code. The key to these functions is how the OVER clause is used. This article will dive into how to use the OVER clause.  Read more...
By Wayne Sheffield 2016/09/30 (first published: 2015/10/14) | Source: | Category: over clause
Rating: |  Discuss |   Briefcase | 21,519 reads

The Exciting World of Data

Steve Jones gave a keynote, and has a little fun this week with the topic of his talk.  Read more...
By Steve Jones 2016/09/30 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 66 reads

SQL Server for Linux

Although SQL Server for Linux removes the concern that adopting SQL Server forces you to also adopt the Windows platform, it could also provide a useful alternative platform, and a more obvious alternative to Oracle. There are, however, several obvious concerns as to how such a product could ever achieve parity with the existing Windows-based product. Microsoft have made an interesting move with several ramifications, as Robert Sheldon explains.  Read more...
By Additional Articles 2016/09/30 | Source: SimpleTalk | Category: linux
Rating:  Rate this |   Briefcase | 5,327 reads

Installing R packages in SQL Server R Services

This article shows four ways you can use when installing missing R packages for Microsoft R Services.  Read more...
By Tomaž Kaštrun 2016/09/29 | Source: | Category: r package
Rating: (not yet rated) |  Discuss |   Briefcase | 862 reads

The Quiet Zone

Noise is vibration, and that can affect your systems, as Steve Jones notes today.  Read more...
By Steve Jones 2016/09/29 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 57 reads

Masking Your Data with SQL Server 2016

There are times when you want some users to see part of a column value but not the whole thing, but you want other users to see the complete column value without any masking. The new SQL Server 2016 Dynamic Data Masking feature will allow you to define these different kinds of masking rules - Greg Larson explains.  Read more...
By Additional Articles 2016/09/29 | Source: Database Journal | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 4,884 reads

New Redgate SQL Compare 12 has landed!

SQL Compare 12 has landed with a brand new user interface, support for SQL Server 2016, and a wealth of fixes and improvements. Check out this blog post from Redgate's Carly Meichen to hear more about what’s new, why the team have built it, and how. Read now.  Read more...
By 2016/09/29 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 2,826 reads

Stairway to Exploring Database Metadata Level 3: Exploring Indexes

This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.  Read more...
By Phil Factor 2016/09/28 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,228 reads

What is the Future of Monitoring?

Monitoring your systems is critical to ensuring security and stability. Steve Jones shares a few thoughts on where monitoring might go with more computer assistance in the future.  Read more...
By Steve Jones 2016/09/28 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 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/09/28 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 76,858 reads

Faster DBCC CHECKDB with SQL Server 2016

DBCC CHECKDB is a built-in SQL Server command that allows you to check database integrity and consistency in one simple command, but running it on large databases can be a nightmare. In this article, Ahmad Yaseen explains how you can enhance the command to run faster in SQL Server 2016.  Read more...
By Additional Articles 2016/09/28 | Source: | Category: dbcc checkdb
Rating: (not yet rated)  Rate this |   Briefcase | 2,920 reads

PowerShell Solutions - Several tips for daily tasks

In this tip, we will talk about PowerShell and SQL Server Log and Data Files.  Read more...
By Daniel Calbimonte 2016/09/27 | Source: | Category: datafile
Rating: |  Discuss |   Briefcase | 1,847 reads

PowerShell Desired State Configuration: DSC Resources

Desired State Configuration (DSC) allows you to automate the way that you manage configuration data for software services as well as the environment in which these services run. DSC uses a set of built-in and custom 'resources' as the building blocks for a configuration. If you have specific requirements you may need to create the relevant resource to make the configuration happen. Nicolas Prigent provides a practical guide to DSC resources.  Read more...
By Additional Articles 2016/09/27 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,776 reads

DevOps at Microsoft

Microsoft has dramatically changed the way they develop software, in a very public way, as Steve Jones notes.  Read more...
By Steve Jones 2016/09/27 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 80 reads
<< Newer    Items 61 to 80 of 15151    Older >>