Click here to monitor SSC
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 133    Older >>

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 2016/09/15 | Source: | Category: microsoft
Rating: |  Discuss |   Briefcase | 2,187 reads

Azure SQL Limitations compared with a SQL Server Enterprise

In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.  Read more...
By Daniel Calbimonte 2016/07/26 | Source: | Category: azure sql database
Rating: |  Discuss |   Briefcase | 1,826 reads

Using IronPython to talk to SQL Server

IronPython is a Python implementation build on .NET. This article shows how you can use IronPython to access SQL Server Management Objects.  Read more...
By Gerald Britton 2016/06/13 | Source: | Category: ironpython
Rating: |  Discuss |   Briefcase | 1,427 reads

The Politics of SQL Security

Dealing with SQL Server security when the application it uses is full of security holes.  Read more...
By Scott Crosby 2016/05/23 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 133 reads

SQL Server Resource Governor

Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.  Read more...
By Arun Sirpal 2016/04/26 | Source: | Category: resource governor
Rating: |  Discuss |   Briefcase | 1,544 reads

Migrating an on premise SQL Server Database to Azure

For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.  Read more...
By Arun Sirpal 2016/04/21 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 1,299 reads

Using PowerShell for SQL Server Replication Tracking

Tim Smith shows how using PowerShell can be an effective way to track SQL Server snapshot and transactional replication counts for sources and destinations.  Read more...
By Additional Articles 2016/01/28 | Source: | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,748 reads

SQL Server Memory

SQL Server Memory in Task Manager - Should I be Worried?  Read more...
By Ginger Keys 2015/12/14 | Source: | Category: memory
Rating: |  Discuss |   Briefcase | 7,629 reads

Doing a SQL Server Healthcheck via PowerShell

PowerShell is an ideal tool for doing health-checks of a collection of SQL Server instances, and there are several examples around, but few acknowledge the fact that individual DBAs have their own priorities for tests, and need something easily changed to suit circumstances. Omid Afzalalghom's Healthcheck allows tests to be SQL or PowerShell and requires only adding, altering or deleting files in directories.  Read more...
By Additional Articles 2015/12/01 | Source: SimpleTalk | Category: healthcheck
Rating:  Rate this |   Briefcase | 4,311 reads

How to Confuse the SQL Server Query Optimizer

Want to 'trick' SQL Server into performing millions of logical reads to return data, when only are few thousand were really required? In this article, Gail Shaw examines three common forms of generic SQL that can and will confuse the SQL Server Optimizer to the point that it generates and reuses very inefficient execution plans.  Read more...
By Additional Articles 2015/09/21 | Source: SimpleTalk | Category: query optimizer
Rating:  Rate this |   Briefcase | 3,457 reads

PowerShell and ADO.NET Connection String Settings for SQL Server

Tim Smith addresses some common questions from PowerShell developers about connection strings, errors with strings, and alternative development approaches to using connection strings.  Read more...
By Additional Articles 2015/09/11 | Source: | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,230 reads

SSIS Package documentor

Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.   Read more...
Rating: |  Discuss |   Briefcase | 9,267 reads

Identify SQL Server Database Growth Rates

Unchecked SQL Server database growth can hurt the bottom line of organizations in the form of poor application performance and increased infrastructure costs. In this article, Marios Philippopoulos looks at whether there's an easy way to proactively obtain a recent list of the fastest-growing databases in a SQL Server instance using information captured by default in the database engine.  Read more...
By Additional Articles 2015/08/26 | Source: | Category: database growth
Rating: (not yet rated)  Rate this |   Briefcase | 3,486 reads

SQL Server Performance Dashboard Reports

Setting up SQL Server Management Studio (SSMS) based performance dashboard driven off servers that are registered through a Central Management Server (CMS).  Read more...
By Arun Sirpal 2015/08/20 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 8,174 reads

Changing SQL Server Database Logical Names

SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.  Read more...
By Shawn Melton 2015/07/20 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 5,098 reads

SQL Server Downloads

A list of the free version, tools, and sample downloads.  Read more...
By Site Owners 2015/06/23 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 3,557 reads

Shredding Unicode Japanese characters using SSIS

This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS  Read more...
By Arun Mishra 2015/03/31 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 551 reads

What, when and who? Auditing 101 - Part 3

Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.  Read more...
By Roy Ernest 2014/12/19 (first published: 2012/05/31) | Source: | Category: auditing
Rating: |  Discuss |   Briefcase | 13,758 reads

What, when and who? Auditing 101 - Part 2

In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.   Read more...
By Roy Ernest 2014/12/12 (first published: 2012/01/16) | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 12,905 reads

Document, then Install

Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running before we install rather than documenting it afterwards.  Read more...
By Steve Jones 2014/10/13 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 106 reads
   Items 1 to 20 of 133    Older >>