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

   Items 1 to 20 of 16829    Older >>
 

The Oddest Thing

Steve wonders what strange items live in your workspace.  Read more...
By Steve Jones 2018/05/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 48 reads

SQL Server System Audit Report

Ensuring that your SQL Server is secure is the job of every Database Administrator. In this article I will provide a script to help perform easier audits of your system.  Read more...
By Rudy Panigas 2018/05/25 (first published: 2016/02/02) | Source: SQLServerCentral.com | Category: audit
Rating: |  Discuss |   Briefcase | 4,331 reads

Where Clustered Index Keys Dare

We’ve blogged a couple times about how clustered index key columns get stored in your nonclustered indexes. But where they get stored is a matter of weird SQL trivia. You see, it depends on how you define your nonclustered index.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,526 reads

Choosing Between Table Variables and Temporary Tables

People can, and do, argue a great deal about the relative merits of table variables and temporary tables. Sometimes, as when writing functions, you have no choice; but when you do you’ll find that both have their uses, and it’s easy to find examples where either one is quicker. In this article, Phil Factor explains the main factors involved in choosing one or the other, and demonstrates a few simple ‘rules’ to get the best performance.  Read more...
By 2018/05/25 | Source: Redgate | Category: tsql
Rating: (not yet rated)  Rate this |   Briefcase | 2,626 reads

Using FORMAT() for Dates

Learn how the FORMAT() function works for dates.  Read more...
By Steve Jones 2018/05/24 | Source: SQLServerCentral.com | Category: format()
Rating: |  Discuss |   Briefcase | 1,394 reads

Lessons for all of us

Each of us needs to be sure we take care of our own needs.  Read more...
By Steve Jones 2018/05/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 74 reads

SQL in the City Streamed – Compliant DevOps: June 20 2018

Join Redgate’s livestream on June 20 and learn from Microsoft Data Platform MVPs, Steve Jones, Grant Fritchey, and Kathi Kellenberger. The schedule will include sessions to help you learn how to demonstrate compliance with regulations such as the GDPR, HIPAA and SOX. Find out more and register for free  Read more...
By 2018/05/24 | Source: Redgate | Category: compliance
Rating: (not yet rated)  Rate this |   Briefcase | 1,342 reads

Build and Automate a SQL Server Status Report on Server Restart or Scheduled

Do you know when a SQL Server instance restarts? When you manage many SQL Server instances you may not know when one restarts, so having an automated report emailed to you could be helpful to get an idea what's going on for that instance.  Read more...
By Additional Articles 2018/05/24 | Source: MSSQLTips.com | Category: database mail
Rating: (not yet rated)  Rate this |   Briefcase | 1,765 reads

How DevOps can automate the repayment of technical debt

Looking to DevOps automation to try to create the breathing room needed to break out of the vicious cycle of technical debt.  Read more...
By 2018/05/24 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,436 reads

Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.  Read more...
By Hugo Kornelis 2018/05/23 (first published: 2016/01/20) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,222 reads

Pause and Backtrack

A new feature in AWS will rollback the entire database to a point in time.  Read more...
By Steve Jones 2018/05/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 34 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2018/05/23 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 92,427 reads

SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database

In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph structure using the Graph Database feature.  Read more...
By Additional Articles 2018/05/23 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 1,738 reads

Scheduling a PowerShell Script Using SQL Server Agent

This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.   Read more...
By Vishnu Gupthan 2018/05/22 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 651 reads

Checking CHECKDB

Everyone should be running DBCC CHECKDB on their systems. We not have some help in determining if we are doing this.  Read more...
By Steve Jones 2018/05/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

The 2018 State of DevOps Survey. Don’t just wait for it. Be a part of it.

Redgate is joining forces with DevOps Research and Assessment (DORA) and Google Cloud to support the pursuit of DevOps excellence. The research aim is to better understand the DevOps landscape, and to surface new findings that provide guidance for improvement in resource management, productivity, and quality of technology delivery teams. To have your say and be part of the research, simply take the survey - there are even some great prizes up for grabs!   Read more...
By 2018/05/22 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,684 reads

Why Are You Dropping and Recreating Your Indexes?

Do you have data load processes that drop indexes to optimize the load process? Are you dropping those indexes in one step, then loading data into your table, only to recreate the indexes in a post data load step?  Read more...
By Additional Articles 2018/05/22 | Source: Database Journal | Category: indexing
Rating:  Rate this |   Briefcase | 3,579 reads

Monitoring Distributed SQL Servers using SQL Monitor

Many organizations are experiencing rapid expansion and diversification of their SQL Server estate to include Cloud, VMWare and other platforms, alongside traditional on-premise servers. This article explains the basic architecture and components of SQL Monitor, and then how to set up a distributed monitoring solution.  Read more...
By 2018/05/22 | Source: Redgate | Category: monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,360 reads

SQL Server on Linux, does it have Microsoft's full attention?

SQL Server on Linux doesn't support Ubuntu 18.04 LTS. Why weren't Microsoft ready for the next LTS release?  Read more...
By Thom Andrews 2018/05/21 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: |  Discuss |   Briefcase | 581 reads

A Great Case for Powershell

PowerShell can be very useful for SQL Server professionals.  Read more...
By Steve Jones 2018/05/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 62 reads
   Items 1 to 20 of 16829    Older >>