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 197    Older >>
 

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/16 | Source: Redgate | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 1,292 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,345 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,374 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,513 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,411 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 2018/09/14 (first published: 2016/09/15) | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 4,329 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,133 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,669 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,061 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 | 3,868 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,469 reads

Using pw-inspector in Brute Force attack on SQL Server

In this article we're going to explore the world of brute force attacks and pwd-inspector for tests with SQL Server  Read more...
By Anil Kuhat 2018/08/14 | Source: SQLServerCentral.com | Category: brute force
Rating: |  Discuss |   Briefcase | 868 reads

SQL Server Index Tutorial Overview

Although there are many different things that can be done to improve the performance of a database system, creating an index is the main tool in every DBA's toolbox that is used when we are trying to improve the performance of a query.   Read more...
By Additional Articles 2018/08/08 | Source: MSSQLTips.com | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 4,270 reads

Representing XML data in SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.  Read more...
By Diogo Castro 2018/08/07 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,084 reads

Join Redgate’s SQL data catalog early access program

Redgate wants your help to develop a product for SQL Server data classification that meets today’s compliance and DevOps needs. If you’re interested in taking part in research and providing feedback on new releases, please register for the early access program.   Read more...
By 2018/08/07 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,937 reads

Getting Started with Database Development Using SQL Provision

Steve Jones shows how a developer, who is a sysadmin on their own SQL Server instance, can migrate their existing development databases to clones, using SQL Provision. Using a simple PowerShell function, we have seen a repeatable process that is quick and consistent.  Read more...
By 2018/07/30 | Source: Redgate | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,758 reads

Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5

Data for Power BI can come from many sources, but often the data is hosted in SQL Server. In this article, the fifth of the series, Robert Sheldon demonstrates how to work with SQL Server data in Power BI Desktop, including relationships between tables.  Read more...
By Additional Articles 2018/07/30 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 3,656 reads

Placing a Mark in SQL Server's Transaction Log for Fall Back

How many times have you had a programmer come to you and say they want you (the DBA) to restore their database to sometime prior to when they accidentally corrupted it? If you are doing FULL transaction logging you can do a point in time recovery to restore the database to just prior to when the corruption occurred. But in order to do that you need to know exactly when the programmer corrupted the data, which in a lot of cases is not known down to the second.  Read more...
By Additional Articles 2018/07/24 | Source: Database Journal | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,074 reads

Why SQL Developers Keep Making The Same Mistakes

They learned by reading your old code.  Read more...
By Additional Articles 2018/07/20 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 5,033 reads

Fixing ‘A required Privilege is not held by client’ Error

This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out . A required privilege is not held by the client. The step failed.   Read more...
By Vishnu Gupthan 2018/07/16 | Source: SQLServerCentral.com | Category: required privilege
Rating: |  Discuss |   Briefcase | 386 reads
   Items 1 to 20 of 197    Older >>