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

Articles with tag SQL Server Rss

Search for any content tagged sql server

   Items 1 to 20 of 206    Older >>
 

Top 10 Databases for 2019

A look at ten top databases fighting for mind-share in 2019.  Read more...
By Additional Articles 2019/02/19 | Source: Database Journal | Category: database
Rating:  Rate this |   Briefcase | 4,113 reads

Which Version of SQL Server Should You Use?

Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version?  Read more...
By Additional Articles 2019/02/08 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,828 reads

Cleanup SQL Server Query Store Data After Database Restore

In this tip we look at how to cleanup the SQL Server query store after a database has been restored to ensure that query store starts data collection starts fresh.  Read more...
By Additional Articles 2019/01/30 | Source: MSSQLTips.com | Category: cleanup
Rating:  Rate this |   Briefcase | 1,981 reads

Introduction to Microsoft R Services in SQL Server 2016

General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.  Read more...
By Tomaž Kaštrun 2019/01/25 (first published: 2016/09/15) | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 5,112 reads

Working with SQL Server Stored Procedures and .NET

Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.  Read more...
By Additional Articles 2019/01/03 | Source: MSSQLTips.com | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,855 reads

How Much Memory is “Normal” for SQL Servers?

When I look at a SQL Server, one of the first things I check is, “How much memory does this thing have relative to the amount of data we’re hosting on here?” I’ve long used some seat-of-the-pants numbers, but armed with data from SQL ConstantCare® users who opted into public data sharing, let’s do a little deeper analysis.  Read more...
By Additional Articles 2018/12/07 | Source: Brent Ozar Unlimited Blog | Category: memory
Rating: (not yet rated)  Rate this |   Briefcase | 4,364 reads

SQL Server Auditing for HIPAA and SOX – Part 4

Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities.  Read more...
By Additional Articles 2018/11/27 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,248 reads

How Check Constraints MIGHT Improve Your Queries and Missing Index Requests

In theory, you get better execution plans when SQL Server understands the contents of your tables. In practice, well, it's hit or miss.  Read more...
Rating:  Rate this |   Briefcase | 3,745 reads

Use SQL Server? We’d like to hear from you.

We are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes. As a thank you for your time, we will be giving away one $100 Amazon gift card to one randomly selected participant who completes the survey by December 7, 2018. Take part here.  Read more...
By 2018/11/22 (first published: 2018/11/16) | Source: Redgate | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,385 reads

Use SQL Server? We’d like to hear from you.

We are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes. As a thank you for your time, we will be giving away one $100 Amazon gift card to one randomly selected participant who completes the survey by December 7, 2018. Take part here.  Read more...
By 2018/11/22 (first published: 2018/11/16) | Source: Redgate | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,385 reads

Spotting Unauthorized Configuration Settings in SQL Server

In this article, Phil Factor explains how to detect any changes in server or database configuration settings, using Extended Events, and a custom metric, in SQL Monitor. He’ll then refine the technique to report on unauthorized drift in the value of these settings, by storing the officially agreed values in an extended property and comparing them to the current values.  Read more...
By 2018/10/25 | Source: Redgate | Category: configuration settings
Rating: (not yet rated)  Rate this |   Briefcase | 2,611 reads

Generate documents from SQL Server

Automating population of SQL Server data into Word and PDF document templates for contracts, invoices,letters etc. creation saves thousands of hours for businesses. This article explores various approaches and offers few suggestions on how to choose the best approach for your requirements.   Read more...
By Murthy TS 2018/10/08 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,407 reads

Adaptive Query Processing in SQL Server

Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,731 reads

The Changing Role of SQL Server Monitoring

As SQL Server estates continue to grow quickly, and change in nature, due to the ease with which new cloud-based, containerized or virtual machine-based SQL Servers can be provisioned, so too the role of the monitoring tool changes.  Read more...
By 2018/09/19 | Source: Redgate | Category: sql monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,648 reads

Introduction to Microsoft R Services in SQL Server 2016

General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.  Read more...
By Tomaž Kaštrun 2019/01/25 (first published: 2016/09/15) | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 5,112 reads

Questions About Kerberos and SQL Server That You Were Too Shy to Ask

Kerberos authentication is a topic that many database administrators avoid. It’s really not that difficult to understand, but it’s also easy to get wrong. In this article, Kathi Kellenberger talks about what you need to know about configuring Kerberos for SSRS and SQL Server databases but were too shy to ask.  Read more...
By Additional Articles 2018/09/10 | Source: SimpleTalk | Category: kerberos
Rating: (not yet rated)  Rate this |   Briefcase | 3,370 reads

Foundational Material: Microsoft SQL Server Book and Blogs From The Past

Erik Darling dusts off his favorite archival-quality bloggers and books.  Read more...
By Additional Articles 2018/09/07 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating:  Rate this |   Briefcase | 2,898 reads

Setting Up SQL Server: People Still Need Help

Erik points out a few things that SQL Server should offer to configure by default.  Read more...
By Additional Articles 2018/08/24 | Source: Brent Ozar Unlimited Blog | Category: setup
Rating:  Rate this |   Briefcase | 4,604 reads

How to Resize tempdb

When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. To make sure you size tempdb appropriately you should monitor the tempdb space usage. If there are autogrowth events occurring after you have recycled SQL Server than you might want to increase the size of your tempdb data files. If tempdb never uses most of the tempdb space, then you might want to consider decreasing the size of tempdb.  Read more...
By Additional Articles 2018/08/21 | Source: Database Journal | Category: tempdb
Rating: (not yet rated)  Rate this |   Briefcase | 4,093 reads

How to Check Performance on a New SQL Server

Before you go live, test your backup and CHECKDB speeds.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,692 reads
   Items 1 to 20 of 206    Older >>