SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Writing Custom Rules for FxCop

Code review or monitoring inevitably becomes a part of our project’s life cycle. It’s a process which analyzes your code, helps to mitigate issues and reduce the percentage of bugs in testing by performing code cleaning. We can do the code review either manually or, preferably, automatically. In a big project reviewing code manually is […]

Tuning SQL Server 2005 Integration Services for EBCDIC Data Conversion

When searching the Web for solutions to use SQL Server 2005’s Integration Services to convert and load EBCDIC (IBM Mainframe) data, many will hit a massive roadblock. Through exhaustive searches you may be able to return a minimal amount of information, none of which will likely pertain to performance tuning once a conversion solution is […]

Using The Transfer Jobs Task in SQL Server Integration Services

Introduction SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Using Transfer Error Messages and Transfer Master Stored Procedures Tasks in SSIS I discussed how to use the Transfer Error Messages Task […]

Using Transfer Error Messages and Transfer Master Stored Procedures Tasks in SSIS

Introduction SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers and administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS I discussed how to use the Transfer SQL Server Objects […]

SQL Server Security Audit (Part 3) – Operating System Level Audit

Operating system level audits Typically, most DBAs have remote access privilege to the Windows machine hosting the database server. If you have administrator privilege in the Windows box (or VM), you can take some time to try the following: Windows security log This should be actually a part of the DBA’s daily checks. However, as […]

Understanding Scans And Seeks

There is a popular theory on scans and seeks: “Scan reads through the object (table/index) from top to bottom looking for the records that it needs while seek goes directly to the part of the object that it needs and reads to where the data that it needs ends. This is obviously a must more […]

SQL Server Security Audit (Part 2) – Database Level Audit

Once the Server Level audits described in Part 1 of the Security Audit series are complete, databases should be considered next. A number of steps can be taken to audit database level security. Database owners A database owner can perform any action in the database. This includes granting access rights to the database to other users. […]

SQL Server Analysis Services ( SSAS ) – Introduction

Microsoft SQL Server 2005 Analysis Services (SSAS) delivers both online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting the user design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases. For data mining applications, Analysis Services lets the […]

SQL Server Security Audit (Part 1) – Server Level Audit

Although security is a major component of database administration, it is sometimes overlooked in favour of convenience. User accounts are given elevated permissions to save time, patches and hot-fixes are not applied timely and best practices are often not followed. Over time, the server becomes vulnerable to potential breaches of security. As the DBA, you […]

Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS

Introduction SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Transfer Logins Task and Transfer Database Task in SSIS I discussed how to use the Transfer Logins Task and Transfer Database Task […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |