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

<< Newer    Items 21 to 40 of 17186    Older >>
 

Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters

In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.  Read more...
By Additional Articles 2018/09/17 | Source: MSSQLTips.com | Category: like
Rating:  Rate this |   Briefcase | 2,568 reads

How Do You Setup Your Instances?

This week Steve wonders if you have a process for setting up your new instances.  Read more...
By Steve Jones 2018/09/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 49 reads

Introduction to Microsoft R Services in SQL Server 2016

General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.  Read more...
By Tomaž Kaštrun 2018/09/14 (first published: 2016/09/15) | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 4,185 reads

Single-Column-Key Missing Index Recommendations are Usually Wrong.

When Clippy suggests an index with only one key, look closer.  Read more...
By Additional Articles 2018/09/14 | Source: Brent Ozar Unlimited Blog | Category: index count
Rating: (not yet rated)  Rate this |   Briefcase | 2,502 reads

TRY_PARSE

Introducing the PARSE function, brought to us in SQL Server 2012.  Read more...
By Matthew McGiffen 2018/09/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,460 reads

Defending the RDBMS

An attack and defense of using relational data stores.  Read more...
By Steve Jones 2018/09/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 95 reads

How to Linux for SQL Server DBAs — Part 1

As running SQL Server on Linux becomes more common, DBAs must learn and become comfortable with the Linux OS. In this article, Kellyn Pot'Vin-Gorman demonstrates how to create a SQL Server instance running in Linux via a Docker container.  Read more...
By Additional Articles 2018/09/13 | Source: SimpleTalk | Category: linux sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,497 reads

It’s official: database development is now part of DevOps

You’ll probably have heard of the Accelerate State of DevOps Report from DORA. Now in its fifth year and backed by rigorous research involving 30,000+ professionals worldwide, it has consistently shown that higher software delivery performance delivers powerful business outcomes.  Read more...
By 2018/09/13 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,561 reads

Stairway to SSAS Tabular Level 4: Implementing Date Dimensions

In this first level of the SSAS Tabular stairway, learn how to implement and format a date dimension.  Read more...
By Thomas LeBlanc 2018/09/12 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 458 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2018/09/12 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 51,170 reads

We Don't Have Perfect Information

Trying to pick the perfect schedule at a conference is fraught with issues.  Read more...
By Steve Jones 2018/09/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 26 reads

Deep dive into Python scripts execution in SQL Server

This article looks at how Microsoft implemented the Python language support into SQL Server and how it can be used.  Read more...
By Additional Articles 2018/09/12 | Source: MSSQLTips.com | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,560 reads

The Helpful Triggers

Steve writes a T-SQL Tuesday entry about triggers.  Read more...
By Steve Jones 2018/09/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 56 reads

What is the impact of setting SET ANSI_WARNINGS OFF?

Setting ANSI_WARNINGS OFF to avoid NULL value elimination warnings can have an impact on the data quality and system behaviour.  Read more...
By Nakul Vachhrajani 2018/09/11 (first published: 2016/08/23) | Source: SQLServerCentral.com | Category: set options
Rating: |  Discuss |   Briefcase | 4,233 reads

SQL Prompt Code Analysis: Avoid using the ISNUMERIC Function (E1029)

Avoid using the IsNumeric() function, because it can often lead to data type conversion errors, when importing data. SQL Prompt Code Analysis rules include an Execution rule, E1029, which will alert you to use of this function, in your T-SQL. If you’re working on SQL Server 2012 or later, it’s much better to use the Try_Convert()or Try_Cast() function instead. On earlier SQL Server versions, the only way to avoid it is by using LIKE expressions.  Read more...
By 2018/09/11 | Source: Redgate | Category: sql prompt
Rating:  Rate this |   Briefcase | 2,890 reads

Displaying and Removing Unprintable Hexadecimal Characters from SQL Server Data

There are times when you might need to look at your SQL Server data in hexadecimal format. Occasionally some string data will contain unprintable characters, which can cause downstream problems, if not detected and removed. Read on to learn how to display and remove unprintable hexadecimal characters from SQL Server data.  Read more...
By Additional Articles 2018/09/11 | Source: Database Journal | Category: hexadecimal
Rating: (not yet rated)  Rate this |   Briefcase | 2,516 reads

The Hybrid Cloud

There are lots of options with cloud providers and hybrid versions of public and private clouds might be the best solution.  Read more...
By Steve Jones 2018/09/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

Bringing them back from the dead

When trying to find the causes for why the SQL Server service doesn’t start, one of the best places to start is the SQL Server Error log, but there is a problem!  Read more...
By Eirikur Eiriksson 2018/09/10 | Source: SQLServerCentral.com | Category: disaster recovery
Rating: |  Discuss |   Briefcase | 1,057 reads

Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report

SQL Server Central editor Steve Jones is joined by acclaimed author and researcher Gene Kim to discuss the latest in all things DevOps.  Read more...
By 2018/09/18 (first published: 2018/08/31) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 8,305 reads
<< Newer    Items 21 to 40 of 17186    Older >>