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

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

A Lightweight, Self-adjusting, Baseline-less Data Monitor

Can data alert us that something is going on, without baselines and thresholds?  Read more...
By Alex Chamchourine 2017/10/13 (first published: 2016/02/23) | Source: SQLServerCentral.com | Category: data monitoring
Rating: |  Discuss |   Briefcase | 3,488 reads

A Double Dose of Trouble

On this Friday the 13th, in October, Steve Jones shares a disaster story.  Read more...
By Steve Jones 2017/10/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

How to import an existing database to ReadyRoll

The SQL Toolbelt includes ReadyRoll, which allows you to adopt a migrations-first approach to database source control and deployment. There are a number of different ways teams can get started with ReadRoll, and customers often ask how to get up and running when there is already an existing development database.  Read more...
By 2017/10/13 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,715 reads

A Freecon Halloween at the PASS Summit

If you're attending the PASS Summit in 2017, there's a Freecon day on Tuesday you can attend.  Read more...
By Press Release 2017/10/17 (first published: 2017/10/13) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 282 reads

The Blame Game

Equifax is blaming a single IT person for their data breach. Steve Jones worries this is a sign of things to come.  Read more...
By Steve Jones 2017/10/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 126 reads

Group Managed Service Accounts (gMSAs) in SQL2016

Implementing Group Managed Service Accounts (gMSAs) in existing SQL Server instances with AlwaysON  Read more...
Rating: |  Discuss |   Briefcase | 609 reads

The importance of bringing Python to SQL Server

When SQL Server 2017 launched, Microsoft proudly announced that it was the first relational database engine to ship with built-in artificial intelligence (AI) capabilities. But why Python and SQL Server? What is Python? And how does this compare to the R integration in SQL Server 2016?  Read more...
By 2017/10/12 | Source: Redgate | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 4,680 reads

Statistics in SQL: Student’s t-test

Many undergraduates have misunderstood the name 'Students' in the t-test to imply that it was designed as a simple test suitable for students. In fact it was William Sealy Gosset, an Englishman publishing under the pseudonym Student, who developed the t-test and t distribution in 1908, as a way of making confident predictions from small sample sizes of normally-distributed variables. As Gosset's employer was Guinness, the brewer, Phil Factor takes a sober view of calculating it in SQL.  Read more...
By Additional Articles 2017/10/12 | Source: SimpleTalk | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 3,142 reads

Stairway to SQL Server Agent - Level 2: Job Steps and Subsystems

SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although each job also has an owner that determines who can modify the job.  Read more...
By Richard Waymire 2017/10/11 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 7,890 reads

Time is Precious

Time might be the most precious commodity that Steve Jones has in managing life.  Read more...
By Steve Jones 2017/10/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 49 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/10/11 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 86,828 reads

Webinar: how to cut time & disk space for database provisioning by 99%

If you’ve ever worked in a team that uses a single, shared database for development, you know how time-consuming and frustrating it is to provision copies of production databases for development work. In this webinar on October 17, you’ll see how SQL Clone cuts out the pain of provisioning development databases.  Read more...
By 2017/10/16 (first published: 2017/10/11) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,506 reads

Network Configuration of SQL Server Always On Availability Groups in Azure

Implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and network infrastructure services in the Microsoft cloud environment. In this article, Marcin Policht looks at the networking aspects of clustered deployments of SQL Server 2016 in Azure.  Read more...
By Additional Articles 2017/10/11 | Source: Database Journal | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,711 reads

WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits

An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.  Read more...
By Kenneth Igiri 2017/10/10 | Source: SQLServerCentral.com | Category: wait events
Rating: |  Discuss |   Briefcase | 751 reads

Automated Database Provisioning for Development and Testing

If your development team needs to work on anonymised copies of the current production database, and if changes are being delivered rapidly as well, that could mean a lot of time and routine DevOps work copying databases. SQL Clone was designed for tasks like this. Grant Fritchey investigates whether you save time, effort and scripting over the more traditional approach, and at what point it makes sense to use it.  Read more...
By Additional Articles 2017/10/10 | Source: SimpleTalk | Category: provisioning
Rating:  Rate this |   Briefcase | 2,688 reads

Citizen Scientists

More and more people are becoming citizen scientists, even in companies. Steve Jones thinks this is helpful, but we still need professionals.  Read more...
By Steve Jones 2017/10/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

How to examine differences with SQL Compare Summary View and SQL View

In this video, Steve Jones introduces the new Summary View that's now available in Redgate SQL Compare.  Read more...
By 2017/10/10 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,311 reads

Don't Use Code Coverage

Code Coverage is a metric that Steve Jones sees often misused.  Read more...
By Steve Jones 2017/10/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

Azure DWH part 18: Working with SQL Server Analysis Services

In this new article, we will learn how to create a cube extracting data from ADWH.  Read more...
By Daniel Calbimonte 2017/10/09 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 250 reads

Unearthing Bad Deployments with SQL Monitor and Redgate’s Database DevOps Tools

Sudden performance issues in SQL Server can have many causes, ranging all the way from malfunctioning hardware, through to simple misconfiguration, or perhaps just end users doing things they shouldn’t. But one particularly common culprit is when deployments go wrong: I don’t know a single DBA who hasn’t been burned by a bad release.  Read more...
By 2017/10/09 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,641 reads
<< Newer    Items 21 to 40 of 16183    Older >>