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

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

Do you have DBA syndrome?

Sometimes DBAs become resistant to change. When they lose focus on their full purpose they may have DBA syndrome.  Read more...
By Ben Kubicek 2016/10/05 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 126 reads

Stairway to U-SQL Level 9: Views and C# Expressions

Learn how U-SQL views can hide complexity and use C# expressions, providing powerful ways to format and return your data.  Read more...
By Mike McQuillan 2016/10/05 | Source: | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,023 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2016/10/05 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 79,525 reads

Pattern Matching : More Fun When I Was a Kid

Aaron Bertrand runs some tests to challenge an assertion that CHARINDEX is always faster at pattern matching than LEFT and LIKE.  Read more...
By Additional Articles 2016/10/05 | Source: | Category: charindex
Rating: (not yet rated)  Rate this |   Briefcase | 2,979 reads

Audit Survey

Do you have a need to audit your database? Do you have compliance pressures? Redgate would like to build better tools in this area but need your help to understand the pain points. If you think you can help, please fill in their short survey.  Read more...
By 2016/10/05 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,719 reads

Questioning the Interviewer

Asking questions in an interview is important, but there can be issues. Steve Jones talks a little about how to approach this.  Read more...
By Steve Jones 2016/10/04 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 528 reads

PowerShell Solutions - Working with files

When we administer a SQL Database, we always have to work with files. This new article shows how to handle them using PowerShell.  Read more...
By Daniel Calbimonte 2016/10/04 | Source: | Category: copy
Rating: |  Discuss |   Briefcase | 1,506 reads

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,133 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,552 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,361 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 | 79 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 | 41 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,305 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,575 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 | 67 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,349 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 | 866 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,892 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,836 reads
<< Newer    Items 61 to 80 of 15158    Older >>