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

   Items 1 to 20 of 17265    Older >>
 

Using your critical eye to see something positive

As DBA's we are often looking for issues and hole is things, but it is also important to see positives and seek a better solution.  Read more...
By Ben Kubicek 2018/10/18 | Source: SQLServerCentral.com | Category: critical
Rating: (not yet rated) |  Discuss |   Briefcase | 28 reads

Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server

Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server Level Audit Group.  Read more...
By Deepak Prasad Sahu 2018/10/18 | Source: SQLServerCentral.com | Category: audit specification
Rating: |  Discuss |   Briefcase | 267 reads

Creating Machine Learning Applications using Azure Cognitive Services

Azure contains a vast array of services that can be used for machine learning, text analysis, and more. In this article, Supriya Pande provides a brief explanation of machine learning and then walks you through creating a sentiment analysis application.  Read more...
By Additional Articles 2018/10/18 | Source: SimpleTalk | Category: machine learning (ml)
Rating: (not yet rated)  Rate this |   Briefcase | 966 reads

Join Kendra Little at SQL in the City to capture the value of DevOps

Kendra Little is giving a 75-minute session on ‘Capturing the Value of DevOps’ at the upcoming SQL in the City Summits in New York City on October 12, London on October 18, and Chicago on October 26. The Summits are for C-level IT executives, directors, managers, and senior database engineers and administrators interested in learning about all things DevOps.  Read more...
By 2018/10/18 | Source: Redgate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 793 reads

Using Tools That Fit

The right tool is important for a good job. Andy Warren asks if you're thought about the tools you use on a daily basis.  Read more...
By Andy Warren 2018/10/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Installing the Database Server - Level 2 of the Stairway to SQL Server on Linux

In this next level, we learn how to install SQL Server on Linux and verify that everything is working.  Read more...
By Danilo Dominici 2018/10/17 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: (not yet rated) |  Discuss |   Briefcase | 216 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/10/17 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 100,063 reads

Using Azure Quickstart Templates

In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs.  Read more...
By Additional Articles 2018/10/17 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,160 reads

Selling Automation to Ops

Steve Jones thinks that DevOps is the wave of the future for most companies. He has a few ways to try and bridge the gap between development and Operations groups.  Read more...
By Steve Jones 2018/10/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 140 reads

Using Redgate API to compare data in the same table

I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it.  Read more...
By Ben Kubicek 2018/10/16 | Source: SQLServerCentral.com | Category: redgate
Rating: |  Discuss |   Briefcase | 464 reads

Configuring a MySQL Database on Amazon RDS

Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.  Read more...
By Additional Articles 2018/10/16 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 1,234 reads

Testing the Performance of Individual SQL Statements within a Batch using SQL Prompt

This article is all about using a SQL Prompt snippet to create and run a test harness on a batch of SQL code, to provide performance data. Behind the scenes, the snippet creates and starts an Extended Events event session, inserts and runs the text of the batch of SQL you’ve selected in SSMS, and uses XQuery on the XML event data, to return it in digestible, tabular form.  Read more...
By 2018/10/16 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 3,533 reads

Being Careful with Schema Ownership

When you create a schema, you might accidentally make yourself the owner, which can cause issues later. Learn how to ensure that your schemas aren't owned by transient employees.  Read more...
By Steve Jones 2018/10/15 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 749 reads

A Primer on Defect Management

Defects in software can occur in any phase of the software creation process. The earlier and better they are managed, the easier they are to correct. In this article, Afsana Atar explains defect management, including prevention and resolution.  Read more...
By Additional Articles 2018/10/15 | Source: SimpleTalk | Category: defects
Rating: (not yet rated)  Rate this |   Briefcase | 1,296 reads

Modeling and Design Are More Important in DevOps

Steve notes that modeling and good database design can't be ignored in DevOps work.  Read more...
By Steve Jones 2018/10/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 30 reads

A $3 Billion Donation

Microsoft opens 60,000 patents to the Open Inventor Network.  Read more...
By Steve Jones 2018/10/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 46 reads

The Importance of Consistent Server Setup

In larger shops with multiple database servers, it is very important to have consistency.  Read more...
By Ben Kubicek 2018/10/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Trigger Happy

This article looks at using triggers to audit and to prevent the performing of unintended actions.  Read more...
By Andy Jones 2018/10/12 (first published: 2016/03/28) | Source: SQLServerCentral.com | Category: trigger
Rating: |  Discuss |   Briefcase | 3,786 reads

Finding & Fixing Statistics Without Histograms

Men Without Hats were awesome. Statistics without histograms are terrible, but now they're easy to find and fix.  Read more...
By Additional Articles 2018/10/12 | Source: Brent Ozar Unlimited Blog | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 2,474 reads

Redgate University has opened its doors online

Redgate has established the Redgate University, an online resource where you’ll find self-paced training courses with easy to follow classes to help you and your team learn the fundamentals and best practices, and get top tips from the experts.  Read more...
By 2018/10/12 | Source: Redgate | Category: redgate software
Rating: (not yet rated)  Rate this |   Briefcase | 2,622 reads
   Items 1 to 20 of 17265    Older >>