SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2018/09/04 to 2018/09/11

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,703 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 | 3,845 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,350 reads

Questions About Kerberos and SQL Server That You Were Too Shy to Ask

Kerberos authentication is a topic that many database administrators avoid. It’s really not that difficult to understand, but it’s also easy to get wrong. In this article, Kathi Kellenberger talks about what you need to know about configuring Kerberos for SSRS and SQL Server databases but were too shy to ask.  Read more...
By Additional Articles 2018/09/10 | Source: SimpleTalk | Category: kerberos
Rating: (not yet rated)  Rate this |   Briefcase | 3,290 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,133 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/24 (first published: 2018/08/31) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 10,742 reads

Foundational Material: Microsoft SQL Server Book and Blogs From The Past

Erik Darling dusts off his favorite archival-quality bloggers and books.  Read more...
By Additional Articles 2018/09/07 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating:  Rate this |   Briefcase | 2,820 reads

Learn from DevOps experts at Redgate’s SQL in the City Summits this October

Make a plan to register for one of Redgate’s SQL in the City Summit’s this October, whether you choose to come to the bright lights of New York City, or want to be among the high rises in Canary Wharf, London, or overlooking the Millennium Park in Chicago. Now’s your time to make the step towards gaining the know-how you need to help you fully adopt DevOps in your organization.  Read more...
By 2018/09/07 | Source: Redgate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 2,064 reads

Configuring Service Broker Architecture

Learn how to configure technically reliable, consistent, robust, efficient, asynchronous message queuing and processing mechanism to start developing highly available, scalable applications based upon the service–oriented architecture.  Read more...
By Valerij Urban 2018/09/07 (first published: 2015/09/03) | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 3,959 reads

Introduction to Testing Your PowerShell Code with Pester

Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as those written in PowerShell as well. In this article, Robert Cain introduces Pester, a tool for testing PowerShell code.  Read more...
By Additional Articles 2018/09/06 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,663 reads

8 practices for business data security

Is your data vulnerable to security breaches? Sophie Ross at Security Gladiators provides 8 rules you should be adhering to to ensure the safety of your data.  Read more...
By 2018/09/06 | Source: Redgate | Category: data security
Rating: (not yet rated)  Rate this |   Briefcase | 2,578 reads

Creating Subtotals and Totals in Aggregated Queries

Grouping Sets are an effective way to add subtotals to aggregated queries. T His article explains how.  Read more...
Rating: |  Discuss |   Briefcase | 1,760 reads

Free eBook: SQL Server Execution Plans, Third Edition

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.  Read more...
By Press Release 2018/11/14 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 117,270 reads

Using MERGE in SQL Server to insert, update and delete at the same time

In a typical data warehousing application, quite often during the ETL cycle you need to perform INSERT, UPDATE and DELETE operations on a TARGET table by matching the records from the SOURCE table.  Read more...
By Additional Articles 2018/09/05 | Source: MSSQLTips.com | Category: insert
Rating: (not yet rated)  Rate this |   Briefcase | 4,908 reads

Stairway to Columnstore Indexes Level 11: Optimizing Queries For Batch Mode (Part 2)

Hugo Kornelis continues his exploration of the types of queries that can end up running in row mode when accessing columnstore indexes. He demonstrates how careful rewriting can often yield a logically equivalent query that runs in batch mode instead, and therefore gains the best possible performance benefit.  Read more...
By Hugo Kornelis 2018/09/05 (first published: 2017/01/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,364 reads

Modern Data Warehouse Design Pattern – Part I

The modern data warehouse design helps in building a hub for all types of data to initiate integrated and transformative solutions. To achieve these goals and to support modern designs, Microsoft has introduced a set of fully managed, cloud-based services that not only support modern data warehouse design patterns but also provide the advantages of inbuilt scalability, high availability, good performance, and flexibility.  Read more...
By Additional Articles 2018/09/04 | Source: Database Journal | Category: data warehouse
Rating: (not yet rated)  Rate this |   Briefcase | 3,775 reads

What SOX means to the DBA

The worry that processes in place to ensure compliance can bottleneck the development process is a very real one. So how can you have the best of both worlds? In this article Rebecca Edwards discusses the implications and possible solutions.   Read more...
By 2018/09/04 | Source: Redgate | Category: sql provision
Rating:  Rate this |   Briefcase | 2,929 reads

Create AT&T Network Hierarchy Diagrams using SQL Server Data

Diagrammatic support for large, complex hierarchical data structures in SQL Server.   Read more...
By Paul Brewer 2018/09/04 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 763 reads