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

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

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,030 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,668 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,649 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,083 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,156 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,674 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 | 54 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,354 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 | 378 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,393 reads

Simple Talk is hiring a full-time editor

Have experience editing and writing technical content? Redgate is currently hiring for their educational publishing site, Simple Talk. They're open to accepting remote workers, so if you're interested, there's no excuse not to go ahead and apply!  Read more...
By Site Owners 2017/08/01 (first published: 2017/07/28) | Source: Redgate | Category: hiring
Rating: (not yet rated)  Rate this |   Briefcase | 4,478 reads

Auto DevOps

Steve Jones worries about the coding being done in today's vehicles.  Read more...
By Steve Jones 2017/07/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 42 reads

Creating a Robust SSIS Development Environment using the SSIS Catalog

Discover how to integrate features of Visual Studio and the SSIS Catalog for an efficient development and deployment environment.  Read more...
Rating: |  Discuss |   Briefcase | 1,298 reads

How might classification and better documentation improve data safety?

SQL Atlas is the latest prototype to come from the Redgate Foundry - find out more about what the tool does and try out the interactive demo for yourself.  Read more...
By 2017/07/31 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,875 reads

Managing Passwords

This week Troy Hunt provides updated password guidelines, but Steve Jones notes many of us are in the middle, both managing and dealing with passwords.   Read more...
By Steve Jones 2017/07/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 59 reads

Query Store and Parameterization Problems

The query store gives us a novel way of identifying those queries that are causing performance problems when they are parameterized by SQL Server for reuse. Although it is relatively simple to ensure that certain troublesome queries avoid the problem, it is laborious to identify these queries. Additionally, Query Store gives us the means to fix the problem for groups of queries by means of plan guides without changing the DDL at all. Dennes Torres explains the details  Read more...
By Additional Articles 2017/07/31 | Source: SimpleTalk | Category: query store
Rating:  Rate this |   Briefcase | 4,043 reads

A Summit Just North of The Big Easy

Steve Jones travels back to one of the largest free events in the country, SQL Saturday Baton Rouge.  Read more...
By Steve Jones 2017/07/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 34 reads

SQLCMD and Batch File magic

Execute scripts in a folder with a single click using SQLCMD and a batch file.  Read more...
By Manu Mohanan 2017/07/28 (first published: 2015/11/19) | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 8,153 reads
<< Newer    Items 41 to 60 of 15998    Older >>