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

<< Newer    Items 41 to 60 of 16006    Older >>
 

How to Automatically Create and Refresh Development and Test Databases

In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build when there is a proliferation of copies, and the database is big. Phil illustrates a solution by taking a set of Redgate tools to show how they can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers with the database build, taking care to save any DDL changes to the existing copies of the database.  Read more...
By Additional Articles 2017/08/08 | Source: SimpleTalk | Category: database delivery
Rating:  Rate this |   Briefcase | 4,051 reads

Removing sensitive data from a database

It’s fairly widely known that just because you delete data from a database, it doesn’t mean it’s gone from the data file itself, but the question is, how should you go about removing it?  Read more...
By 2017/08/08 | Source: Redgate | Category: deleting data
Rating: (not yet rated)  Rate this |   Briefcase | 5,262 reads

To-do list: good, bad or indifferent?

Using a list to keep track of what you should work on is only as good as the plan or goal behind it.  Read more...
By Ben Kubicek 2017/08/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 69 reads

Using Super Keys to Enforce Database Constraints

Example of Using Super Keys to Enforce Database Constraints, instead of procedural code  Read more...
By Dejan Mladenovic 2017/08/07 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 1,468 reads

SQL Server Management Studio Recovery, Reporting, Key Combinations and Efficiency Tips

Serget Gigoyan is back with another set of 5 common SSMS tips.  Read more...
By Additional Articles 2017/08/07 | Source: MSSQLTips.com | Category: ssms
Rating:  Rate this |   Briefcase | 4,239 reads

The Tethered Goat

Phil Factor's a 'tethered goat' database taught in the value of database intrusion detection and of "defense in depth".  Read more...
By Phil Factor 2017/08/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 48 reads

Learning through Puzzles

Different people respond to different types of learning techniques. Maybe a puzzle is the way that you learn.  Read more...
By Steve Jones 2017/08/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 64 reads

Dynamic Pivot, Passing Temp Table Variables to Dynamic SQL

This example demonstrates how to perform a pivot using dynamic headers based on the row values of a table. The article also shows how to pass a temp table variable to a Dynamic SQL call.  Read more...
By Jambu Krishnamurthy 2017/08/04 (first published: 2015/10/22) | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 7,958 reads

Developing Metadata Design Patterns in BIML

You may have already experienced ETL Hell, where you have a large number of similar of SSIS tasks, and a small change, such as an alteration to the network topology, means that they all need to be altered with the correct connection details. Perhaps you should consider creating design patterns for all the standard components of integration tasks in BIML, and generating the SSIS packages from these? Amarendra walks you through the process.  Read more...
By Additional Articles 2017/08/04 | Source: SimpleTalk | Category: biml
Rating:  Rate this |   Briefcase | 4,134 reads

Fuzzy Search

Finally a fuzzy search that finds all sorts of misspellings and missing parts.  Read more...
By William Talada 2017/08/03 | Source: SQLServerCentral.com | Category: fuzzy
Rating: |  Discuss |   Briefcase | 1,697 reads

Ingest data from a web page into SQL Server 2017 using R

Siddharth Mehta shows that R libraries can be used from T-SQL to ingest data from the web into SQL Server.  Read more...
By Additional Articles 2017/08/03 | Source: MSSQLTips.com | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 4,716 reads

The Second Best Job

Redgate is hiring someone to manage Simple Talk, a job just like the one Steve has with SQLServerCentral.  Read more...
By Steve Jones 2017/08/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

SQL Monitor plans for the second half of 2017

SQL Monitor’s dev team has made huge improvements to the product over the last year. In the first half of 2017 alone, they released reporting capabilities, support for collecting metrics from VMWare hosts, significant improvements to performance and scalability, improved configurability of alerts, as well as dozens of smaller enhancements. Since we’re about half way through 2017, it’s time to talk about the plans for the rest of the year.  Read more...
By 2017/08/03 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,094 reads

Stairway to T-SQL DML Level 3: Implementing a Relational Model in SQL Server

This level of the stairway details the creation of a relational database, as well as filling in some of the history of the relational database model.  Read more...
By Gregory Larsen 2017/08/02 (first published: 2011/11/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,173 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2017/08/02 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 84,689 reads

Data Science en Masse

GE is training lots of its staff in data science.  Read more...
By Steve Jones 2017/08/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 55 reads

Performance Myths : Oversizing string columns

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.  Read more...
By Additional Articles 2017/08/02 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 5,382 reads

Who's Licensed?

It's not easy to keep track of software licenses in a large organization.  Read more...
By Steve Jones 2017/08/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 58 reads

Azure DWH part 13: Load data using Data Platform Studio

In this article we will load data from a SQL Server on-premises to Azure SQL Data Warehouse  Read more...
By Daniel Calbimonte 2017/08/01 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 388 reads

How to Generate a Restore Script

There are multiple ways to accomplish a database restore. But if you wanted to restore a database from a script how might you accomplish that task quickly and accurately?  Read more...
By Additional Articles 2017/08/01 | Source: Database Journal | Category: restore
Rating:  Rate this |   Briefcase | 4,416 reads
<< Newer    Items 41 to 60 of 16006    Older >>