SQLServerCentral.com Content tagged SQL Server

Using XML from data variable option in SSIS

Wed, 15 May 2013 06:00:00 UT

Learn how you can manipulat XML documents solely in memory. No file required.

Retrieve SQL Instance Connect Info

Thu, 11 Apr 2013 06:00:00 UT

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port

HASHBYTES: Is CHECKSUM really required?

Wed, 27 Mar 2013 06:00:00 UT

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.

An in-depth look at change detection in SQL Server - Part 02

Tue, 19 Feb 2013 07:00:00 UT

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.

An in-depth look at change detection in SQL Server - Part 01

Tue, 12 Feb 2013 07:00:00 UT

Finding out whether you are using enterprise level feature

Mon, 21 Jan 2013 07:00:00 UT

The query tells whether sql server enterprise edition is using any enterprise level features or not

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Get an alert whenever SQL Server restarts

Mon, 05 Nov 2012 07:00:00 UT

This script will create a job and it will send a mail whenever SQL server restarts.

Unattended Install with PowerShell

Wed, 15 Aug 2012 06:00:00 UT

A PowerShell script which will guide you through an interview and produce the configuration file(s) necessary for an unattended installation of SQL Server 2008/2008R2.

Map IP Address to a Geographical Location

Fri, 20 Jul 2012 06:00:00 UT

Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.

SQL Triggers in a Security Context

Thu, 12 Jul 2012 06:00:00 UT

This article will show you how to use user-defined triggers to supplement your security policies, preventing unauthorised data manipulation and blocking unfriendly logins.

Documenting the Undocumented

Tue, 26 Jun 2012 06:00:00 UT

Not everything in SQL Server is documented and Steve Jones doesn't think that everything should be. However some features are used often and should have additional documentation.

Change Tracking - 2008

Mon, 18 Jun 2012 06:00:00 UT

Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.

The Sequence Object in SQL Server 2012

Mon, 04 Jun 2012 06:00:00 UT

The Sequence Object is one of the many exciting new features introduced in SQL Server 2012. Learn what this new feature can do for you and how you can use it.

What, when and who? Auditing 101 - Part 3

Thu, 31 May 2012 06:00:00 UT

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.

How to create a database backup using visual studio

Fri, 30 Mar 2012 06:00:00 UT

This article describes how to backup a database using a C# Windows Form.

Report Builder or Reporting Services?

Tue, 27 Mar 2012 06:00:00 UT

Should you be using Report Builder 3.0 or SQL Server Reporting Services 2008 R2 to build reports? Here's the 411!

Session complete status and estimated completion time

Wed, 21 Mar 2012 06:00:00 UT

A small retake on the popular percent complete script which tell how much more time an executing command will take.

What, when and who? Auditing 101 - Part 2

Mon, 16 Jan 2012 07:00:00 UT

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.

Find Last Restart of SQL Server

Tue, 27 Sep 2011 06:00:00 UT

How can you tell when your SQL Server instance was last started? In this tip we look at various methods of how to get the start time for a SQL Server instance.

SQL Code Reuse: Teaching a Dog New Tricks

Mon, 26 Sep 2011 06:00:00 UT

Developers, by every natural instinct and training, strive to make their code reusable and generic. Dissuading them from doing so, in certain circumstances, is akin to trying to persuade a dog not to fetch a stick.

10 Bad Things About Reporting Services 2008 R2

Tue, 06 Sep 2011 06:00:00 UT

SSRS 2008 R2 introduced lots of exciting new features, reviewed in a sister article to this one. Here we consider what Microsoft didn't do well in this version of Reporting Services.

10 Good Things About Reporting Services 2008 R2

Mon, 05 Sep 2011 06:00:00 UT

The 10 things Microsoft got right about SQL Server Reporting Services 2008 R2 (a sister article shows 10 things which aren't quite so good)

Using PowerShell to Manage SQL Server

Tue, 16 Aug 2011 06:00:00 UT

The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

NetApp Dynamic Backup Script

Tue, 09 Aug 2011 06:00:00 UT

TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases

Get SQL Server IP Address

Tue, 02 Aug 2011 06:00:00 UT

To Get Server IP Address without having to log into box or RDP

Changing Primary key names to standard naming convention across the DB

Fri, 29 Jul 2011 06:00:00 UT

This script will rename the Primary keys to standard notation - PK_TableName

Rateio do valor do Item na Nota - Totvs RM

Wed, 13 Jul 2011 15:19:06 UT

Essa função calcula a porcentagem do Item em relação ao valor da nota. Aplicável a Totvs RM. Em especial RM Núcleus.

Create INSERT statements from Excel

Mon, 02 May 2011 06:00:00 UT

Excel files includes a very good functionality called Macro execution. And here we can use this functionality to write one macro that will generate INSERT statements.

Paging Doctor Powershell

Mon, 04 Apr 2011 06:00:00 UT

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.

Vote for Me for a PASS SQLRally Precon on SQL Server Security

Thu, 28 Oct 2010 06:00:00 UT

Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...