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

<< Newer    Items 61 to 80 of 16010    Older >>
 

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,393 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 | 59 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 | 394 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,421 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,487 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,339 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,880 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,077 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,179 reads

Getting Started with SQL Server 2012 Express LocalDB

Developers using SQL Server Express face a few challenges in their day to day work. One is that setting up and maintaining Express can be a daunting task.  Read more...
By Additional Articles 2017/07/28 | Source: MSSQLTips.com | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 4,681 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,487 reads

Advanced Analytics with R and SQL Part II - Data Science Scenarios

Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.   Read more...
By Frank A. Banin 2017/07/27 | Source: SQLServerCentral.com | Category: data science
Rating: |  Discuss |   Briefcase | 833 reads

Statistics in SQL: The Kruskal–Wallis Test

Before you report your conclusions about your data, have you checked whether your 'actionable' figures occurred by chance? The Kruskal-Wallis test is a safe way of determining whether samples come from the same population, because it is simple and doesn't rely on a normal distribution in the population. This allows you a measure of confidence that your results are 'significant'. Phil Factor explains how to do it.  Read more...
By Additional Articles 2017/07/27 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 4,676 reads

Who's Smarter? Humans or AI Systems?

The growth of AI has Steve Jones a bit worried.  Read more...
By Steve Jones 2017/07/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

SQL Crossword #1

Today we start a new puzzle series, with a crossword puzzle from MVP Kenneth Fisher.  Read more...
By Kenneth Fisher 2017/07/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 220 reads

SQL-On-Hadoop: Hive - Part I

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.  Read more...
By Frank A. Banin 2017/07/26 | Source: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 935 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2017/07/26 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 85,611 reads
<< Newer    Items 61 to 80 of 16010    Older >>