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

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

Configure Read Only Routing

The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter.   Read more...
By Ganapathi varma Chekuri 2018/02/05 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 563 reads

Add a SQL Server Database to an Existing Always On Availability Group

In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group.  Read more...
By Additional Articles 2018/02/05 | Source: MSSQLTips.com | Category: availability group (ag)
Rating: (not yet rated)  Rate this |   Briefcase | 2,008 reads

Finding the Right Data

Big Data hasn't been in the news, perhaps because more organizations are realizing they need the right data.  Read more...
By Steve Jones 2018/02/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

We Do Need To Upgrade

Security issues in older systems are going to be a problem.  Read more...
By Steve Jones 2018/02/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Bringing DevOps to the database. Part 1: Version control

Continuous delivery, continuous integration, automated release management – the phrases alone are enough to make the talk about DevOps for the database sound more complicated than it actually is - this post explains that the key is to start small.  Read more...
By 2018/02/05 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,015 reads

Liberating the DBA from SQL Authentication with AD Groups

It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.  Read more...
By John F. Tamburo 2018/02/02 (first published: 2015/12/21) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 6,186 reads

Bad Days

This Friday Steve Jones wants you to look back and cringe a bit. Share with the rest of the community what a bad day was for you and see if it was really as bad as you think.  Read more...
By Steve Jones 2018/02/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 230 reads

Install and Configure SQL Server 2017 Availability Groups on Linux - Part 3

In this tip, Edwin Sarmiento looks at how to create the Always On Availability Group with a listener name when using SQL Server on Linux.  Read more...
By Additional Articles 2018/02/02 | Source: MSSQLTips.com | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 2,540 reads

Adaptive Query Processing – Batch Mode Memory Grant Feedback

Explore Batch Mode Memory Grant Feedback that was introduced in SQL Server 2017  Read more...
Rating: |  Discuss |   Briefcase | 509 reads

Change and the ability to adapt

Change is coming are you able to adapt?  Read more...
By Ben Kubicek 2018/02/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Has Your Database Been Backed up in the Last 24 Hours?

As a DBA your #1 responsibility is to make sure that each of your SQL Server databases are backed up. This tip provides a couple of TSQL scripts that will identify the last backup of each database.  Read more...
By 2018/02/01 | Source: Database Journal | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 3,006 reads

Free webinar: Change your SQL Server troubleshooting from reactive to proactive with a monitoring tool

Redgate’s James King and Ben Emmett will demonstrate how to troubleshoot your SQL Server estate, and discuss how it shouldn’t be about reacting to problems when they occur, but rather having the tools to make proactive decisions to plan ahead, identify potential disruptions, fix common problems and make improvements.   Read more...
By 2018/02/01 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,823 reads

Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX All() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to All(), focusing largely upon its most basic uses in manipulating filter context.  Read more...
By Bill Pearson 2018/01/31 | Source: SQLServerCentral.com | Category: stairway series
Rating: (not yet rated) |  Discuss |   Briefcase | 352 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2018/01/31 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 72,400 reads

Thanks for the Memories, Tom

Remembering Tom Roush.  Read more...
By Steve Jones 2018/01/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 101 reads

Historical Stock Prices and Volumes from Python to a CSV File

Python is a versatile language that is gaining more popularity as it is used for data analysis and data science. In this article, Rick Dobson demonstrates how to download stock market data and store it into CSV files for later import into a database system.  Read more...
By Additional Articles 2018/01/31 | Source: SimpleTalk | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,545 reads

Azure DWH part 25: Auditing and threat detection

In this new article, we will show how to audit the Data Warehouse Activities.  Read more...
By Daniel Calbimonte 2018/01/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 205 reads

Lowering the Noise

We are busy as administrators, and it can be very useful to ensure our systems avoid adding to our workload.  Read more...
By Steve Jones 2018/01/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

Network Issue or THREADPOOL waits?

Tara Kizer talks identifying THREADPOOL waits and what you can do about them.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,824 reads

The 2018 State of Database DevOps report

In this year's survey, over 700 IT professionals across a range of sectors, in organizations of every size around the globe were asked about their plans to adopt DevOps, how they thought the database fitted into the picture, and what they thought the biggest challenges were.  Read more...
By 2018/01/30 | Source: Redgate | Category: devops
Rating:  Rate this |   Briefcase | 2,393 reads
<< Newer    Items 41 to 60 of 16539    Older >>