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

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

Remembering passwords in SQL Compare and SQL Data Compare

The Redgate SQL Compare team have recently added a feature to automatically populate your SQL Server credentials when you’re using SQL Compare or SQL Data Compare - here are the details of the new feature.  Read more...
By 2017/11/15 | Source: Redgate | Category: sql compare
Rating: (not yet rated)  Rate this |   Briefcase | 1,578 reads

Consuming hierarchical JSON documents in SQL Server using OpenJSON

Over the years, Phil was struck by the problems of reading and writing JSON documents with SQL Server, and wrote several articles on ways of overcoming these problems. Now that SQL Server 2016 onwards has good JSON support, he thought that the articles would be forgotten. Not so, they continue to be popular, so he felt obliged to write about how you can use SQL Server's JSON support to speed the process up.  Read more...
By Additional Articles 2017/11/15 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 2,132 reads

Vagrant and SQL Server 2017 on Linux

Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017  Read more...
By David Poole 2017/11/14 | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 555 reads

How to Do a Free SQL Server Health Check

Brent Ozar shares a free script that that you can run to quickly produce a health check of your SQL Server.  Read more...
By Additional Articles 2017/11/14 | Source: Brent Ozar Unlimited Blog | Category: health check
Rating: (not yet rated)  Rate this |   Briefcase | 3,900 reads

Holiday parties: Do you love them or hate them?

It is getting to be that time of year. Holiday parties are you for them or against  Read more...
By Ben Kubicek 2017/11/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 55 reads

Dynamically Create Warehouse Dimensions

Here's a data warehouse design pattern to speed up multi-value dimension creation.  Read more...
By Craig Benson 2017/11/13 | Source: SQLServerCentral.com | Category: dimension
Rating: |  Discuss |   Briefcase | 862 reads

Alert Inbox Grouping Preview in SQL Monitor

The SQL Monitor team are hard at work, improving how you manage your alerts. Find out more about the changes they're making, and how you can try an online demo of the new features now.  Read more...
By 2017/11/13 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,013 reads

Microservices in SQL Server

In SQL Server 2017 consuming or providing JSON data is so efficient that you can implement effective microservices right from the database, argues Phil Factor.   Read more...
By Phil Factor 2017/11/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 68 reads

Who Owns the Data?

The Microsoft battle to avoid moving data across country borders is interesting.  Read more...
By Steve Jones 2017/11/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 60 reads

Missing Data

In the real world of business or scientific reporting and analysis, data can prove to be awkward. It can be plain wrong or it can be altogether missing. Sure, we have the NULL to signify unknown, but that doesn't play well with regular business reporting. There are a number of ways of dealing with missing information, and methods of estimating data from existing data has a long and respectable history. Joe Celko gets to grips with a data topic that is often treated with some trepidation.  Read more...
By Additional Articles 2017/11/13 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,920 reads

How Long Before You Upgrade?

This Friday Steve Jones wants to know about the lifetime of your instances. Do you have some idea on how long you'll run a particular version of a platform?  Read more...
By Steve Jones 2017/11/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 316 reads

Advanced Analytics with R & SQL: Part I - R Distributions

Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.   Read more...
By Frank A. Banin 2017/11/10 (first published: 2016/10/31) | Source: SQLServerCentral.com | Category: data science
Rating: |  Discuss |   Briefcase | 2,368 reads

Mixing MongoDB and Relational Databases in the Enterprise

Your Agile developers want MongoDB, or a similar document database: your Ops people are concerned about security and backup, and Governance are muttering about transactionality and data transfer between systems. Do you restrict your developers from rapidly-evolving the data design for their domain or do you embrace the joys of NoSQL unconditionally? If you accept a polyglot database environment, where the NoSQL lambs coexist with the relational lions, how do you provide tools and common database concepts that everyone can use and understand?  Read more...
By Additional Articles 2017/11/10 | Source: SimpleTalk | Category: mongodb
Rating: (not yet rated)  Rate this |   Briefcase | 2,838 reads

Introverted vs Extroverted

A lot of us are introverted, so is there anything that can be done about it?  Read more...
By Ben Kubicek 2017/11/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 78 reads

Change Integer to BigInt on a Very Large Table

This article will show how to change the data type of a column when the table contains more than 1 billion records.  Read more...
By Nisarg Upadhyay 2017/11/09 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 1,329 reads

Can the database be included in DevOps in financial services?

For many DBAs who work in financial services, deploying database changes is the most taxing part of the job. Being required to review thousands of lines of script can take days, depending on how many errors you find. Even when database deployments are better planned, it’s not an easy journey, and DBAs are often regarded as the blocker in the process, the ones who are causing the problem rather than trying to resolve it  Read more...
By 2017/11/09 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,664 reads

How to Do a SQL Server Architecture Review

How do you get management to help you figure out if a cluster or an AG is right for you? In this post, Brent Ozar explains the steps involved when doing a review of your SQL Server architecture.  Read more...
By Additional Articles 2017/11/09 | Source: Brent Ozar Unlimited Blog | Category: architecture
Rating:  Rate this |   Briefcase | 4,142 reads

Should We Move to Azure?

This week Steve Jones asks about moving to the cloud and how interesting that might be to the community?  Read more...
By Steve Jones 2017/11/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 219 reads

Stairway to AlwaysOn Level 4: Analyse and Deploy a Windows Server Failover Cluster

In level 4 of the stairway to AlwaysOn we look at creating a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2017/11/08 (first published: 2014/12/10) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 4,834 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2017/11/08 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 64,233 reads
<< Newer    Items 21 to 40 of 16273    Older >>