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

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

Finding code smells using SQL Prompt: procedures that lack schema-qualification

It is a very good idea to get into the habit of qualifying the names of procedures with their schema. It is not only makes your code more resilient and maintainable, but as Microsoft introduces new features that use schemas, such as auditing mechanisms, you code contains no ambiguities that could cause problems.  Read more...
By 2018/01/12 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 2,486 reads

SQL Server 2017 and Python Basics

This tutorial from Siddharth Mehta is intended to help experienced T-SQL Developers, DBAs, Data Analysts and Data Science enthusiasts to start using Python language with T-SQL.   Read more...
By 2018/01/12 | Source: MSSQLTips.com | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 3,170 reads

GDPR - A guide for the perplexed

If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand?  Read more...
By David Poole 2018/01/11 | Source: SQLServerCentral.com | Category: gdpr
Rating: |  Discuss |   Briefcase | 1,453 reads

Job Interviews: What is Normalization?

Do you know how to answer normalization questions in an interview? Steve Jones gives you a few ideas and recommends you brush up on your knowledge.  Read more...
By Steve Jones 2018/01/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 114 reads

What is database DevOps, and why is it important for DBAs?

Over the past 20 years, the concept of database DevOps has always been around, but the ability to automate tasks hasn’t been as simple for the database as it has been for application development. Database DevOps tools have now emerged, however, and the benefits of including DevOps for the database are being realized by many organizations to achieve greater operational efficiency.  Read more...
By 2018/01/11 | Source: Redgate | Category: devops
Rating:  Rate this |   Briefcase | 3,331 reads

A Walk Around SQL Operations Studio

SQL Server Management Studio has been the default tool for working with SQL Server for over a decade. It’s not, however, compatible with any operating system outside of Microsoft Windows. SQL Operations Studio (SQLOPS), the open source program originally called ‘Project Carbon’, is now available for users of Linux and macOS as well as Windows. Robert Cain demonstrates the features of SQLOPS.  Read more...
By 2018/01/11 | Source: SimpleTalk | Category: sql operations studio
Rating: (not yet rated)  Rate this |   Briefcase | 3,193 reads

Stairway to SQL Server Agent - Level 4: Configuring Database Mail

Examines the database mail system configuration in depth. You will learn how to configure database mail to work with SMTP mail systems, and get some troubleshooting tips.  Read more...
By Richard Waymire 2018/01/10 (first published: 2011/07/28) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,561 reads

SQL Crossword - Best Practices

This crossword tests your knowledge of SQL Server best practices.  Read more...
By Kenneth Fisher 2018/01/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 68 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2018/01/10 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 90,752 reads

How SQL Monitor Monitors Azure-based SQL Server Failover Cluster Instances

This article will show you how to set up SQL Monitor to monitor Azure-based clustered instances right alongside your on-premise clusters.  Read more...
By 2018/01/10 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,238 reads

Azure DWH part 23: Data Mining

SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW.  Read more...
By Daniel Calbimonte 2018/01/09 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 239 reads

Is This Data Science?

An analysis of salaries uses statistics to determine significance of the data. Is this data science?  Read more...
By Steve Jones 2018/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.  Read more...
By Additional Articles 2018/01/09 | Source: SimpleTalk | Category: in-memory oltp
Rating:  Rate this |   Briefcase | 2,764 reads

GDPR: Why We Stopped Selling Stuff to Europe

The EU’s new General Data Protection Regulation (GDPR) is a set of rules that give consumers rights about how their data is stored, used, and deleted. In this post Brent Ozar provides some handy resources, and sparks some interesting debate.  Read more...
By 2018/01/09 | Source: Brent Ozar Unlimited Blog | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 4,226 reads

How to Change the File Extension for a Data File

This is a fix to primary data file that is created with a different file extension or accidentally renamed to a different file extension  Read more...
By Sadan Kumar Budde 2018/01/08 | Source: SQLServerCentral.com | Category: data file
Rating: |  Discuss |   Briefcase | 634 reads

6 reasons why your development team needs SQL Prompt

While SQL Prompt cannot turn an unskilled database programmer into a SQL hero, it will drive up the productivity of a typical multi-skilled development team, and reduce reliance on specialist database developers.  Read more...
By 2018/01/08 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,104 reads

It's the Engineers

The staff that build your systems are more important than your choice of technology.  Read more...
By Steve Jones 2018/01/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 64 reads

Implementing Azure SQL Database Virtual Network Service Endpoints and Rules

In previous articles, Marcin Policht has described the main characteristics of two new features known as Virtual Network service endpoints and Azure SQL Database virtual network rules. In this article, he focuses on the details of implementing this functionality.  Read more...
By 2018/01/08 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,683 reads

Critical SQL Server Patches for Meltdown and Spectre

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.  Read more...
By Steve Jones 2018/01/18 (first published: 2018/01/05) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,075 reads

Nasty Fast PERCENT_RANK

Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+  Read more...
By Alan Burstein 2018/01/05 (first published: 2016/06/07) | Source: SQLServerCentral.com | Category: percent_rank
Rating: |  Discuss |   Briefcase | 5,085 reads
<< Newer    Items 21 to 40 of 16448    Older >>